Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Prices Including VAT
Microsoft Dynamics NAV (Archived)

Prices Including VAT

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi, 

The item A Price = 1000 

and VAT% is = 15%

Quantity = 1

I create a sales order and for the customer Prices including VAT is enable. 

when inserting the item A (which sales price is 1000) The unit Price Comes to the column Unit Price Including VAT is 1000. 

Next I Chose Bus. VAT & Prod. VAT to where its combination calculates the VAT for the invoice. 

The Total Excl. VAT Column Gives me a value = 1000 

TOTAL VAT  = 150

Total Incl. VAT = 1150

This is not the answer i was expecting. i was expecting to get,

The Total Excl. VAT  = 869.57

TOTAL VAT  = 130.43

Total Incl. VAT = 1000

The expected answer will provide by the NAV Sales Order/Invoice if i enter the unit Price Manually at the Sales order or invoice. 

Has anyone come across this issue ? have i done something wrong ? 

The Version i am using is NAV 2016 CU 4 Aslo NAV 2017 CU 1  W1 Edition. 

*This post is locked for comments

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Prices Including VAT

    Hi

    Check this table from MSDN for better understanding of VAT calculation

    Price Includes VAT field on Item CardPrices Including VAT field in Sales HeaderAction Performed

    No check mark

    No check mark

    The Unit Price on the Item Card is copied to Unit Price Excl. VAT field on the sales lines.

    No check mark

    Check mark

    The program calculates the VAT amount per unit and adds to the Unit Price on the Item Card. This total Unit Price is then entered in the Unit Price Incl. VAT field on the sales lines.

    Check mark

    No check mark

    The program calculates the VAT amount included in the Unit Price on the Item Card using the VAT% related to the VAT Bus. Posting Gr. (Price) and the VAT Prod. Posting Group combination. The Unit Price on the Item Card, reduced by the VAT amount, is then entered in the Unit Price Excl. VAT field in the sales lines.

    Check mark

    Check mark

    The Unit Price on the Item Card is copied to Unit Price Incl. VAT field on the sales lines.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Prices Including VAT

    Hi Suresh,

    Did that too

  • Verified answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Prices Including VAT

    Miuru, there is a another thing

    on your vat posting setup if you setup this system automatically make the sales order document with vat (its shows the vat amount separately)

    i think , you can enable vat liable (its on the table) and need to do some modification to your report to hide vat amount and show only the total value

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Prices Including VAT

    Miuru,

    got the point

    go to  "vat posting setup"  and make this and try 

    Un1titled.png

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Prices Including VAT

    If you have sales price setup for that item then you need to setup that also on the sales price table.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Prices Including VAT

    Yes I did.

    Customer Card and Item Card, at both the places i have selected as Prices Including VAT. Still its the same answer.  

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Prices Including VAT

    Did you setup Prices Including VAT on the Item Card ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Prices Including VAT

    Hi Suresh,

    Yes you are correct. But there is this option to identify that the unit price is included with the VAT portion.  I have explained the scenario thoroughly as a reply to Maneesh bellow.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Prices Including VAT

    Hi,  Maneesha,

    My Client's Unit Price for the Product A is 1000.00 LKR

    But This price includes the VAT, which is hidden.  Actually Customer Does not Provide a TAX Invoice.

    But there are customers who are asking for the Tax Brake Down.  

    When That Happens The System should provide the Reverse Calculation of VAT.  Which means its Original Unit Price is 869.57 for the Said Item.

    This is major in the Trading business because specially in SL , The businesses have to pay the VAT Receivable Portion.  Therefore they Charge the Customer without saying its VAT included.

    If you Tested, Even the NAV Does gives you the reverse Calculation if you Select the Prices Included VAT Boolean Value. But the Problem is if the price automatically comes from the Either item card or Sales Price List.  If the price is picking from any it does not do the reverse calculation. It will do the Forward calculation.

    In this case the client has charge VAT for the price twice. This is wrong.

    You type the Unit Price at the Unit price included VAT column.  Then it will do the Backwards Calculation for the VAT.

    So in that case NAV Logic is correct, but if it is picking from either from the Item table or Sales Prices Table it doesnt perform as according to the expected.

    I hope i have sound clear enough.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Prices Including VAT

    Hi Miuru Mahagamage ,

    If you getting Total Incl. VAT = 1150 means your vat setup is exactly correct right.

    so thew problem is your logic , what is the expectation of this...

    The Total Excl. VAT  = 869.57

    TOTAL VAT  = 130.43

    Total Incl. VAT = 1000

    if you comment the purpose of this or what is your real requirement , we can do something

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans