Customer balance list report

(3) Share

Report

Posted on by ZU-10061813-0

Customer balance list report is not picking up transaction debiting Advance Payments and crediting Accounts Receivable. This is causing the 121101 listing to be missing a $251.69 credit. The 220011 listing is missing a $251.69 debit.
Report: Credit and collections > Inquiries and reports > Customers > Customer balance list report
Customer: 1192
Voucher: ARPV0006345
1) Why are these not picked up by the report?
2) How can we fix this so the report matches the GL again?
We use this report as a subledger for reconciliation so it's important that it ties.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Alireza Eshaghzadeh 14,743 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,
Please check if you have any filters applied before generating the report.

If not, kindly verify whether the specific transaction has the Approved flag set.

Was this reply helpful? Yes No
Suggested answer

Arvind Bharti 785 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

HI,

Two things to check

1. As mentioned is there any filter while you run the report

2. Can you the transaction you are refferring as advance was posted in sub ledger , does that appear in customer transactions?

3. If yes the you can try to add that account in filter while running this report and see if that transactions appears

Was this reply helpful? Yes No