Dynamics NAV - Change VAT %

• When changing VAT, the problem of re-calculating Unit Price, and Unit Price Including VAT occurs
• The Unit Price or Unit Price including VAT will not change unless the price is actually changed manually, or in a package
• To resolve this issue
• Stop Nav Scheduler to prevent changes from going to terminals
• Export Current Items and Sales Prices
• Export all Item no,, VAT Prod Posting Group, Unit Prices, Unit Price including VAT to excel package template
• Split this into 2 templates, 
• one for items with new prices - IC
• one for items where prices are not changing - INC
• Export all Sales Prices with no ending date to excel package template
• Split this into 2 templates, 
• one for items with new prices - PC
• one for items where prices are not changing - PNC
• Change VAT % (see methods below)
• Import Item updates
• For the INC List, set all item card prices including vat to 0
• Import and apply this package
• Then set all prices to the new selling price including VAT
• Import and apply this package
• This is to get NAV to reverse calculate the correct Unit Price without VAT
• For the IC list, just import and apply
• End all current Sales Prices
• This is done as a precaution to ensure no old prices are missed
• Run a SQL update to put an ending date on all sales prices with no ending date
• update [mytable] set [Ending Date] = '2016-01-31' where [Ending Date] < 0
• Import all new Sales Prices
• For the PC List
• Change the Starting Dates
• Update PC template with new sales prices
• Import and apply
• For the PNC list
• Change the starting dates
• Import and apply
• Re-Export all Items and Sales prices and compare to import lists to confirm changes went in correctly
• In some instances, the unit prices on the item cards are incorrectly updated after importing the sales prices
• Configure any custom jobs to push changes to terminals
• Start NAV scheduler to push all changes to terminals

------------------------------------------------------------------------------------------------------

VAT CHANGE METHODS

• Method1 - Change the existing rate and only affect new transactions moving forward
• http://www.tvisiontech.co.uk/news_5.html
• Search for VAT Posting Setup
• Change current VAT %
• Create new VAT Codes for the old rate to handle old transactions being entered before the vat change date. (eg. VATOLD)
• Manually select the new vat code (VATOLD) if you need to handle transactions for the old vat %
• Check and adjust item prices, including VAT and sales prices.
• Use the batch job Adjust Item Costs/Prices.
• Push all changes to terminals
• Table VAT Posting Setup 325 to all terminals
• Table VAT Code 99001560 to all terminals
• Item
• Sales Prices
• Method 2 - Create a new Rate and only affect new transactions going forward
• All existing transactions containing VAT should be posted
• New VAT Posting Group should be created with new VAT% (keep the old existing ones)
• New VAT Posting Setups should be created with new VAT% (keep the old existing ones)
• New VAT Code should be created with new VAT % (keep the old existing ones)
• Update all VAT Product Posting Groups on Customers, Vendors, Items, GL
• Push all changes to terminals
• Table VAT Posting Setup 325 to all terminals
• Table VAT Code 99001560 to all terminals
• Customers
• Vendors
• Items
• GL Accounts
• Only new transactions going forward will have the new VAT %

• Method 3 - Change all unposted transactions, and all new transactions going forward
• Create new VAT Codes
• Create new VAT Posting Groups
• Search for VAT Rate Change
• Setup VAT Prod Posting Group conversion to define the old VAT code and the new VAT code to replace it with

• Setup the VAT Rate Change Setup

Test the VAT conversion

• Clear the VAT Rate change Tool Completed Checkbox
• Clear the Perform Conversion Checkbox
• Once this is cleared, running the convert function will only simulate a conversion
• The actual conversion will not happen
• Review the VAT Change Log Entry

Print all VAT reports before conversion

Perform the VAT Conversion

• Clear the VAT Rate change Tool Completed Checkbox
• Mark the Perform Conversion Checkbox
• Review the VAT Change Log entry
• Review sample data

Print all VAT reports after conversion

Push all changes to terminals

• Push the values for Table VAT Posting Setup 325 to all terminals
• Push the values for Table VAT Code 99001560 to all terminals

These changes will affect current unposted transactions, and new transactions going forward

Historical transactions will remain with the VAT% they had when they were posted