Skip to Content
0
Former Member
Feb 24, 2009 at 01:36 PM

calculations in a FS

30 Views

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