News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Aged receivables and p...

Small and medium business | Business Central, N...

Suggested answer

Aged receivables and payables not balancing to GL

(0) Share

Report

Report

Posted on by Community member

I have several responsibility centres which have a G/l on Trade debtors not agreeing to the aged reports. Both TB and report run for same date

Has anyone encountered this and what was the problem?

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

Aged receivables and payables not balancing to GL

1. Make sure that Direct Posting is turned off in the chart of accounts for your associated GL accounts.

2. Search the general ledger entries for 'system-created entry' = NO, this will show you entries that were posted directly to the GL and did not run through a customer or vendor.
Suggested answer

KasparsSemjonovs 3,962 Super User 2024 Season 2 on at

Like (0)

Report

Aged receivables and payables not balancing to GL

Would be great if You can find the entry that is causing the mismatch. Usually that is done, by creating the report on several dates, and try to find the last date when it was matching, and first day that it shows differences.
Then investigate that one date transactions for this Responsibility center. If there are a lot of daily transactions, it could be quite a time consuming task.

Once you know the transaction that is causing the issue - You can investigate it further, or we can help to provide some insights regarding it.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans