How to assign calculated values in a field in PO

[karenkang]

Hi,

The equation is C=A*B, and A, B, C are all the fields of the same PO. How could I assigned the value of A*B to field C?

Thank you for the help

[former_member329644]

Hi Ya-Chun,

You can achive this through FMS.

Please provide field name along with table to help you to get FMS.

Thanks,

Harshal Makwana

[karenkang]

Hi Harshal,

Below is related info.

Table: PQT1 (Purchasing Quotation)

A: U_Gross_W

B: U_OPQT_Material_Price

C: U_OPQT_Material_Amount

Thank you so much for the help.

Karen Kang

[former_member329644]

Hi Ya-Chun,

Select Distinct $[PQT1.U_Gross_W]*$[PQT1.U_OPQT_Material_Price] from PQT1

Save above query first without running.

Then apply FMS in "U_OPQT_Material_Amount" field. To apply FMS query in "U_OPQT_Material_Amount" field press Alt+Shift+F2 and select "Search in Existing User-Defined Values According to Saved Query" and select your FMS query and press OK.

You can search more on google on hot assin FMS query.

Do let me know if you need some more guidance.

Thanks,

Harshal Makwana