web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Customer balance list ...
Finance | Project Operations, Human Resources, ...
Answered

Customer balance list report

(3) ShareShare
ReportReport
Posted on by ZU-10061813-0 52
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)
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,867 Super User 2026 Season 1 on at
    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.


  • Suggested answer
    Arvind Bharti Profile Picture
    Arvind Bharti 841 Super User 2026 Season 1 on at
    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
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 677 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 620

#3
Subra Profile Picture

Subra 483

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans