Skip to Content

How to assign calculated values in a field in PO

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 17, 2018 at 07:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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