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

Na planilha extraida do SAP:

Apagar as colunas F-L

Fazer um filtro na coluna  "Cty" a apagar tudo que não for AR

Ordenar a planilha pela coluna "Tax Number 1" e apagar as colunas depois dela 

Com o primeiro número iniciado por 3 na Tax Number 1, procurar no arquivo xml do e-mail do Ivan a linha correspondente (crlt + F)

Seleciono a linha e aperto Crtl+shift+end

Crtl+c

Crtl+v na em uma nova planilha

Separo os dados por ;

O que me interessa são o "Tax Number 1" da coluna E com a informação da penúltima coluna (I)

Voltando na planilha original, faço um vlookup de com o "Tax Number 1" e a coluna E 

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.