E1: 76C: DIAN Output XML Generation (R76C9F02) Incorrectly Sets Error 06 even if CIIU Code is Set Up for the Company/Supplier/Customer in P76C0101 (Doc ID 2654643.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Symptoms

When the DIAN Output XML Generation program (R76C9F02) is run for the 1001 – A/P Payments Made report, its PDF shows error code 06: "missing the department or municipal code".

The department or municipal code is also known as the CIIU code (Clasificación Industrial Internacional Uniforme).

The error happens even though the CIIU code is set up for the company and the supplier on the Colombia Additional Information Revisions (P76C0101) form via the Regional Info row exit in Address Book Revisions (P01012).  The UDC attached to the CIIU field on the P76C0101 form is 76C/CI and is set up with 5-digit codes.

The company and the supplier have also been assigned values on their A/B records for the following cat codes:

• 07 (Economic Activity Colombia (01/07)).
• 25 (Address Book Category Codes (01/25)). Note that the number 25 is just from the GCS test here.  Any A/B Cat Code can be used.

Note: it's been reported that the same happens for the following DIAN formats as well:

• 1003: A/R – Amounts Withheld From Payments That Customers Made To You
• 1005: A/P – Sales VAT To Pay That Was Originated From Canceled Or Rescinded Purchases
• 1006: A/R – Sales VAT Discountable That Is Originated By Canceled Or Rescinded Sales
• 1007: A/R – Income Received

STEPS TO REPRODUCE

1. P0092: Verify that the value in the Localization Country Code field is CO (Colombia).
2. Setup:
   1. UDCs for Colombia
   2. General Parameters (P76CP001): set up general parameters for Tributary Codes.
   3. Next Numbers setup (P0002): system 76C: set up the next number for the header of the DIAN xml file.
   4. DIAN General Setup program (P76C0F00):
      1. General Setup Revision form:
         1. Specify the model business unit that is set up for a model chart of accounts.
         2. For records with minimum amounts: set up the fiscal ID as 222222222, and the transaction type as 43.
      2. Format Setup Revision form:
         1. Set up the next number for the individual formats in the Sending Number field.
         2. Identify the minimum reportable amount for each format, if applicable.
   5. DIAN Person Setup program (P76C020): associate a person or corporation code to a DIAN document type, identify the code as a natural or legal person.
   6. DIAN Setup Concept Code by Format and Account (P76C9F01): set up G/L accounts that will be used on the A/P vouchers.
   7. Interactive Versions:
      1. Set processing options for Address Book Colombian Additional Information (P76C0101)
   8. Company setup:
      1. Set up in P0010
         1. Via regional info row/form exit in P0010 add info re legal company
      2. Set up in P01012
         1. Via regional info row/form exit in P01012 add additional info for Colombia
   9. Taxes
      1. Tax rules (P0022): enter 1 for the Tolerance Amt Warning, 0 for Tolerance Amt Error, and select the Tax on Gross Including Discount option
      2. P4008: Set up a tax rate for Colombia
      3. Economic Activity: use the Tax Parameter (aka I.C.A.) program (P76CI00) to specify the dates, rate, and amount by the city and economic code for the Colombian TRA
      4. Tax Parameters (P76CI00): set up for the Colombian TRA
   10. Batch Versions: set up versions for the 1001 format:
       1. DIAN Generate concept by Account ID (R76C9F01)
       2. DIAN Output XML Generation program (R76C9F02)
   11. Supplier setup:
       1. P04012/P01012: create a new supplier for a Colombian company
       2. Enter additional info for the supplier in P76C0101
3. Processing:
   1. For A/P:
      1. Create vouchers with taxes and post them.
      2. Run the Date File Generation program (R04901A).
   2. For the 1001 format:
      1. Run the filter program to populate the temporary table: DIAN Generate concept by Account ID (R76C9F01), version ZJDE0001 – Format 1001.
      2. Review the records for the report via DIAN Concepts Add / Review (P76C9F02) and modify the concepts for the records, as necessary.
      3. Generate the XML file for submission via R76C9F02 version ZJDE0001.

DESIRED OUTCOME

For the R76C9F02 not to set error 06 – "missing the department or municipal code", when this is set up for the company, supplier, and the customer.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.