web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP Historical Detailed Trial Balance does not calculate Net Change properly

(0) ShareShare
ReportReport
Posted on by 433

I came across an interesting bug in the Historical Detailed TB report.  When you run the report with subtotals for periods, it does not calculate the Net Change properly.  It calculates the ending balance, total debits and total credits correctly.  The Net Change actually picks up the transaction amount of the first transaction for the next oeriod.  When it gets to the last period on the report for an account, then it calculates the correct net change.

This is not a modified report, it is an original GP report..  I also ran it at two different customer sites with the same results.  

 I ran the reconciler.  That didn't resolve it.  The current year TB report processes correctly as well.

Has anyone else come across this?  Is there a fix or a work around for it? 

Many thanks.

Jim

*This post is locked for comments

I have the same question (0)
  • Olaf Laos Profile Picture
    1,890 on at

    What version and build of GP is this?

  • Jim Deady Profile Picture
    433 on at

    GP 10 SP 3 and GP 10 SP 5.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans