Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
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 Community member 2
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:
Business Central
  • Amanda Mayer Profile Picture
    Amanda Mayer 205 on at
    Customer payments
    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
             
  • Community member Profile Picture
    Community member 10 on at
    Customer payments
    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 
  • Community member Profile Picture
    Community member 2 on at
    Customer payments
    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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,339 Super User 2024 Season 2 on at
    Customer payments
    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

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans