Skip to Content
Former Member
Mar 06, 2009 at 10:50 AM

Formatted Search Query


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.


Wynand Cilliers.