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 / Small and medium business | Business Central, N... / Customer payments
Small and medium business | Business Central, N...
Suggested Answer

Customer payments

(0) ShareShare
ReportReport
Posted on by DS-03071346-0 6
Our auditor is asking for a list of customer payments and invoices applied to (as well as discounts taken) for a specific time period.  I do not find any report available in BC for this information.  It is is a cumbersome process of looking at the bank account ledger entries for payments then going into each customer's ledger entries to find how the payment was applied.  This is not a very friendly software for simple reports of information.
 
Does anyone know of any way to see this information in one place?
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,629 Super User 2026 Season 1 on at
    Hi, isn't it possible to filter Document Type directly in Customer Ledger Entries? Payment or Invoice.
     
    As for how to apply it, this can only be done in Detailed Customer Ledger Entries, which is really inconvenient.
     
    Hopefully other experts can give you better advice.
     
    Thanks.
    ZHU
  • DS-03071346-0 Profile Picture
    DS-03071346-0 6 on at
    Yun Zhu...Yes we can filter customer ledger entries to payment or invoice.  However, we are in need of a report for all customers, all payments for a specific time period to show how payments were applied.  Hard to believe a financial software can't provide this basic report.
  • VJ-27040923-0 Profile Picture
    VJ-27040923-0 22 on at
    Hi,
     
    I saw the comment from Yun Zhu, you can use that with little changes. 
     
    you can navigate to Detailed Customer Ledger entries page and then sort by Cust. Ledger Entry No. There you can find Entry type Invoice and if there is a payment you can find that in the next consecutive line. This was you can find invoice along with their payment
     
    Alternatively what you can do is you can use this report  Customer Payment Receipt. This will show all payment entries with their corresponding Invoice.
     
     
    Hope this helps you in the interim
     
    Regards
    Vikas Jain 
  • Amanda Mayer Profile Picture
    Amanda Mayer 207 on at
    If you send the Detailed Customer Ledger Entries to Excel (or use Analyze within the table), you can create a pivot table that matches payments and invoices. I did this in a demo environment which does not have real complex applications, but it is a start. 
     
             
    Row Labels Cust. Ledger Entry No. Document Type Document No. Sum of Amount
    10000 3517 Invoice PS-INV103215 28,463.80
    10000 3517 Payment 1325 (22,813.80)
    10000 3517 Payment G04003 (5,650.00)
    10000 3517 Total     0.00
    Grand Total       0.00
             

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,036 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,179 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 828

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans