Small and medium business | Business Central, N...

Customer payments

(0) Share

Report

Posted on by Community member

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

All responses (4)

Answers (0)

Amanda Mayer

205 on at

Like (0)

Report

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 10 on at

Like (0)

Report

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 2 on at

Like (0)

Report

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 74,115 Super User 2024 Season 2 on at

Like (0)

Report

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