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) / Customer Ledger accoun...
Microsoft Dynamics NAV (Archived)

Customer Ledger account not tally with ledger entries

(0) ShareShare
ReportReport
Posted on by Karla30 21

Hi,

Im just new in the community and just recently using Microsoft dynamics NAV. I have a problem with my customer ledger account. It does not tally with the Ledger Entries itself.

I have zero receivables from the customer but it appears on the customer list that I still have a negative amount. The reason also why my Aged AR aging is not tally.

What should I do with these negative amount to tally my records.

*This post is locked for comments

I have the same question (0)
  • I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,600 on at

    First check your AR account whether "Direct Posting" is enabled , this should be "disabled". and also check the difference whether due to someone posting directly to AR Account (you can do this by filter "System-Created Entry" to No  n g/l entry).

  • Karla30 Profile Picture
    Karla30 21 on at

    Thank you for the info, I Have checked the AR account for manual entry. Aside from that, is there any possible reason for the difference? Like foreigh exchange? How could I check it?

  • I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,600 on at

    please check also all customer posting group tagged to  your customer card, whether it's using correct G/L Account . another way is write a report to match and find out  the details.

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at

    Karla30

    To answer your question on foreign exchange, the GL only posts in LCY. The customer card will have to flow-fields, one for the customer currency the other for LCY. Check everything "I Gusti Made Ari Permadi" suggested. Also, make sure you are looking at the "Full Customer Ledger" in comparison to the flow-field on the front page of the customer card. This only reflects whats due and not the full picture.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,277 Super User 2025 Season 2 on at

    There are a few reasons why your customer and general ledger does not match: someone posted directly to the GL, someone changed the Posting Group in the middle of transactions, etc.

    Checking the direct posting is quite easy by looking at System-Created Entry at GL Entry.

    For others, you will need to create reports to compare the two ledgers.

  • Surender.Sharma Profile Picture
    Surender.Sharma 5 on at

    Please advise type of report to compare two ledgers as suggested & how to create it?

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