Prices include VAT just stopped working

imurphy

Got a problem with something that was working just fine.

In a Sales order with :

- the 'Prices include VAT' checkbox marked
- for clients with 'Prices including VAT' marked

when I add an item with a sales price of 100, it is adding VAT.

I assume we've modified some parameter or tax related table, but I'm not sure where.

Apart from these two options - anyone know whatelse influences the aplication of tax on an item sale?

Ian

kapamarou

If you zoom into the lines are the VAT fields filled??? (VAT Identifier, Amount etc...)

imurphy

Looking at the lines of a test I've just done I find the following in each line of the sales lines table:

Vat Calculation Type = Normal VAT
Vat Prod. Posting Group = IVA16 (this is a 16% vat rate)
Vat Identifier = IVA16
VAT % = 16

Unit Price Excl. Vat contains the prices with vat
Line Amount excl Vat algo includes the VAT

The rest contain 0's

Ian

kapamarou

I think that if you run the form the labels of the fields switch between Incl. VAT and Excl. VAT.. Look at the forms and if the data are in accordance with your labels then you are ok. The field captions change only on the forms, not the tables

imurphy

What *should* be happening is if I have an article with 'Unit Price' = 100 and the two prices include VAT checkboxes are marked then when I make a sale of this article the following fields should be filled out assume a vat rate of 16%:

Unit Price Incl Vat Should contain 100
Unit price Excl Vat should contain 86.20
The vat amount should contain 13.79

Ian

imurphy

I'll take a look at the labels

kapamarou

Also try to press the Functions -> Release mebu button from the order. I think in standard Nav the fields are calculated with release, which is also called when posting...

imurphy

I eventually found a solution to this problem. We had to

- modify the item form to expose the prices include vat field
- modify the item form to expose the Vat Bus. Posting Gr. (Price) field
- Set each of these fields for all articles
- Set Prices include vat on the header of the sales doc.

I found information on this in the MS training doc 'Introduction to Finance in microsoft dynamics NAV 5.0' - Chapter 8: VAT and Intrastat

Ian