Finance | Project Operations, Human Resources, ...

Customer balance list report

(1) 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

All responses (2)

Answers (0)

Suggested answer

Arvind Bharti 438 on at

Like (0)

Report

Customer balance list report

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

Alireza Eshaghzadeh 13,693 Super User 2025 Season 1 on at

Like (0)

Report

Customer balance list report

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.