1. Localizations for Colombia Implementation Guide
  2. Understanding How to Extract Data for DIAN Formats 1001, 1002, 1003, 1004, and 1007

Understanding How to Extract Data for DIAN Formats 1001, 1002, 1003, 1004, and 1007

You run the DIAN Generate concept by Account ID program for formats 1001, 1002, 1003, 1004, and 1007. This program reads records in the Account Ledger table (F0911) for accounts that are set up in the DIAN Setup Concept Code by Format and Account program (P76C9F01), and writes records to the F76C9F02 table. The program also reads records in certain tables used by the setup programs to obtain information about supplier, address book, and other setup.

Because each of these formats write to the same temporary table (F76C9F02), you will generally:

  • Run the DIAN Generate concept by Account ID program for one format.

  • Review the records generated and make any needed changes.

  • Run the DIAN Output XML Generation program (R76C9F02) for the format.

  • Run the DIAN Generate concept by Account ID program for the next format, setting the Delete or Add Temporary file processing option to delete existing records from the F76C9F02 table.

The menu options for the DIAN Generate concept by Account ID program and DIAN Output XML Generation program (R76C9F02) are set to specific versions for each format. For example, on the Format 1001 menu (G76C1001), the DIAN Generate concept by Account ID option and DIAN Output XML Generation option run version ZJDE0001 of each program. The DIAN Generate concept by Account ID and DIAN Output XML Generation options on the Format 1007 menu (G76C1007) run the ZJDE0007 version. The default values for the processing options for each version are set to the appropriate values for the format.