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

All responses (3)

Answers (0)

Suggested answer

DAnny3211 9,274 Moderator on at

Like (0)

Report

RE: VAT amount per line on sales invoice

hi

see the standard report as an example

report 406 "Purchase - Invoice".

DAniele
TomRoskam 40 on at

Like (0)

Report
RE: VAT amount per line on sales invoice

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.
Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: VAT amount per line on sales invoice

Share the layout and Source code.

Regards

Amit Sharma

www.erpconsultors.com