Discussions – Dynamics GP – Dynamics Communities

detail GL TB rounding issue

Dynamics GP

detail GL TB rounding issue

Posted by DSC Communities on January 16, 2017 at 7:14 pm
- Jason Headrick
  
  Member
  
  January 16, 2017 at 7:14 PM
  
  We closed the year in the GL on Saturday. Now when users run the GL Detailed TB, the debits and credits show rounded to the whole number. 150,000 vs. 150,000.25. The report isn’t modified and all users are getting the same results. We don’t use multicurrency but did run a sql script to validate the all debits equal credits. Any ideas?
  
  ——————————
  Jason Headrick
  Progressive Leasing
  Draper UT
  ——————————
- Carol Kossoris
  
  Member
  
  January 17, 2017 at 3:10 PM
  
  Are you running the Trial Balance under Reports in GP or in Management Reporter?
  
  The report in GP uses a calculated field with the field format Decimal Places Currency. Check the this format type has not been changed in report writer.
  
  The report in Management Reporter has a rounding option. Please check to make sure rounding has not been changed to whole dollars.
  
  ——————————
  Carol Kossoris
  GP Consultant
  Heartland Business Systems, LLC
  Pewaukee WI
  ——————————
  ——————————————-
DSC Communities replied 7 years, 6 months ago 1 Member · 0 Replies
0 Replies

Sorry, there were no replies found.

The discussion ‘detail GL TB rounding issue’ is closed to new replies.