Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

How to pull "VAT Amount Line" in Sales Invoice Statics

(0) ShareShare
ReportReport
Posted on by 140

Hi Expects,

We have a requirement to pull "VAT Amount Line" records in Sales Invoice Static page. But this fields are all comes from temp table "VAT Amount Line", so these field are all calculated. Can someone shed me the logic of calculating these fields in Sales Invoice Statics page? Especially for field "Modify","Positive" and "Inv. Disc. Base Amount". Below is a screenshot for you reference.

Thanks
pastedimage1666259699867v1.png
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,021 Moderator on at
    RE: How to pull "VAT Amount Line" in Sales Invoice Statics

    The VAT amount is available directly on the sales invoice lines. So when you build reports i will recommend you sum it from the sales invoice lines corresponding to the invoice you are reporting on.  

  • Suggested answer
    Andy Sather Profile Picture
    on at
    RE: How to pull "VAT Amount Line" in Sales Invoice Statics

    Hello,

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,206 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,968 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans