Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Trial Balance Report Issue

(0) ShareShare
ReportReport
Posted on by

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

  • Community Member Profile Picture
    on at
    RE: Trial Balance Report Issue

    No nothing

  • npanchal Profile Picture
    on at
    RE: Trial Balance Report Issue

    Does your report has any customization?

  • Community Member Profile Picture
    on at
    RE: Trial Balance Report Issue

    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?  

  • Suggested answer
    npanchal Profile Picture
    on at
    RE: Trial Balance Report Issue

    Is store code is your Dimension?

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

  • Community Member Profile Picture
    on at
    RE: Trial Balance Report Issue

    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.

  • npanchal Profile Picture
    on at
    RE: Trial Balance Report Issue

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

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans