Wednesday, December 2, 2015

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

    No comments:

    Post a Comment