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

Announcements

No record found.

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... / Fetch Net Total Value ...
Small and medium business | Business Central, N...
Answered

Fetch Net Total Value From Statistics

(0) ShareShare
ReportReport
Posted on by SelfStarter 70

Dear Experts,

I need to find total order value of a sales order in Business Central. Earlier I used to get it from the summation of the "Amount to Customer" field in sales lines in NAV 2016 which would contain total liability of the customer for a line, but in BC I couldn't find such field.

Can you please suggest me on how to get Net total of a sales order? I can see the value in Statistics page, but cannot retrieve it in my extension.

Thanks

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,204 Super User 2026 Season 1 on at

    You can use Amount or Amount Including VAT fields from Sales Header table which is sum of Amount or Amount Including VAT fields of Sales Lines

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hello Mohana,

    Thanks a lot for replying!

    I looked for the fields Amount and Amount Including VAT, but the values for Indian Statutory Components like GST, TCS under Indian Taxation etc. do not reflect in these fields. I would be grateful if you can help me with this.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,794 Moderator on at

    Hi,

    Those GST fields are not available as the other standard fields, you have to use India Tax Base, GST, and Tax engine as dependencies in your project and then your can use those fields.

    Thanks

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Dear Nitin,

    Thanks a lot for replying. Actually I have included the India GST, India TDS, India TCS and Tax Engine as dependencies in the project. The GST related tables like GST Ledger Entry and Detailed GST Ledger Entries are also coming, but in unposted transaction table like Sales header and sales line I cannot see them.

    Am I missing something which is obvious.

    Thanks

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,794 Moderator on at

    Hi,

    Search this codeunit (18006 "GST Statistics") in India GST app, and you will find your answers in it.

    Thanks.

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hi Nitin,

    Thanks a lot!

    I could get values for all tax components. You made my day...

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

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 February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,804 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,103 Super User 2026 Season 1

#3
Kamal Khakhkhar Profile Picture

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans