- 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)
Wednesday, February 15, 2017
Dynamics GP - Report Writer - Force display 2dp currency for Prices even when currency is set to 5 for all currencies
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment