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

Vendor account detail report cannot print applications with invoice dollar amounts

(3) Share

Report

Posted on by CU13010319-0

579

I want a report that can include the applications for payments, and include each invoice number, dollar amount, and description to supply to vendors, when they ask about which payments were applied to what invoices. Some payments can include as many as 20 invoice applications.

On the vendor list, the vendor account detail report is available I see that can include the vendor invoice no via the external document no, and has another toggle for including application details. However, when I toggle on both the external document no and applications, generated report, whether in pdf or excel, does not include the dollar amount for each invoice, only the document no being replaced by the external document no. Is there a way to use this report, or another report available, that could show those key details, the external document no of the invoice, and dollar amount of each invoice for a payment? Can that be added in or only available via customization to do so?

Invoice dollar amounts not shown vendor account detail.png

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

YUN ZHU 102,665 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

This likely requires customization; hopefully, the information below gives you some hints.
Dynamics 365 Business Central Blog Series: Report Extension Examples & Use Cases
https://yzhums.com/70354/
Additionally, this data can also be found in the Detailed Vendor Ledger Entries, but compiling it is somewhat of a hassle.
Thanks
ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 18,565 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,
this is standard behaviour: Vendor – Detail Trial Balance/Vendor Account Detail is intended for reconciliation and its application section does not print the amount applied to each closed invoice; enabling External Document No. only changes the displayed document reference. For vendor communication, use Send Remittance Advice from the Payment Journal before posting, or from Vendor Ledger Entries → Actions → Functions → Send Remittance Advice after posting; this is supported in the US localisation. If that standard layout does not include all required details—vendor invoice number, description, and the exact applied amount, particularly for partial applications—then a report extension/custom report is required using Vendor Ledger Entry and Detailed Vendor Ledger Entry, showing the application amount rather than the invoice’s Remaining Amount. Business Central stores the exact amount applied per entry during the application process.
Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 10,275 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello @CU13010319-0 ,

This is a standard limitation of Business Central. The Vendor Account Detail report can display application details and the external document number, but it does not include the applied invoice amounts for each application. If you need a report that shows the invoice number (external document number), invoice amount, description, and the payments applied to each invoice, this would require a report customization or a report extension, as it is not available in the standard functionality.

Hope this answer helps you as well!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 2,931 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Vendor – Payment Receipt (411) is the one you want, not the account detail report. It's made for this — each payment with the invoices applied to it, document no, description and the applied amount per line.
External invoice number is where it stops. The payment's External Document No. is in the dataset, but not the one from each applied invoice, so that field needs adding through a report extension and then into the layout. Small job for a developer, no way around it from setup.
I'd test it with a foreign currency vendor first. There is an old issue on 411 where the not allocated amount comes out wrong when the invoice and the payment are in different currencies, I don't know if it's fully fixed in every version.
Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,594 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.
Detailed Vendor Ledger Entries - Business Central | Microsoft Learn
How to Print Vendor Payments List Reports [AT] - Business Central | Microsoft Learn
Print Vendor Payments List Reports [CH] - Business Central | Microsoft Learn
Introducing Payment times analysis in Business Central (2023 release wave 2)
Best Regards
Gerardo

Was this reply helpful? Yes No