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
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get the "T...
Small and medium business | Business Central, N...
Suggested Answer

How to get the "Total Amount Including VAT" from sales statics of an order ?

(0) ShareShare
ReportReport
Posted on by KaryaNavTech 239

HI Experts,

Good Day ! Could you guys please help me out in this:

Where could I find the  Amount Including VAT value shown on Sales Statistics (F9). I have checked all backed tables and forms but the field is an array which does not hold any value in table level. It just calculate based on sales line value and update the Amount Including VAT. 

Could you please suggest how could i get the calculated value shown in sales statistics form. Thanks in advance.Sales-Statistic.png

I have the same question (0)
  • KaryaNavTech Profile Picture
    KaryaNavTech 239 on at

    anyone please suggest ?

  • Community Member Profile Picture
    Community Member on at

    Check this one : www.easyunitconverter.com/vat-calculator

  • ManishS Profile Picture
    ManishS 86 on at

    Did you check Amount to Customer field on the sales document.

  • Antony Kidless Profile Picture
    Antony Kidless 5 on at
    [quote user="NavTechie"]

    anyone please suggest ?

    [/quote]

    Try this VAT calculator

  • Srdjan Grandic Profile Picture
    Srdjan Grandic 95 on at

    There are multiple ways of retrieving that information. The simplest is summing up the values of the field 30 "Amount Including VAT" from the Sales Line table, for all of the records related to that particular sales document. There's also a flow field 61 "Amount Including VAT" on the Sales Header table, that does exactly the same thing.

    But, please bear in mind that this will give you the total amount for the entire document, not just for the lines that are yet to be invoiced or shipped.

  • Suggested answer
    John12 Profile Picture
    John12 2 on at
       
     Here's a simplified formula:
         Suppose you have an order with the following details:
    • Net Total 1000$   
    • VAT Rate 10%
       Calculate VAT for each line item:
       VAT amount = $1000 * 0.10 = $100
        

      Sum up VAT amounts:
      Total VAT Amount = $100

    1.   Add VAT to Net Total:
        Total Amount Including VAT = $1000 + $100 = $1100


      Source : https://onlinevatcalculate.com/

    1.  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,185 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,151 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,068 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans