Skip to Content
0
Former Member
Jan 13, 2011 at 08:51 AM

Get the sum/product of two UDF rows before adding A/R Invoice

41 Views

Hi Everyone,

I am making some tests here where I am trying to get the sum or product of two UDF rows in a service type A/R invoice where I need to get the product before i even add the document.

The query goes like:

SELECT T0.[U_UDF1] * T0.[U_UDF2] FROM INV1 T0 WHERE T0.[U_UDF1] = $[INV1.U_UDF1]

It did not work. Is this possible?

Thanks,

Derrick