Skip to Content
0
Former Member
May 12, 2008 at 08:10 AM

Formatted Search on A/R Invoice Row level

42 Views

Hi All,

I need your help to do some arithmetical functions on UDFs.

I have three UDFs at row level of A/R Invoices.

U_MRP, U_AssValue (Unit & Totals -> Amount)

U_abtment (Unit & Totals -> Rate)

I want to do below process, but it gives me error.

Select ($($38.U_MRP) - ($($38.U_MRP)* $($38.u_abtment))/100) * $($38.11.0)

but it gives me error. Can any body help me to correct this query to set on U_AssValue as formatted search.

Its very urgent & Important for me.

Best Regards,

Chintesh Soni