Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 225

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

  • Suggested answer
    John12 Profile Picture
    John12 2 on at
    How to get the "Total Amount Including VAT" from sales statics of an order ?
       
     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.  

  • Srdjan Grandic Profile Picture
    Srdjan Grandic 95 on at
    RE: How to get the "Total Amount Including VAT" from sales statics of an order ?

    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.

  • Antony Kidless Profile Picture
    Antony Kidless 5 on at
    RE: How to get the "Total Amount Including VAT" from sales statics of an order ?
    [quote user="NavTechie"]

    anyone please suggest ?

    [/quote]

    Try this VAT calculator

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: How to get the "Total Amount Including VAT" from sales statics of an order ?

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get the "Total Amount Including VAT" from sales statics of an order ?

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

  • KaryaNavTech Profile Picture
    KaryaNavTech 225 on at
    RE: How to get the "Total Amount Including VAT" from sales statics of an order ?

    anyone please suggest ?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans