Skip to Content
0
Former Member
Jan 28, 2010 at 06:44 AM

UDF computation

34 Views

Hi experts,

I have created 3 UDFs in A/R Credit Memo - row level RPC1:

U_Quantity (type Units and Total - Quantity)

U_Price (type Units and Total - Price)

U_Total (type Units and Total - Amount)

U_Total=U_Quantity*U_Price

Below is my sql statement:

1st

DECLARE @Qty numeric(19,6)

DECLARE @Price numeric(19,6)

DECLARE @Total numeric(19,6)

set @Qty = $[RPC1.U_Quantity]

set @Price = $[RPC1.U_Price]

set @Total = @Qty*@Price

Select @Total

2nd

$[$39.U_Quantity.0]*$[$39.U_Price.0]

I applied these statements on the U_Total refresh(displayed value) based on U_Price but I received error message 8180 when I click on the magnifying glass or press shift+f2.

Please advice.

Best regards,

Lim

Edited by: Tou Lead Lim on Jan 28, 2010 7:44 AM