Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to show Line VAT A...
Small and medium business | Business Central, N...
Suggested answer

How to show Line VAT Amount Field on Sales invoice(1306)

(1) ShareShare
ReportReport
Posted on by Nihad92 42
Hi all
 
I'm struggling to find the correct field to show VAT amount by line on sales invoices report (1306)
 
Any work around this please?
 
Thanks
N
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 83,230 Super User 2025 Season 1 on at
    How to show Line VAT Amount Field on Sales invoice(1306)
    Hi, hope the following helps as well.
    Dynamics 365 Business Central 2021 release wave 1 (BC18): Report extensibility (ReportExtension Object)
    https://yzhums.com/10723/
    Dynamics 365 Business Central: Save report dataset to Excel from the request page (Report Inspector)
     
    Thanks.
    ZHU
     
  • Nihad92 Profile Picture
    Nihad92 42 on at
    How to show Line VAT Amount Field on Sales invoice(1306)
    Hi 
     
    That is very helpful to know
     
    I added VATAmount_VatAmountLine field to the invoice temple but it didn't show any figures, I have noticed that the field is available, however it's on the 3rd row on the excel export and the rest of the data is on 2nd row.
     
     
  • Suggested answer
    _Hampus_ Profile Picture
    _Hampus_ 18 on at
    How to show Line VAT Amount Field on Sales invoice(1306)
    Hi!
    I don't think there is any field for that in report 1306. If you want to investigate further which fields that's included in the dataset, you can print the report to Excel and see if you can find the field you are looking for.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 965

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 1

#3
Mansi Soni Profile Picture

Mansi Soni 602

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans