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
Hi Nitin,
Thanks a lot!
I could get values for all tax components. You made my day...
Hi,
Search this codeunit (18006 "GST Statistics") in India GST app, and you will find your answers in it.
Thanks.
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
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (