My Oracle Support Banner

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 APRIL 23, 2020

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.2 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
JD Edwards EnterpriseOne General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Please note that the DIAN Magnetic Media functionality is no longer supported.  For details see KM article E1: 76C: Colombia Magnetic Media (Doc ID 2656817.1).

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:

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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