R12: EBTAX: Argentina Purchasing Flat Files Not Accepted By Fiscal Authority

(Doc ID 2391575.1)

Last updated on APRIL 28, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Argentina Payables

When attempting to generating the flat files ,
the following error occurs.

ERROR
-----------------------
The field import delivery number must be reported: This error is present because the field
is reported with an lpad to fill the data collected with zeros on the left to generate a numeric string of 16 positions.
This is correct if the value is inserted on the invoice on the field SUPPLIER_TAX_INVOICE_NUMBER
but if this field is null the value reported must be equivalent to 16 blank spaces.

The supplier vendor code must be 80: the code generated on the correspondent field was 00.

The field VAT Aliquot (rate) do not exists.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Argentina localization
2. Path: Other -> Requests -> Run
3. Run the following programs:

Argentine RG3685 Purchasing Flat File
Argentine RG3685 Purchasing Rates Flat File

After generating the flat files using those reports, the output files saves as txt were uploaded to the AFIP application generating the following errors:

A) Argentine RG3685 Purchasing Flat File:

The field import delivery number must be reported: This error is present because the field
is reported with an lpad to fill the data collected with zeros on the left to generate a numeric string of 16 positions.
This is correct if the value is inserted on the invoice on the field SUPPLIER_TAX_INVOICE_NUMBER
but if this field is null the value reported must be equivalent to 16 blank spaces.


After correcting manually the data for the first error reported (in two cases found),
extraction report generated two records for an invoice (this file must include only one record per invoice, per supplier).

B) Argentine RG3685 Purchasing Rates Flat File

- The supplier vendor code must be 80: the code generated on the correspondent field was 00.
In the contrary, the Argentine RG3685 Purchasing Flat File generated this value correctly.

- The field VAT Aliquot (rate) do not exists.
In this field according to the AFIPs requirement, it must be included a CODE identifying the rate, the report is including the rate.

Just as example, in the first record the user got:

003000020000000000000000103300000000000306085177460000000000300002100000000000006300
the VAT Aliquot field goes between positions 66 and 69, so the value present there is 2100

the aliquot codes tables referenced by afip requirements is the following:
tax rate aliquot code
0,00_____ 3
10,50____ 4
21,00____ 5
27,00____ 6
5,00_____ 8
2,50_____ 9

so the value to be reported in this position should be 0005 (aliquot code) instead of 2100 (aliquot rate).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Go live in September.
 Operations Budget impacted 3 Million euros per month. High visibility of top management.

The files are not accepted by tax authority.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms