Formatted Search

[Former Member]

HI

i am new to SAP B1 i want to know how to multiply two UDF fields in purchase order ..

eg : wt per piece * rate per kg = unit price.. pls tell me any add on required for that ..

[former_member1269712]

Hi Jaya,

Try this....

SELECT $[por1.U_wtperpc.Number]*$[por1.U_rateperkg.Number]

Thanks

Sachin

[Former Member]

Hi

Following is the example

Select ((SELECT $[$39.U_TaxPrice.NUMBER])

• (SELECT $[$39.U_Rate.NUMBER]))

Thanks

Kamlesh

[zal_parchem2]

Hello Jaya - you do not need any add on to multiply two UDFs...

An SQL simply written (you need to replace the names for the UDFs) like this:

SELECT

(T0.U_udf1 * T0.U_udf2) AS 'Unit Price of UDF'

FROM OPOR T0

Regards - Zal