You’re offline. This is a read only version of the page.
265
Does anyone know of a Cash Application type report on the Receivables side? I am looking for a report that Shows a particular payment and all the invoices that were paid by it.
Thanks
1. What functionality do you use to register customer payments? If you use Bank Deposits the Posted Bank Deposit has a report that displays all invoices applied to that specific payment.
2. otherwise there is no specific report for that, but if you open the Customer Ledger Entries page and filter for document type=Payment you can see the list of payments. If you select a specific payment you can then click on View Applied Entries to see the list of invoices paid by it
3. if you use jet reports you can create a jet report to do it for you, here is an example community.dynamics.com/.../cash-receipt-applied-report
4. there also the Customer Account Detail report but this will display the list of all documents for a customer and will not display what specific invoices are paid by a payment
Hi,
Go to the lookup and type "Detailed Customer Ledger Entries" you may have to pull in some new columns, but this area (list) gives you the original Invoice and all of what was applied to it.
You can grab this page using Power BI for easier reporting.
I could not find any report here. If you have Jet Report then you may need to use that. If you do not then maybe try ODATA
Publish Page 61 Applied Customer Entry and Page 21 Customer Ledger Entry list as ODATA (web Service)
The consume them both in Excel see this article community.dynamics.com/.../getting-d365-business-central-data-to-excel-using-odata-feeds
Then create query in Excel that user can enter payment no or etc as filter. Then use that no to find Customer Ledger Entry for that filter in Customer Ledger Entry. Then filter Applied Customer Entry "Closed by Entry No: " field for that ledger entry and show all invoices.
This is like going to Customer Ledger Entry and select the Payment then Entry -> Applied Entry
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (