- Create a calculated field of type integer equal to the Quantity field
- Integer fields naturally have 0 dp, and require no formatting
- To display 2 dp, create a calculated field of type currency equal to the Quantity field
- go to the field properties, and select the formatting from the SOP Work Amounts table > Decimal Places Currency
- This will force it to format to the currency decimals for this item (which should be 2)
- To remove the $ sign, apply the format DLR_RB0_STR, remove the format field (set to none)
Thursday, January 19, 2017
Dynamics GP - Report Writer - Display 0 dp for Quantity on SOP Invoice
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment