Within Business Central VAT rate changes can only be handled with conversion of posting groups according to the VAT rate change setup table (T550). From customer’s perspective this is a very laborious procedure and needs support from the implementation partner.

This year, Germany even decided for an intermediate VAT rate change from 01.07. to 31.12.20, so the same cumbersome procedure emerged twice.

There was a made to measure request from serveral customers to get a more suitable VAT rate change process what we could pursue.

Here’s the idea:

We’ve created a new table ‘VAT rate date validation’ and implemented it to the VAT Posting Setup Table. Fields:
VAT Bus. Posting Group
VAT Prod. Posting Group
VAT %
Purchase VAT Account
Sales VAT Account
VAT Identifier
Starting Date
Ending Date

In addition we’ve enhanced the VAT Posting Setup Table 325 for the VAT date reference:

Date Reference, options: Posting Date or Date of Delivery**
(**date document for journal processes and shipment date for document related processes)

Of course there had to be considered several objects to enhance the VAT rate date validation for the different VAT related business processes. All in all the needed effort was calculable and was worth it to the customer.

Those customers can now handle the VAT rate changes easily themselves without conversion of posting group to the different master data types and transaction data.