Microsoft Dynamics NAV (Archived)

Prices Including VAT

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Tax is calcualted on the Unit Price , why are you expecing 869.57 as Total Excl. VAT. The VAT is calculated on top of the unit price.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Did you setup Prices Including VAT on the Item Card ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes I did.

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Miuru,

got the point

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

Was this reply helpful? Yes No
Verified answer

Maneesha 5,891 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Suresh,

Did that too

Was this reply helpful? Yes No