Thursday, January 19, 2017

Dynamics GP - Report Writer - Display 0 dp for Quantity on SOP Invoice


  • 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)

No comments:

Post a Comment