Customer Ledger account not tally with ledger entries

(0) Share

Report

Posted on by Karla30

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

All responses (6)

Answers (0)

Surender.Sharma 5 on at

Like (0)

Report

RE: Customer Ledger account not tally with ledger entries

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

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

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.
Suggested answer

azelaya59 2,807 on at

Like (0)

Report

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.
I Gusti Made Ari 3,594 on at

Like (1)

Report

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.
Karla30 15 on at

Like (0)

Report

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 3,594 on at

Like (1)

Report

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).