Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Customer balance list report

(2) ShareShare
ReportReport
Posted on by 38
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:
  • Suggested answer
    Arvind Bharti Profile Picture
    443 on at
    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 Profile Picture
    13,693 Super User 2025 Season 1 on at
    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.


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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans