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

VAT amount per line on sales invoice

(0) Share

Report

Posted on by TomRoskam

Hi,

I would like to put VAT amount line on a sales invoice report. I created a custom report layout and added all the fields I want show on the sales invoice.

Somehow, the VatAmount_VatAmountLine works only for the first row of the booked sales invoice. This is with an iterative Line in the sales invoice.

Whenever I create a custom report layout with only the VatAmount_VatAmountLine, with an iterative VATAmountLine, it works perfectly fine.

But I need to combine those two into one table. Can somebody please explain how this works? It is hard to believe this is impossible.

Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Amit 2,563 on at

Like (0)

Report
Copy link

Link copied!

Share the layout and Source code.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
TomRoskam 40 on at

Like (0)

Report
Copy link

Link copied!
This is the layout of my invoice.

And here is the XML of my layout.

Factuur Your Company Name CompanyAddress2 City CompanyAddress4 CompanyAddress5 FACTUUR ADRES : CustomerAddress1 CustomerAddress2 CustomerAddress3 CustomerAddress4 CustomerAddress5 Factuur # DocumentNo Datum DocumentDate Uiterlijke betaal datum DueDate CATEGORIE OMSCHRIJVING PRIJS BTW % BTW BEDRAG SUBTOTAAL ItemNo_Line Description_Line AmountExcludingVAT _ Line VATPct_Line AmountIncludingVAT_Line TOTAAL € TotalAmountIncludingVA T

Hope you can help me. Thanks anyway.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,417 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi

see the standard report as an example

report 406 "Purchase - Invoice".

DAniele

Was this reply helpful? Yes No