Manual VAT Adjustments

birgem

Hi everyone,

We have a situation where we need to override the calculated VAT amount in NAV for certain orders. We've specified a Max. VAT Difference Allowed and checked the Allow VAT Difference flag.

These settings work great until we go to ship the order, in which the VAT Amount gets reset to the NAV calculated value. For example, we have an order of $349.99 with a 7% VAT calculation of $24.50. We can change the VAT Amount on the Order Statics card to say $20.00 and it takes it just fine. However, when the order is shipped the VAT Amount will be reset to $24.50.

Any ideas of what would cause this issue? We are using the World Wide localization version of NAV 2009 SP1, but we do have some US objects installed.

I appreciate any help that anyone can offer.

birgem

Sorry, but wanted to give this question one more try before it got pushed down and forgotten. Thanks again.

jannestig

It sounds like a customization error where you are validating the order again due to US sales tax and VAT being used in the same database.

There is no hotfix for 2009 sp1 suiting this.

Perhaps you could provide for information. EG does this only happen when you do partial shipments or where qty on a line is greater then 1 etc.

rhpnt

If you are able to modify the VAT amount in the statistics form of the order then it's sure some kind of "modification". The only two fields that are enabled by design in that form (by what I know) are "Inv. discount amount" and "Total excl. VAT".

I would guess that the reason why the VAT in the sales order gets "reset" is that before shipping/invoicing the order has to be released and this step calculates VAT in the lines and consequently "resets" the VAT in the statistics form.

birgem

Thanks everyone for your response. Apparently what's happening is that whenever the item quantity is changed, it recalculates the VAT. So this happens for an order regardless of whether it's a partial or complete shipment. If you re-enter the desired VAT Amount (say $20.00) prior to invoicing and then post the order, the following error occurs.


If you leave the VAT Amount to the NAV calculated amount ($24.50), the order will post just fine.

jannestig

Thats your US objects screwing things up/

If its only using VAT there shouldn't be in Sales Tax implications unless you are trying to replicate Canadian functionality ????

ssingla

birgem wrote:

Thanks everyone for your response. Apparently what's happening is that whenever the item quantity is changed, it recalculates the VAT. So this happens for an order regardless of whether it's a partial or complete shipment. If you re-enter the desired VAT Amount (say $20.00) prior to invoicing and then post the order, the following error occurs.


If you leave the VAT Amount to the NAV calculated amount ($24.50), the order will post just fine.

Is this a standard error message :-k

I really doubt that. Standard Message is like Document Type Order, Document No. ABC/01 and not Order Doucment Type and ABC/01 Doucment No..