Update SUT Product Codes to Tax Determination Good/Service Codes

Use the Update SUT Product Codes to Tax Determination Good/Service Codes tool to update your SUT Product Codes to their Good/Service Code counterparts in Tax Determination.

CAUTION:

Only use this tool after the integration with Tax Determination is complete and you are no longer connected to SUT.

When migrating from SUT to Tax Determination Cloud, you will need to switch from Product Codes to Good/Service Codes. This tool identifies the standard Product Codes and updates them to standard Good/Service Codes. If you have custom Product Codes, contact your Professional Services team to find out if a custom Good/Service Code needs to be created to replace it or if there is a standard Good/Service Code already available.

Download the Product Code and Good/Service Code file from the Sovos Portal.
If it's an .xlsx file, convert it to a .csv. The file has the following naming convention: Products_Month_Year (e.g. Products_Aug_23).
Go to the Cockpit (Transaction /n/SOVOSD/COCKPIT).
Go to Cockpit - Main > Maintain SAP Records, then click Execute next to Update SUT Product Codes to GTD GSC Codes.
Click the Copy to clipboard icon next to the Directory field, then select the Product Code and Good/Service Code CSV file and click Open.
Enter the procedure associated with the tax codes.
You can also click the Copy to clipboard icon and select a procedure, then click Copy.
Select whether the columns in the .csv file are separated by commas or semicolons.
If the file uses a different character to separate the columns from the one you select here, SAP will not be able to read the file correctly.
Click Execute.
Depending on your settings, a message may appear asking for permission to access the CSV file. Select Allow this one time from the dropdown, then click OK.

SAP will generate a report of the identified Tax Codes and which Good/Service Codes, if any, they can be updated to.

If the Status column is green,a valid product code with a corresponding Good/Service Code was identified.
If the Status column is red, it's not possible to update the product code, and a reason is provided in the Message column. There can be three reasons for this:
- There is no corresponding Good/Service Code. When this is the case, the Tax Determination Good/Service Code column in the CSV file will say N/A and the COMMENT column will say There is no existing match in Tax Determination.
- There are multiple corresponding Good/Service Codes. When this is the case, there will be multiple rows with the same SUT Product Code, and the MATCH TYPE column will say M.
- The Product Code is blank.

To update the Product Codes with a green status, click Update GSC Codes, then click Yes on the pop-up message.

To update lines with a red status, continue with one of the following methods:

Update lines with red status by editing the CVS file - This method is more efficient if you need to update many codes.
Update lines with red status directly in SAP - This method is more efficient if you only need to update a couple of codes.

Update lines with red status by editing the CSV file

Open the CSV file and find any product codes that have N/A in the Tax Determination Good/Service Code column. Replace N/A with the Good/Service Code that best fits the product code.

Note:
Use the Good/Service Code and Entity Use Code User Guide available on the Sovos Portal to understand the differences between the various Good/Service Codes. Talk to your tax consultant if you are not sure which code is the best fit.
Find any product codes that have multiple Good/Service Codes. Choose which Good/Service Code best fits the product code.
Keep the row with the selected Good/Service Code and delete all other rows.
Save your changes.
Repeat the steps in Update SUT Product Codes to Global Tax Determination Good/Service Codes tool to run the program again.

The product codes you edited in the CSV file should now have a green status, and you will be able to update these product codes to Good/Service Codes.

Update lines with red status in SAP

Go to Transaction FTXP.
Enter the country of the procedure you need to update, then click Continue.
Enter the tax code of the product code you need to update, then press Enter.
Make sure you're editing the correct tax code and procedure, then click Properties.
In Properties, enter the Good/Service Code in the Product code field.
Click Continue and save the changes.

Sovos Docs

Update SUT Product Codes to Tax Determination Good/Service Codes

Update lines with red status by editing the CSV file

Update lines with red status in SAP

sovos-footer