Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to get the amount of the total price of a sales order.

Posted on by 422

So I have a sales order and i'm trying to get the price that's inside of the order's "sales line". Now any field i seem to return it keeps giving me a value of 0,00. Any way i am able to retrieve the "Total Incl. VAT" price?

EDIT:

I found out the total price including VAT isn't a field but a Source Expression but that leaves me even more clueless on how to get the value.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get the amount of the total price of a sales order.

    CalcVATAmountLines is used to calculate the VAT amount per VAT Group. You may need this in reporting VAT breakdown on a sales document, but not here. Way too complicated as it returns you A bunch of lines.

  • InsertX Profile Picture
    InsertX 422 on at
    RE: How to get the amount of the total price of a sales order.

    I'll give this shot. Also i was wondering (it's to achieve the same but anyway) in "Sales Line" there is a function called "CalcVATAmountLines". Since someone told me i should take a look at this i was wondering as well in what way i would be able to use that function to get me there?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get the amount of the total price of a sales order.

    You need to call calcfields function if the field is a flowfield. For example SalesHeader.Calcfields("Amount Including VAT");

    Tero

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans