Wednesday, February 15, 2017

Dynamics GP - Report Writer - Force display 2dp currency for Prices even when currency is set to 5 for all currencies


  • Create Calculated Field zMCDP2 as Integer
    • Use formula
    • function_script(rw_currency_getphantomindex (c)Currindexbody 3)
  • For each field you want to format, double click on it
    • In the formatting window, in the bottom right menu, click on the table name until you see "Calculated Fields"
    • Select zMCDP2
    • Click ok
    • This will force the field to use the value of zMCDP2 as the format
    • The last parameter can be changed for the amount of decimal places you want to display  (0dp = 1, 1dp = 2, 2dp = 3)

No comments:

Post a Comment