FMS Required for Price in PO

[Former Member]

Hi..

Can anyone please suggest me the FMS as per below requirement.

I have created 1 UDF say U_Prc (New Price), I will enter price in that field at the time of Purchase Order but as soon as I enter price in UDF my actual price field should calculate as follow U_Prc/254.

Please suggest FMS on how to perform this action.

Thanks,

Harshal Makwana

[frank_wang6 · Accepted solution]

Create a FMS query

SELECT $[POR1.U_Prc.Number]/254

on Price field, press Shift+Alt+F2, and choose the above query, and auto refresh on U_Prc.

[Former Member · Accepted solution]

Hi Frank,

I have created FMS but I am getting 0 value instead of 0.3937. I have value in U_prc is 100.

Thanks,

Harshal

[Former Member · Accepted solution]

Hi,

Use this

SELECT $[POR1.U_Prc.Number]*1.0/254

When u get fractional values SQL will give only Zero as result , so multiply with 1.0 to get correct answer.

[Former Member · Accepted solution]

Hi Bharathiraja,

Thanks very much for the solution.

Regards,

Harshal