Hi All,
I am trying to apply a formatted seach to run a query, but I am struggling so any advise would be greatly appreciated.
I am trying to accomplish the following;
When the quantity field has been populated in a purchase order I want to multiply that with the amount displayed in the 'Items Per Purchase Unit' field on the OITM of the item selected.
The query I currently have return various values which doesnt even make sense. So obviously there is something wrong with my query;
{SELECT T0.[NumInBuy] * $[$38.U_QTY.0] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0]}
If anyone could assist I would appreciate it.
Thanks,
Wynand Cilliers.