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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
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,248 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,812 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,812 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

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

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 580 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 462 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 272 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans