web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
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... / Custom Report Layouts
Small and medium business | Business Central, N...
Suggested Answer

Custom Report Layouts

(0) ShareShare
ReportReport
Posted on by INITMAN007 440
Hello,
 
I need to add a column that shows the VAT amount of the line, I have highlighted it in green in the screenshot. I have tried to add line >VAT Amount line>VATAmount_VatAmountLine using the Plain text optoin, but nothing gets populated. Please can someone advise on what field to add how I would do this. 
Thanks
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    Grigorios Mavrogeorgis 2,757 Super User 2026 Season 1 on at
    Hi, that field won't work there because VATAmount_VatAmountLine sits on the VATAmountLine dataitem, that's the temp table grouped by VAT %, one row per VAT group at the bottom, not one row per invoice line. Word can't merge a field from a different repeating group into your Lines table, so it stays blank.

    There isn't a native per-line VAT Amount field in that dataset, on purpose I think, BC calculates VAT off the subtotal per VAT group to avoid the line-by-line total not matching the document total after rounding. If you want it per line anyway you'd need to extend the report in AL, add a column on the Lines dataitem doing the calc yourself, something like Amount times "VAT %" divided by 100, watch the rounding, then it shows up in the Word field picker after you publish.
     
    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
     

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

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 695 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 422 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans