Prices include VAT just stopped working

imurphy
imurphy Member Posts: 308
edited 2008-09-25 in NAV/Navision Classic Client
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

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    If you zoom into the lines are the VAT fields filled??? (VAT Identifier, Amount etc...)
  • imurphy
    imurphy Member Posts: 308
    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
    kapamarou Member Posts: 1,152
    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
    imurphy Member Posts: 308
    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
    imurphy Member Posts: 308
    I'll take a look at the labels
  • kapamarou
    kapamarou Member Posts: 1,152
    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
    imurphy Member Posts: 308
    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

Categories