	@Test
	public void testExisitingSalesOrderItemSearchTyped() {

		EntityManager em = emf.createEntityManager();
		String soId = "11111";
		TestFactory tf = new TestFactory();
		SalesOrderItem soItemAct = null;
		try {
			// Add Sales Order Item
			assertTrue("Sales Order Item", tf.createSalesOrderItem(em, soId));
			// Search for Sales Order Item
			TypedQuery<SalesOrderItem> query = em.createNamedQuery("SalesOrderItem.getSOIBySalesOrderItemId",
					SalesOrderItem.class);
			soItemAct = query.setParameter("id", soId).getSingleResult();

			assertEquals(
					"Search via typed query for existing sales order item: Added sales order item Gross Amount not persisted in the database",
					BigDecimal.valueOf(13224), soItemAct.getGrossAmount());
			tf.deleteSalesOrderItem(em, soId);
		} finally {
			em.close();
		}
	}