Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

What is changing?

HMRC is bringing in a new revenue calculation model on 1st August 2023.

Further information is can be obtained here Alcohol Duty: rate changes - GOV.UK (www.gov.uk)

...

In order for the WMS to accomodate accommodate these changes, a number of changes will steps have to be been made , these which are released included in WMS v6.8 which and is available from April 2023.

...

Date

Vision Warehousing v6.8

Released

All customers must be running WMS v6.8 on WMS.

1st July 2023

Customers wishing pre-update change checks OR those wishing their test system to have the final update run.

ASAP after v6.8 released

Live HMRC Change - Customers without pre-change checks

31/08/2023 from 11am

You would then not be able to despatch until the following dayand installed

AND Before 1st July 2023

Live HMRC Change - Customer with pre-change checks

31/0807/2023 from 2pm

Customers will be allocated a slot from 2pm to 8pmonwards

You would then not be able to despatch until the following day

Further information will be released on this page when it becomes available.

...

Customer Requirements

Customer Customer’s need to :

  1. Have WMS v6.8 installed into your live system prior to 1st July 2023

  2. Ensure that an ABV is provided for all stocks and recorded on the stock record, for any items which need to have an ABV

  3. Customers need to audit their excise tax, commodity and product setup to ensure that they have the correct items in the correct product type, commodity code and excise tax code.

...

We would strongly advise that customers have the strength and size checking switched on against the commodity code / tax code, this ensures ABV is recorded on the product record and receipt. Despite this being in the system for in excess of 10 years, some customers do not have this switched on.

...

Note

If you have gone through the implementation and find that the above is the case then your only course of action is to remove, re-rotate and reland re-land the product to stock again.

Warehousing v6.8 Changes

...

Strengths can already be submitted to the warehouse in the EDI Pre-Advice message PA XML Structure.

...

This field was previously used for HMRC submissions indicating the brand for ARC and Export movements. However, however from v6.8 this will become more substantially important with the changes necessary for small producer relief. Therefore, therefore one of the main changes coming in v6.8 will be making it easier for users to find and select brands to avoid duplications, and also an easy way of maintaining and merging existing brands.

...

Warehouses need to plan to use this new version to tidy up data in preparation for go live & and the setup of the new small producer relief tax certificates.

We have provided a Brand merge/ update facility withint within v6.8, which will allow you to correct spelling mistakes and duplicates of the brand field.

...

Planned Update and Options

The sections below detail what the plans are for the upgrade on the 31st July 2023 along with an optional pre-update plan that customers can opt intoin to.

Is there a cost?

Yes, there is a cost and it is based on your volume of products and stocks. Please speak to customer services to discuss.

You can perform this update yourself, you would be changing the existing codes and data to new codes and data and then manually checking all the products are on the correct new codes, alternatively you can setup the new structure and re-land all the stock on your system.

Optional Pre-Update Plan

The idea of the pre-update is to help customers be ready for the changes on 1st August , and to be able to resolve any issues prior to that time with stock data which is far easier than trying to do it afterwards.

If you opt for this plan there will be a charge and it is based on your volume of product / stock date so we have three levels for different sizes of customers in addition you will be allocated a slot for upgrade after 2pm on 31st July 2023 otherwise you will be one of the first upgrades from 11am

What this plan will provide you isThe plan includes:

  1. Turning on all strength checking. This involves adding and correcting the commodity codes and excise tax codes for the correct strengths and then turning them on.

  2. Providing you with a report of all products and all stocks which do not match the commodity/tax strengths or sizes.

  3. Providing you with a list of any old commodity codes where you are still using them for products and stocks.

  4. Archiving products which have no stock and are invalid.

  5. Providing you with a later start time on the final day

  6. Allow you the choice to upgrade your test system with the full implementation prior to the live date
Tip

You must book the pre-update plan in with customer services, this will not be carried out unless it is specifically requested.

HMRC Update - Data Change plans

...

Info

This would have to work off the Strength ABV fields in the applications, as such we urge customers to start using this field correctly if not doing so already and to ensure that the field is set correctly for all historical records. Where this is not done, for any records without this set we may have to assume the highest permitted strength for their tax or commodity code in order to switch it over to the new rate.

On-the-day

...

This script will be run for warehouses at a cut off given by Ontech on 31/07/2023

...

Updates

All warehouses have now been allocated and informed of the cut-off time for which all users must logged off Vision Warehousing and Bond to allow us to run scripts. You will be informed after approximately 90 minutes that you're able to log back in to your Vision applications but NO movements are to be processed including creating despatch movements, pick/confirm pick orders or process goods in or out movements until the following day.

Warning

Please note: HMRC CDS downtime scheduled from Monday 31 July 2023 11:55pm to 1:05am Tuesday 1 August 2023

Info

Where customers upgrade their test system, the below can be run within the test system prior to the go live day

...

. This is available to customers with the pre-update plan only

What is changed or updated?

  1. New tax codes will be created with the correct rates & relief setup, commodity codes (along with quotas & import document setup) will be created from existing data and linked to the new codes

  2. 4xx tax codes & linked commodities will be archived

  3. Product fixes

    1. Cider products will be corrected to ‘Intermediate' product type

    2. Products with invalid strengths (0 or >100) will be updated from stocks with a valid strength or will be set to the highest for the commodity code.

    3. Products with a duty paid tax code setup will be corrected from the stocks with a correct tax code, this relates to old products setup before the product type and excise tax code were linked.

    4. Low alcohol products will be linked to the new ‘Low Alcohol’ product type

    5. Sparkling ciders with a strength between 5.51 and 8.49 will be linked to the new ‘Other Fermented Products’ product type

    6. Made wines (42* 42x tax codes) will be converted across to the ‘Other Fermented Products’ tax code also

  4. Products remaining which aren’t valid for conversion due to incorrect strengths and have no stock will be archived

  5. Remaining products with a 4* 4xx tax code will be converted to map to the correct new tax code

  6. Stocks will be updated to link to the new tax codes

  7. Pending pre advices will have the tax & commodity updated from the updated product record