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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Trial Balance Report I...
Microsoft Dynamics NAV (Archived)

Trial Balance Report Issue

(0) ShareShare
ReportReport
Posted on by Community Member

Hi there,

When I run Trial Balance report it shows 15000$ debit for one on the accounts, but when I check GL entries for the same period its not showing any variance. Does anyone know how Trial Balance report calculate values for debit and credit for different accounts?

Regards,

Danny

*This post is locked for comments

I have the same question (0)
  • npanchal Profile Picture
    npanchal on at

    what are the filters are you applying in both report and g/l entries?

  • Community Member Profile Picture
    Community Member on at

    Thanks for replay Nileshkumar,

    For the report I use the store code and the date range as filter, in the preview it shows 15000$ debit for account 1365.

    In G/L I use the account number as filter.

    1365 is the account that suppose to be balanced off.

  • Suggested answer
    npanchal Profile Picture
    npanchal on at

    Is store code is your Dimension?

    Just use the Date Filter in both report and G/L Entry.

  • Community Member Profile Picture
    Community Member on at

    Yes the store code is my dimension.

    Sorry maybe I haven't explain it good enough, when I run the report for the store for a specific period of time it shows 15000$ debit for account 1365. When I saw the variation I went to g/l to check where its coming from, in g/l I used the same filter for store and date range but the result is not the same. What I am wondering is how debit in Trial Balance report has been calculated? is it using anything else beside g/l table?  

  • npanchal Profile Picture
    npanchal on at

    Does your report has any customization?

  • Community Member Profile Picture
    Community Member on at

    No nothing

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans