SELECT (T0.[DocTotal] * T1.[U_DepositFraction]) FROM OPOR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T1.[CardCode] = $[$4.1.0]
hi guys, above is what i thought was the correct format for multiplying the document total on a PO by a deposit stored in the BP master data. But the value it gives me is wrong.
so if the document total is 10000 and the deposit for the BP is 30% ( 0.3 ),
I need my header-level UDF to show 3000. which equals 10000 * 0.3
I had set the formatted search to auto refresh when the document total field changes. where am i going wrong?
Thanks again
Edited by: Groovy UK on Feb 24, 2009 2:36 PM