1. Objective and Scope

1.1. Objective of this Operation

The main objective of this document is to explain the customers master data changes process, according to the law applied in Argentina, in case of retentions/ perceptions:

 - IVA

 - Ingresos Brutos

1.2. Scope

This procedure applies to Argentine companies.

2. Definitions

The actualization must be done in the following situations:

- Monthly: the information are received in the month’s ending in D-2 (Transaction VK11) must be loaded by 11:59 pm D-1.

- During the month: it may happens when it’s informed a new framework within the above items, it must be updated at most in 12 hours after the request (Transaction VK12/FD02).

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:

• ...

3. Tasks description

The actualization must be done in the following situations:

- Monthly: the information are received in the month’s ending in D-2 (Transaction VK11) must be loaded by 11:59 pm D-1.

- During the month: it may happens when it’s informed a new framework within the above items, it must be updated at most in 12 hours after the request (Transaction VK12/FD02).

WHAT and HOW - Main content of the operation

The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.

Select the level of heading in the "Paragraph" option.

3.1. I create the base to update the Master Data Update

The Local, responsible for tax information of companies in Argentina, will send the information to update to SBS.

I extract all files from the zipped folder and then open only the document "PadronRGSPer042023":

3.2. I extract a customer list

It will be needed a customer list updated.

In SQ00, change the query areas:

If the 'LOGISTIC_USR' not display, I enter in:

Edit - Other user group

Select report Z_AR_CLIEN_GEN,

Run:

The transaction will open the screen below:

Inform the companies 5686, 4054 (or all Argentine companies):

Run

Extract the list to excel:

Export - Local file - Text with tabs - save as excel file - generate

3.3. I create the base

In the spreadsheet extracted from SAP (SAP spreadsheet) :

Delete the F to L columns

Delete all the colums after "Tax Number 1".

Filter in the "Cty" column anything that is not AR, and delete this data.

In the column "Tax Number 1", sort the spreadsheet by Smallest to Largest

After that, check which is the first number beginning with 3xxxxxxxxx and search for it in the xml file.

Xml file:

 Press Crtl+F to find the number 3xxxxxxxxx, then select this line and press Crtl+shift+end

Crtl+c

Add a new worksheet(2) and paste this data 

Fixing the data in the worksheet(2):

I separate the data by ';'

What matters is the information in columns 'E' and 'I'.

In column 'I', format the data to number

With the data from column E, I can use the 'vlookup' formula in  to find out what percentage is associated with each 'Tax Number 1'.

I go back to SAP spreadsheet:

I manually search the xml file for the 'Tax Number 1' that I could not find through vlookup.

---

After download the customer list updated, it's possible to create the base to insert the information in transaction VK11 condition type J1A2;

The base layout must contain the information below:

• Customer (SAP code)
• Amount (Percentage that comes in the local file TxT)
• Unit (%)
• Valid From and Valid to (month range that the amount is valid)
• Tax code (SD)

You can use an Excel file to create the base or update directly in VK11 if necessary.

To find the customer in the TxT file use the "CUIT" (tax ID):

Using Ctrl + F, it will be possible to find the correct line.

Use as percentage the penultimate column (Column 9th):

OBS: note the coma between semicolons, means that the number is X,XX.

In the example above, the customer with tax ID 30701014762 will be updated in VK11 - J1A2 with 6% (tax code SD) for range 01/12/2019 until 31/12/2019, being in the file respectively:

• P = Percepciones
• Date when the data has been extracted
• Valid From
• Valid to
• "CUIT" = Tax ID
• C/D
• N/S
• N
• Tax percentage
• ...

3.3. I do update VK11 - J1A2

In VK11, enter Condition Type J1A2:

Select Country/Tax type/Customer

Inform – Country: AR and Tax Type: 01

And update all the info needed.

• Below follows an example of November/2019 base created in Excel file.

OBS: Those information were copy and pasted into VK11.

Save it after finished.

3.3. I do check on postings

To check if the data were updated correctly, you may use transaction Z1V_PRICECOND_TOOL.

Condition type = J1A2

Click button "Display Records" to go to next page:

Inform Country = AR and the month range:

Run .

Here you can check what has been posted in the range period.

End of document.