Skip to Content
0
Former Member
Jan 10, 2008 at 04:35 PM

Calculation Query

20 Views

Some of our customers order single items and some order in cases. We have the master item list set up as 1 for the Items per sales unit and some other number for the Quantity for Packaging uom. This latter # can vary for different items.

I defined a field called U_Case_order in the RDR1 table that will allow the order taker to enter a case quantity. I then set up a Query as follows:

SELECT T0.SalPackUn * T1.U_Case_order AS 'Quantity' FROM dbo.OITM T0 INNER JOIN dbo.RDR1 T1 ON T1.ItemCode = T0.ItemCode AND T1.ItemCode = T0.ItemCode.

Finally, I defined a formatted search for the Quantity field using this query to refresh when I leave the U_Cae_order column. The result is blank with no error message.

Can anyone help?