How to change VAT Product posting group and GEN Prod posting group In Navision for all Master tables like Item, sales Orders, Purchase orders, Service orders and General journal lines with one click with out creating any external reports.

How to change VAT Product posting group and GEN Prod posting group In Navision for all Master tables like Item, sales Orders, Purchase orders, Service orders and General journal lines with one click with out creating any external reports.

Step 1: -

     Open the VAT rate change setup tool By using below link

CRONUS International Ltd./Departments/Financial Management/Setup/VAT Rate Change

Fig-1

Click on VAT Rate change Setup option it will open below Screen

Fig-2

Step 2:-

è In this step we need decide which one we need to convert either VAT product posting group or Gen Product Posting group

è Let us take VAT product posting Group

o   In that need to click on VAT prod posting group conversion as their in Fig.2 then it will appears below screen.

Fig-3

o   Then we need to select from code and to code(Ex: From VAT 25 to VAT 10 as shown in Above Figure), then click on OK.

Step 3: -

è In this Step we need to select where we want to change the VAT setup like in Master data, Journals or documents.

è Their we can identify 4 options for each and every setup.

o   Vat Prod.posting group: - if we want to change only VAT prod Posting group we can click on this option.

o   Gen Prod Posting group: - if we want to change only Gen prod Posting group then we can click on this option.

o   Both: - That change needs to apply on both then we need to select on both

o   No: - If we don’t want to apply any where then we need to select he option NO.

Fig-4

 

è Here we can filter particular G/Ls and Particular items also by using the account filter and Item filter Option.

Step 4: - 

è In this step need to select the option perform conversion.

è Then Click on Convert button as shown in below screen.

                     

Fig-5

     

    Step 5: -

While updating it will shows below screen like what are the tables the changes are happening.

                                   

Fig-6

Then we can check which documents and which items and G/l Accounts are updated by using the option in VAT Rate change Log entries.

The vat rate Change log entires is shown like below

Fig-7

 Once the VAT rate changes are completed then VAT rate change tool completed status automatically getting true. Like below

Fig-8