web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    RE: Customer Ledger account not tally with ledger entries

    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
    RE: Customer Ledger account not tally with ledger entries

    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
    RE: Customer Ledger account not tally with ledger entries

    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
    RE: Customer Ledger account not tally with ledger entries

    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,241 Super User 2025 Season 2 on at
    RE: Customer Ledger account not tally with ledger entries

    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
    RE: Customer Ledger account not tally with ledger entries

    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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans