(COL) Using Magnetic Media to Report Taxes

This chapter provides an overview of electronic tax reporting for Colombia and discusses how to:

Generate information for DIAN legal report 1001.
Generate information for DIAN legal report 1002.
Generate information for DIAN legal report 1003.
Generate information for DIAN legal report 1004.
Generate information for DIAN legal report 1005.
Generate information for DIAN legal report 1006.
Generate information for DIAN legal report 1007.
Generate information for DIAN legal report 1008.
Generate information for DIAN legal report 1009.
Generate information for DIAN legal report 1011.
Generate information for DIAN legal report 1012.
Generate information for DIAN legal report 1034.
Review and modify record types (concepts) after generating information for reports.
Generate the XML file using an interactive program.

Note. The programs for working with tax reporting and generating an XML file are grouped under submenus under the Magnetic Media Processing menu (G76CMM).

Understanding Electronic Tax Reporting for Colombia

The Colombian fiscal authority (Direccion de Impuestos y Aduanas Nacionales de Colombia [DIAN]) issued resolutions 10147, 10148, and 12466 to require that companies report fiscal transactions for the fiscal year 2005. The formats required for reporting on these fiscal transactions are different from formats required by previous resolutions for previous years.

Reporting the fiscal transactions requires you to process accounts payable, accounts receivable, and general ledger transactions.

Companies must generate reports in an XML format, use the Muisca software provided by DIAN to validate the media files, and submit the files to DIAN.

Overview of Process

JD Edwards EnterpriseOne software enables you to generate the reports that you need to report information to DIAN. To use the software to report the fiscal transactions:

Set up the system:
- Set up required user-defined codes (UDCs).
- Set up a next numbering scheme in the Next Numbers program (P0002).
- Set up legal companies.
- Associate a person or corporation code to a DIAN document type, identify the code as a natural or legal person, and specify whether a foreign person or corporation is subject to the Transference Prices Regimen (TPR).
- Set up Address Book, general ledger, and other information that the system uses when you generate the DIAN magnetic files.
  
  See Setting Up the System to Work with Tax Reporting.
Set up data selection for the record types (concepts) for which you generate reports.

Setting up data selection in separate versions for the formats (reports) enables you to generate reports for multiple record types when running the filter programs.

See Report Setup Programs.

For each report (format) for which you need to generate information:

Run the filter program to populate the temporary table that the system uses to store the data that you must report.

See Filter Programs.

The temporary table should include only records for the format that you are working with. When you run filter programs, you can set a processing option to delete existing records in the temporary table.
Review the records for the reports and modify the concepts for the records, as necessary.

See Reviewing and Modifying Record Types for DIAN.

Review and correct the records, and then generate the XML files for submission for a format before you process records for another format.
Generate the XML files for submission.

Generating the XML files is a two-step process. You first run the Output XML Generation program for a report, and then use the Text File Processor program (P007101) to copy the files to the media that you use to submit the report to DIAN.

See XML Generation Programs.

See Working with the Text File Processor.

Accounts Payable Records

Before you work with the formats that process accounts payable records, you must generate as of records by running the Date File Generation program (R04901A).

These formats process accounts payable records:

1001
1002
1004
1006
1009

Accounts Receivable Records

Before you work with the formats that process accounts receivable records, you must generate as of records by running the Data File Generation A/R program (R76C03B11).

These formats process accounts receivable records:

1003
1005
1007
1008

General Ledger Records

Before you work with the formats that process general ledger records:

Set up system 09 category code UDCs with the concepts for formats 1011, 1012, and 1034.
Use the Account Master program (P0901) to associate the category codes with the appropriate accounts.

See Creating the Chart of Accounts.

These formats generate general ledger reports:

1011
1012
1034

Records with Minimal Amounts or Foreign Suppliers

The JD Edwards EnterpriseOne software for Colombia was updated to comply with legal resolution 12807. This resolution requires that you report a fiscal ID of 222222222 for records that have a minimal amount and report a fiscal ID of 444444000 for records for foreign suppliers. In addition to the required fiscal ID, you report these transactions using a transaction type of 43, which you set up in the Document Type UDC table (76C/DT).

To determine whether the transactions are reported as minimal amounts, the system:

Totals the transactions for a format type, legal company, and supplier.
Compares the total to the amount that you set up as the minimal amount for the format.

If the total amount does not exceed the minimum amount that you set up, the system writes one line for the total of the transactions, and assigns to the line the fiscal ID and transaction type that you set up in the DIAN General Setup program (P76C0F00). You must set up the fiscal ID as 2222222222 and the transaction type as 43.

When you generate the reports for foreign suppliers for the affected formats, the system uses the value in the Person/Corporation Code field in the Address Book Colombian Additional Information program (P76C0101) to determine whether a supplier is a foreign supplier. The system accesses the Person Codes Setup table (F76C020) to determine whether the value in the Person/Corporation Code field in the address book record is associated with the code for a foreign supplier who is not subject to Transference Prices Regimen (TPR). If the code is 1 (the foreign supplier is not subject to TPR), the system assigns to the transaction the fiscal ID and transaction type that you set up for foreign suppliers in the DIAN General Setup program (P76C0F00). You must set up the fiscal ID as 444444000 and the transaction type as 43.

Report Setup Programs

Many of the reports have a setup program that enables you to set up data selection for each record type (concept) for which you report. You do not run the setup programs, and they do not produce a report. These programs exist to enable data selection for multiple concepts.

Set up a separate version for each record type for which you report. Set up a separate version for each record type with the data selection that is needed for that record type. For example, if format 1001 has eight concepts for which you must generate a report, create a separate version for each of the eight concepts and set the data selection for each version to correspond to the information that you need for the concept.

Consider setting up the versions with consecutive numbers. Consecutive version numbers enable you to more easily specify which versions of the setup programs include the data selection for the filter programs. You can specify which versions of the setup program the system uses for the filter program by setting processing options in the filter programs. The processing options enable you to specify up to five individual versions, and to specify a range of versions.

This table shows the setup program used by each filter program, and the tables from which you make your data selection:

Setup Program ID	Filter Program Using Setup	Tables for Data Selection
DIAN Configurable Setup Concepts for Format 1001 (R76C4F11)	DIAN Payments Made (R76C4F10)	As-Of Account Payable (F0411A) and Company Additional Information (F7400010)
DIAN Configurable Setup Format 1002 (R76C4F21)	DIAN Source Withholding Made (R76C4F20)	As-Of Account Payable (F0411A) and Company Additional Information (F7400010)
DIAN Configurable Setup Format 1003 (R76C3F31)	DIAN Source Withholding Suffered (R76C3F30)	Receipts Header (F03B13), A/R Check Detail file As Of (F76C034A), and Company Additional Information (F7400010)
DIAN Configurable Setup Format 1004 (R76C4F41)	DIAN Payments Made Originated by Tributary Deductions (R76C4F40)	Accounts Payable - Matching Documents (F0413) and Accounts Payable Matching Document Detail (F0414)
DIAN Configurable Setup Format 1007 (R76C3F71)	DIAN Incomes Received (R76C3F70)	A/R Check Detail file As Of (F76C034A) and Company Additional Information (F7400010)
DIAN Configurable Setup Format 1008 (R76C3F81)	DIAN Accounts Receivable Pending (R76C3F80)	A/R Customer Ledger As Of (F76C031A) and Company Additional Information (F7400010)
DIAN Configurable Setup Format 1009 (R76C4F91)	DIAN Accounts Payable Pending (R76C4F90)	As-Of Account Payable (F0411A) and Company Additional Information (F7400010)

Note. Formats 1005, 1006, 1011, 1012, and 1034 do not use setup programs.

Filter Programs

You run the filter programs over tables that include information about accounts payable, accounts receivable, or general ledger transactions. The system populates one of three temporary tables with the data for the record types for the reports. The system uses the data in the temporary tables when you generate the output XML files. The system also reads the DIAN MM Minor and Foreign Setup table (F76C0F05) to obtain the fiscal ID and transaction type that is used for reporting when the transactions are for minimal amounts or for foreign suppliers.

This table shows the temporary tables that are populated by filter programs, and actions that you must take before running the filter program:

Filter Programs	Temporary Table Populated	Required Before Running
DIAN Payments Made (R76C4F10)	DIAN Formats File by Invoice (F76C4F02)	Run the Date File Generation program (R04901A) to populate the F0411A table.
DIAN Source Withholding Made (R76C4F20)	DIAN Formats File by Invoice (F76C4F02)	Run the Date File Generation program (R04901A) to populate the F0411A table.
DIAN Source Withholding Suffered (R76C3F30)	DIAN Formats File by Payment (F76C4F01)	Run the Data File Generation A/R program (R76C03B11) to populate the F76C034A table. You must include in your data selection the payment instrument that indicates the receipt for the withholding amounts.
DIAN Payments Made Originated by Tributary Deductions (R76C4F40)	DIAN Formats File by Payment (F76C4F01)	NA
DIAN Sales VAT Discountable Origination by Sales (R76C3F50)	F76C4F02	Verify that the appropriate values exist in the 76C/VT UDC table.
DIAN Sales VAT to Pay Originated by Purchases (R76C4F60)	F76C4F02	Verify that the appropriate values exist in the 76C/VT UDC table.
DIAN Incomes Received (R76C3F70)	F76C4F02	Run the Data File Generation A/R program (R76C03B11) to populate the F76C031A and F76C034A tables. Verify that appropriate values exist in the DIAN Writeoff Codes UDC table (76C/WO).
DIAN Accounts Receivable Pending (R76C3F80)	F76C4F02	Run the Data File Generation A/R program (R76C03B11) to populate the F76C031A and F76C034A tables.
DIAN Accounts Payable Pending (R76C4F90)	F76C4F02	Run the Date File Generation program (R04901A) to populate the F0411A table.
DIAN Tributary Information (R76C9F11) DIAN Tributary Information (Certificates, Titles) (R76C9F14) DIAN Consolidate Balance Sheet (R76C9F34)	DIAN Formats File by Account ID (F76C9F11)	Verify that: A system 09 category code UDC table is set up for formats 1011, 1012, and 1034. The system 09 category codes are associated with the appropriate accounts in your chart of accounts.

When you run each filter program, you set a processing option to determine whether the system deletes existing records in the temporary table that is populated by the filter program. Generally, you delete records in a table if the records were generated for a DIAN report other than the report that you are currently running, or if you are regenerating a report.

XML Generation Programs

When you run the DIAN Output XML Generation program for each program, the system reads the data in the temporary table to which the filter program for the format wrote data, and writes comma-delimited data to the DIAN Output Format Header (F76C0F01) and DIAN Output Format Detail (F76C0F11) tables.

The DIAN Output XML Generation programs also write records to the Text Processor Header table (F007101) and Text Processor Detail Table (F007111). You use the Text File Processor program (P007101) to copy data from the text file processor tables to the media that you submit for tax reporting.

Generating Information for DIAN Format 1001

This section provides an overview of DIAN format 1001 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1001 (R76C4F11).
Run the DIAN Payments Made program.
Set processing options for DIAN Payments Made (R76C4F10).
Run the DIAN Output XML Generation (1001) program.
Set processing options for DIAN Output XML Generation (1001) (R76C4F12).

Understanding DIAN Format 1001

You use format 1001 to report on payments made. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts.

To generate records for and report on format 1001, you:

Use the DIAN Configurable Setup Concepts for Format 1001 program (R76C4F11) to set up versions and data selection for each concept for format 1001.

You create versions for each concept, set the processing option to specify the concept, and then set up data selection for each concept on which you report.
Run the DIAN Payments Made program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Run the DIAN Output XML Generation (1001) program.

DIAN Payments Made (R76C4F10)

When you run this program, the system reads data in the Company Additional Information (F7400010), Accounts Payable - Matching Documents (F0413), Accounts Payable Matching Document Detail (F0414), and DIAN MM Minor and Foreign Setup (F76C0F50) tables; and populates the DIAN Formats File by Invoice (F76C4F02) temporary table.

The DIAN Payments Made report includes:

Supplier name.

The system uses the alpha name or mailing name from the address book record for a supplier that is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for suppliers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Supplier's fiscal ID.

If the supplier is a foreign supplier, the system uses the fiscal ID that you set up in the DIAN General Setup program.
Payment concept.
Payment amount.

You use processing options to specify the versions of the DIAN Configurable Setup Concept for Format 1001 program that you set up for data selection.

Setting Processing Options for DIAN Configurable Setup Concepts for Format 1001 (R76C4F11)

Processing options enable you to specify default processing values.

Process

Enter the Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Payments Made Program

Select Format 1011 (G76C1001), DIAN Payments Made.

Setting Processing Options for DIAN Payments Made (R76C4F10)

Processing options enable you to specify default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary file	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Payments Made report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F11 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Payments Made program. You can specify up to five versions.
Enter the first version for the version range	If specifying a range of version numbers, enter the first number of a range of version numbers.
Enter the last version for the version range	If specifying a range of version numbers, enter the last number of a range of version numbers.

Running the DIAN Output XML Generation (1001) Program

Select Format 1001 (G76C1001), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1001) (R76C4F12)

Processing options enable you to specify default processing values.

Process

Version of R76C4F10	Enter the version of the DIAN Payments Made program from which the system determines the fiscal year for which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1002

This section provides an overview of DIAN format 1002 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1002 (R76C4F21).
Run the DIAN Source Withholding Made program.
Set processing options for DIAN Source Withholding Made (R76C4F20).
Run the DIAN Output XML Generation (1002) program.
Set processing options for DIAN Output XML Generation (1002) (R76C4F22).

Understanding DIAN Format 1002

You use format 1002 to report on source withholdings made. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1002, you:

Use the DIAN Configurable Setup for Format 1002 program (R76C4F21) to set up versions and data selection for each concept for format 1002.

You create versions for each concept, set the processing option to specify the concept, and then set up data selection for each concept on which you report.
Run the DIAN Source Withholding Made program (R76C4F20).
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Run the DIAN Output XML Generation program (R76C4F22).

DIAN Source Withholding Made Program (R76C4F20)

When you run the DIAN Source Withholding Made program, the system reads data in the As-Of Account Payable (F0411A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables; and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1002 format.

The DIAN Source Withholding Made report includes:

Name of each supplier for whom amounts have been withheld.

The system uses the alpha name or mailing name from the address book record for a supplier that is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for suppliers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Fiscal ID of each supplier.

If the supplier is a foreign supplier, the system uses the fiscal ID that you set up in the DIAN General Setup program.
Withholding amount.
Withholding concept.
Payment amount.
Department code.
Municipal code.

You use processing options to specify the versions of the DIAN Configurable Setup Concepts for Format 1002 program that you set up for data selection.

Setting Processing Options for DIAN Configurable Setup Concepts for Format 1002 (R76C4F21)

Processing options enable you to set default processing values.

Process

Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Source Withholding Made Program

Select Format 1002 (G76C1002), DIAN Source Withholding Made.

Setting Processing Options for DIAN Source Withholding Made (R76C4F20)

Processing options enable you to set default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary file	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate a new record. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Source Withholding Made report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F21 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Source Withholding Made program. You can specify up to five versions.
Enter the first version for the version range.	Enter the first number of a range of version numbers.
Enter the last version for the version range	Enter the last number of a range of version numbers.

Running the DIAN Output XML Generation Program

Select Format 1002 (G76C1002), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (R76C4F22)

Processing options enable you set up default processing values .

Process

Version of R76C4F20	Enter the version of the DIAN Source Withholding Made program from which the system determines the fiscal year for the report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1003

This section provides an overview of DIAN format 1003 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1003 (R76C3F31).
Run the DIAN Source Withholding Suffered program.
Set processing options for DIAN Source Withholding Suffered (R76C3F30).
Run the DIAN XML Output Generation (1003) program.
Set processing options for DIAN XML Output Generation (1003) (R76C3F32).

Understanding DIAN Format 1003

You use format 1003 to report on amounts withheld from payments that customers made to you. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1003, you:

Set up format information in versions of the DIAN Configurable Setup Concepts for Format 1003 program.

You create versions for each concept, set the processing option to specify the format, and then set up data selection for each concept on which you report.
Run the DIAN Source Withholding Suffered program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Source Withholding Suffered (R76C3F30)

When you run this program, the system reads data in the Receipts Header (F03B13), A/R Customer ledger As Of (F76C034A), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables; and populates the DIAN Formats File by Payment (F76C4F01) temporary table.

The DIAN Source Withholding Suffered report includes:

Withholding agent's name.

The withholding agent is the customer who withheld tax or contribution amounts from the payment remitted to you.

The system uses the alpha name or mailing name from the address book record for a customer that is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for customers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Withholding agent's fiscal ID.
Withholding amount.
Withholding concept.

You use processing options to specify the versions of the DIAN Configurable Setup Concepts for Format 1003 program that you set up for data selection.

Setting Processing Options for DIAN Configurable Setup concepts for Format 1003 (R76C3F31)

Processing options enable you to specify default processing values.

Process

Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Source Withholding Suffered (R76C3F30) Program

Select Format 1003 (G76C1003), DIAN Source Withholding Suffered.

Setting Processing Options for DIAN Source Withholding Suffered (R76C3F30)

Processing options enable you to specify default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary file	Enter 1 to delete a previously existing DIAN Formats File by Payment (F76C4F01) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F01 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Source Withholding Suffered report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F31 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Source Withholding Suffered program. You can specify up to five versions.
Enter the first version for the version range.	Enter the first number of a range of version numbers.
Enter the last version for the version range	Enter the last number of a range of version numbers.

Running the DIAN Output XML Generation (1003) Program

Select Format 1003 (G76C1003), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1003) (R76C3F32)

Processing options enable you to specify default processing values.

Process

Version of R76C4F30	Enter the version of the DIAN Source Withholding Suffered program from which the system determines the fiscal year for the report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1004

This section provides an overview of DIAN format 1004 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1004 (R76C4F41).
Run the DIAN Payments made Originated by Tributary Deductions program.
Set processing options for DIAN Payments made Originated by Tributary Deductions (R76C4F40).
Run the DIAN Output XML Generation (1004) program.
Set processing options for DIAN Output XML Generation (1004) (R76C4F42).

Understanding DIAN Format 1004

You use format 1004 to report on payments that are made for tributary deductions. To generate records for and report on format 1004, you:

Set up format information in versions of the DIAN Configurable Setup Concepts for Format 1004 program.

You create versions for each concept, set the processing option to specify the format, and then set up data selection for each concept on which you report.
Run the DIAN Payments made Originated by Tributary Deductions program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Payments Made Originated by Tributary Deductions (R76C4F40)

When you run this program, the system reads data in the Company Additional Information (F7400010), Accounts Payable - Matching Documents (F0413), and Accounts Payable Matching Document Detail (F0414) tables and populates the DIAN Formats File by Payment (F76C4F01) temporary table.

The DIAN Payments Made Originated by Tributary Deductions report includes:

Supplier's name.

The system uses the alpha name or mailing name from the address book record for a supplier that is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for suppliers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Supplier's fiscal ID.

If the supplier is a foreign supplier, the system uses the fiscal ID that you set up in the DIAN General Setup program.
Payment amount.
Deduction concept.

You use processing options to specify the versions of the DIAN Configurable Setup Concepts for Format 1004 program that you set up for data selection.

Setting Processing Options for DIAN Configurable Setup Concepts for Format 1004 (R76C4F41)

Processing options enable you to set default processing values.

Process

Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Payments Made Originated Tributary Deductions Program

Select Format 1004 (G76C1004), DIAN Payments Made Originated Tributary Deductions.

Setting Processing Options for DIAN Payments Made Originated Tributary Deductions (R76C4F40)

Processing options enable you to set default processing values.

Process

Legal Format Number	E nter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary file	Enter 1 to delete a previously existing DIAN Formats File by Payment (F76C4F01) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F01 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Payments Made Originated by Tributary Deductions report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F41 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Payments Made Originated Tributary Deductions program. You can specify up to five versions.
Enter the first version for the version range.	Enter the first number of a range of version numbers.
Enter the last version for the version range	Enter the last number of a range of version numbers.

Running the DIAN Output XML Generation (1004) Program

Select Format 1004 (G76C1004), DIAN Output XML Generation.

Setting Processing Options for Output XML Generation (1004) (R76C4F42)

Processing options enable you to specify default processing values.

Process

Version of R76C4F40	Enter the version of the DIAN Payments Made Originated Tributary Deductions program (R76C4F40) from which the system determines the fiscal year for the report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1005

This section provides an overview of DIAN format 1005 and discusses how to:

Run the DIAN Sales VAT Discountable Origination by Sales program.
Set processing options for DIAN Sales VAT Discountable Origination by Sales (R76C3F50).
Run the DIAN Output XML Generation (1005) program.
Set processing options for DIAN Output XML Generation (1005) (R76C3F52).

Understanding DIAN Format 1005

You use format 1005 to report on sales VAT discountable that is originated by canceled or rescinded sales. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1005, you:

Run the DIAN Sales VAT Discountable Origination by Sales program.
Generate the XML file.

DIAN Sales VAT Discountable Origination by Sales

When you run the DIAN Sales VAT Discountable Origination by Sales program, the system reads data in the A/R Customer ledger As Of (F76C031A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables, and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1005 format.

The DIAN Sales VAT Discountable report includes:

Customer's name.

The system uses the alpha name or mailing name from the address book record for a customer who is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for customers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Customer's fiscal ID.
Tax amount.

You use data selection to set up this program to select records for credit notes. The program determines which tax amounts to include in the report for the 1005 format by retrieving the G/L offset account from the F76CUI02 table and comparing it to the two-character code in the 76C/VT UDC table. If the characters match, the system includes the tax amount in the report.

Running the DIAN Sales VAT Discountable originated by Sales Program

Select Format 1005 (G76C1005), DIAN Sales VAT Discountable originated by Sales.

Setting Processing Options for DIAN Sales VAT Discountable originated by Sales (R76C3F50)

Processing options enable you to set default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary file	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Running the DIAN Output XML Generation (1005) Program

Select Format 1005 (G76C1005), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1005) (R76C3F52)

Processing options enable you to specify default processing values.

Process

Version of R76C4F50	Enter the version of the R76C4F50 program from which the system determines the fiscal year for the report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1006

This section provides an overview of format 1006 and discusses how to:

Run the DIAN Sales VAT to Pay Originated by Purchases program.
Set processing options for DIAN Sales VAT to Pay Originated by Purchases (R76C4F60).
Run the DIAN Output XML Generation (1006) program.
Set processing options for DIAN Output XML Generation (1006) (R76C4F62).

Understanding DIAN Format 1006

You use format 1006 to report on sales VAT to pay that was originated from canceled or rescinded purchases. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1006, you:

Set processing options for DIAN Sales VAT to Pay Originated by Purchases.
Run the DIAN Sales VAT to Pay Originated by Purchases program (R76C4F60).
Run the DIAN Output XML Generation (1006) program (R764C62).

DIAN Sales VAT to Pay Originated by Purchases

When you run the DIAN Sales VAT to Pay Originated by Purchases program, the system reads data in the As-Of Account Payable (F0411A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1006 format.

The DIAN Sales VAT to Pay Originated by Purchases report includes:

Supplier's name.

The system uses the alpha name or mailing name from the address book record for a supplier who is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for suppliers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Supplier's fiscal ID.
Tax amount.

You use data selection to set up this program to select records for credit notes. The program determines which tax amounts to include in the report for the 1006 report by retrieving the G/L offset account from the F76CUI02 table and comparing it to the two-character code in the 76C/VT UDC table. If the characters match, the system includes the tax amount in the report.

Running the DIAN Sales VAT to Pay originated by Purchases Program

Select Format 1006 (G76C1006), DIAN Sales VAT to Pay originated by Purchases.

Setting Processing Options for DIAN Sales VAT to Pay originated by Purchases (R76C4F60)

Processing options enable you to set default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Running the DIAN Output XML Generation (1006) Program

Select Format 1006 (G76C1006), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1006) (R76C4F62)

Processing options enable you to set default processing values.

Process

Version of R76C4F60	Enter the version of the DIAN Sales VAT to Pay originated by Purchases program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1007

This section provides an overview of DIAN format 1007 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1007 (R76C3F71).
Run the DIAN Incomes Received program.
Set processing options for DIAN Incomes Received (R76C3F70).
Run the DIAN Output XML Generation (1007) program.
Set processing options for DIAN Output XML Generation (1007) (R76C3F72).

Understanding DIAN Format 1007

You use format 1007 to report on income received. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1007, you:

Set up format information in versions of the DIAN Configurable Setup Concepts for Format 1007 program.

You create versions for each concept, set the processing option to specify the format, and then set up data selection for each concept on which you report.
Run the DIAN Incomes Received program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Incomes Received (R76C3F70)

When you run this program, the system reads data in the A/R Check Detail file As Of (F76C034A), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables and populates the DIAN Formats File by Invoice (F76C4F02) temporary table.

The system retrieves information about the gross income received amounts and discount and refund amounts from the F76C034A table. The system also compares the values in the DIAN Writeoff Codes UDC table (76CWO) to the values in the Reason Code UDC table (03B/RC). The system writes the write-off amount to the Discounts and Refunds field of the F76C4F02 table only for records for which the codes match.

The DIAN Incomes Received report includes:

Customer name.

The system uses the alpha name or mailing name from the address book record for a customer who is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for customers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Fiscal ID of the customer.
Income concept.
Amount received.
Discount amount.

You use processing options to specify the versions of the DIAN Configurable Setup Concepts for Format 1007 program that you set up for data selection.

Setting Processing Options for DIAN Configurable Setup Concepts for Format 1007 (R76C3F71)

Processing options enable you to specify default processing values.

Process

Enter the Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Incomes Received Program

Select Format 1007 (G76C1007), DIAN Incomes Received.

Setting Processing Options for DIAN Incomes Received (R76C3F70)

Processing options enable you to specify default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Incomes Received report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F71 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Incomes Received program. You can specify up to five versions.
Enter the first version for the version range.	Enter the first number of a range of version numbers.
Enter the last version for the version range	Enter the last number of a range of version numbers.

Running the DIAN Output XML Generation (1007) Program

Select Format 1007 (G76C1007), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1007) (R76C3F72)

Processing options enable you to set default processing values.

Process

Version of R76C4F70	Enter the version of the R76C4F70 program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1008

This section provides an overview of DIAN format 1008 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1008 (R76C3F81).
Run the DIAN Accounts Receivable Pending program.
Set processing options for DIAN Accounts Receivable Pending (R76C3F80).
Run the DIAN Output XML Generation (1008) program.
Set processing options for DIAN Output XML Generation (1008) (R76C4F82).

Understanding DIAN Format 1008

You use format 1008 to report on accounts receivable pending. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1008, you:

Set up format information in versions of the DIAN Configurable Setup Concepts for Format 1008 program.

You create versions for each concept, set the processing option to specify the format, and then set up data selection for each concept on which you report.
Run the DIAN Incomes Received program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Accounts Receivable Pending (R76C3F80)

When you run this program, the system reads data in the A/R Customer ledger As Of (F76C031A), A/R Check Detail file As Of (F76C034A), Company Additional Information (F7400010). and DIAN MM Minor and Foreign Setup F76C0F50) tables and populates the DIAN Formats File by Invoices (F76C4F02) temporary table.

The DIAN Incomes Received report includes:

Customer name.

The system uses the alpha name or mailing name from the address book record for a customer who is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for customers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Fiscal ID of the customer.
Debt concept.
Amount pending.
Department code.
Municipal code.

You use processing options to specify the versions of the DIAN Configurable Setup Concepts for Format 1008 program that you set up for data selection.

Setting Processing Options for DIAN Configurable Setup Concepts for Format 1008 (R76C3F81)

Processing options enable you to specify default processing values.

Process

Enter the Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Accounts Receivable Pending Program

Select Format 1008 (G76C1008), DIAN Accounts Receivable Pending.

Setting Processing Options for DIAN Accounts Receivable Pending (R76C3F80)

Processing options enable you to specify default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Accounts Receivable Pending report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F81 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Accounts Receivable Pending program. You can specify up to five versions.
Enter the first version for the version range.	Enter the first number of a range of version numbers.
Enter the last version for the version range	Enter the last number of a range of version numbers.

Running the DIAN Output XML Generation (1008) Program

Select Format 1008 (G76C1008), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1008) (R76C4F82)

Processing options enable you to specify default processing values.

Process

Version of R76C4F80	Enter the version of the R76C4F80 program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1009

This section provides an overview of DIAN format 1009 and discusses how to:

Set processing options for DIAN Configurable Setup Concepts for Format 1009 (R76C4F91).
Run the DIAN Accounts Payable Pending program.
Set processing options for DIAN Accounts Payable Pending (R76C4F90).
Run the DIAN Output XML Generation (1009) program.
Set processing options for DIAN Output XML Generation (1009) (R76C4F92).

Understanding DIAN Format 1009

You use format 1009 to report on accounts payable pending. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1009, you:

Set up format information in versions of the DIAN Configurable Setup concepts for Format 1009 program.

You create versions for each concept, set the processing option to specify the format, and then set up data selection for each concept on which you report.
Run the DIAN Accounts Payable Pending program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Accounts Payable Pending (R76C4F90)

When you run the DIAN Accounts Payable Pending program, the system reads data in the As-Of Account Payable (F0411A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1009 format.

The DIAN Accounts Payable Pending report includes:

Supplier name.

The system uses the alpha name or mailing name from the address book record for a supplier who is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for suppliers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).
Supplier's fiscal ID.

If the supplier is a foreign supplier, the system uses the fiscal ID that you set up in the DIAN General Setup program.
Debt concept.
Amount pending.
Department code.
Municipal code.

This report retrieves the value in the Open Amount field in the F0411A table to calculate the accounts payables pending by supplier.

Setting Processing Options for DIAN Configurable Setup Concepts for Format 1009 (R76C4F91)

Processing options enable you to set default processing values.

Process

Enter the Concept Code

Enter the concept code that describes the information included in the report.

Running the DIAN Accounts Payable Pending Program

Select Format 1009 (G76C1009), DIAN Accounts Payable Pending.

Setting Processing Options for DIAN Accounts Payable Pending (R76C4F90)

Processing options enable you to set default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76CF402) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Version

Use these processing options to specify the versions for the record types for which you generate the DIAN Accounts Payable Pending report. You can specify individual versions in the first five processing options, specify a range of versions by entering values in the last two processing options, or specify both individual versions and a range of versions.

Version for Data Selection from the R76C4F91 Program	Enter the number of the version that you set up to specify the record type (concept code) and data selection for which you run the DIAN Accounts Payable Pending program. You can specify up to five versions.
Enter the first version for the version range.	Enter the first number of a range of version numbers..
Enter the last version for the version range	Enter the last number of a range of version numbers.

Running the DIAN Output XML Generation (1009) Program

Select Format 1009 (G76C1009), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1009) (R76C4F92)

Processing options enable you to set default processing values.

Process

Version of R76C4F90	Enter the version of the R76C4F90 program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1011

This section provides an overview of DIAN form 1011, lists prerequisites, and discusses how to:

Run the DIAN Tributary Information program.
Set processing options for DIAN Tributary Information (R76C9F11).
Run the DIAN Output XML Generation (1011) program.
Set processing options for DIAN Output XML Generation (1011) (R76C9F13).

Understanding DIAN Format 1011

You use format 1011 to report on tributary information. To generate records for and report on format 1011, you:

Run the DIAN Tributary Information program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Tributary Information (R76C9F11)

When you run the DIAN Tributary Information program, the system reads data in the Account Master (F0901), Account Balances (F0902), and Company Additional Information (F7400010) tables, and generates the DIAN Formats File by Account ID (F76C9F11) temporary table for the 1011 format.

The DIAN Tributary Information report includes:

Tax concept
Amount reported

When you run the DIAN Tributary Information program, the system writes the number of accounts for each concept to the F76C9F11 table. When you run the DIAN Output XML Generation program for the 1011 format, the system sums the amounts in the accounts.

For example, if five accounts in the account master are assigned the general ledger category code for concept 6000 and each account has 1000 as the amount, the system shows 5 in the F76C9F11 table and 5000 for concept 6000 in the XML file.

Prerequisites

Before you complete the tasks in this section:

Verify that a system 09 category code UDC table is set up for format 1011.
Verify that the system 09 category codes are associated with the appropriate accounts in your chart of accounts.

Use the Account Master program (F0901) to verify your accounts.

Running the DIAN Tributary Information Program

Select Format 1011 (G76C1011), DIAN Tributary Information.

Setting Processing Options for DIAN Tributary Information (R76C9F11)

Processing options enable you to specify default processing values.

Process

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Account ID (F76C9F11) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C9F11 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Running the DIAN Output XML Generation (1011) Program

Select Format 1011 (G76C1011), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1011) (R76C9F13)

Processing options enable you to specify default processing values.

Process

Version of R76C9F11	Enter the version of the R76C9F11 program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1012

This section provides an overview of DIAN format 1012, lists prerequisites, and discusses how to:

Run the DIAN Tributary Information (Certificates, Titles) program.
Set processing options for DIAN Tributary Information (Certificates, Titles) (R76C9F14).
Run the DIAN Output XML Generation (1012) program.
Set processing options for DIAN Output XML Generation (1012) (R76C9F16).

Understanding the DIAN 1012 Format

You use format 1012 to report on tributary information for certificates and titles. To meet the requirements of legal resolution 12807, this format was modified to use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. To generate records for and report on format 1012, you:

Run the DIAN Tributary Information (Certificates, Titles) program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Tributary Information (Certificates, Titles) (R76C9F14)

When you run the DIAN Tributary Information program, the system reads data in the Account Master (F0901), Account Balances (F0902), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F50) tables and generates the DIAN Formats File by Account ID temporary table for the 1012 format.

The DIAN Tributary Information report includes:

Tax concept
Amount reported
Name and surname
Fiscal ID

When you run the DIAN Tributary Information (Certificates, Titles) program, the system writes the number of accounts for each concept to the F76C9F11 table. When you run the DIAN Output XML Generation program for the 1012 format, the system sums the amounts in the accounts.

For example, if five accounts in the account master are assigned the general ledger category code for concept 1100 and each account has 1000 as the amount, the system shows 5 in the F76C9F11 table and 5000 for concept 1100 in the XML file.

Prerequisites

Before you complete the tasks in this section:

Verify that a system 09 category code UDC table is set up for format 1012.
Verify that the system 09 category codes are associated with the appropriate accounts in your chart of accounts.

Use the Account Master program (F0901) to verify your accounts.

Running the DIAN Tributary Information (Certificates, Titles) Program

Select Format 1012 (G76C1012), DIAN Tributary Information (Certificates, Titles).

Setting Processing Options for DIAN Tributary Information (Certificates, Titles) (R76C9F14)

Processing options enable you to specify default processing values.

Defaults

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Account ID (F76C9F11) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C9F11 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which to generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Running the DIAN Generate Output XML Generation (1012) Program

Select Format 1012 (G76C1012), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1012) (R76C9F16)

Processing options enable you to specify default processing values.

Process

Version of R76C9F14	Enter the version of the DIAN Tributary Information (Certificates, Titles) program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Generating Information for DIAN Format 1034

This section provides an overview of DIAN format 1034, lists prerequisites, and discusses how to:

Run the DIAN Consolidate Balance Sheet program.
Set processing options for DIAN Consolidate Balance Sheet (R76C9F34).
Run the DIAN Output XML Generation (1034) program.
Set processing options for DIAN Output XML Generation (1034) (R76C9F36).

Understanding DIAN Format 1034

You use format 1034 to report on balance sheet information. To generate records for and report on format 1034, you:

Run the DIAN Consolidate Balance Sheet program.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and change concepts (record types) in the temporary table, as necessary.
Generate the XML file.

DIAN Consolidate Balance Sheet (R76C9F34)

When you run the DIAN Consolidate Balance Sheet program, the system reads data in the Account Master (F0901), Account Balances (F0902), and Company Additional Information (F7400010) tables and generates the DIAN Formats File by Account ID (F76C9F11) temporary table for the 1034 format.

The DIAN Consolidate Balance Sheet report includes:

Tax concept
Amount reported

When you run the DIAN Consolidate Balance Sheet program, the system writes the number of accounts for each concept to the F76C9F11 table. When you run the DIAN Output XML Generation program for the 1034 format, the system sums the amounts in the accounts.

For example, if five accounts in the account master are assigned the general ledger category code for concept 1000 and each account has 500 as the amount, the system shows 5 in the F76C9F11 table and 2500 for concept 1000 in the XML file.

Prerequisites

Before you complete the tasks in this section:

Verify that a system 09 category code UDC table is set up for format 1012.
Verify that the system 09 category codes are associated with the appropriate accounts in your chart of accounts.

Use the Account Master program (F0901) to verify your accounts.

Running the DIAN Consolidate Balance Sheet Program

Select Format 1034 (G76C1034), DIAN Consolidate Balance Sheet.

Setting Processing Options for DIAN Consolidate Balance Sheet (R76C9F34)

Processing options enable you to specify default processing values.

Defaults

Legal Format Number	Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
Delete or Add Temporary File	Enter 1 to delete a previously existing DIAN Formats File by Invoice (F76C4F02) temporary table and generate new records. Leave this processing option blank to append records to an existing F76C4F02 table.
Legal Company	Enter the address book number of the legal company for which you generate the report. The system uses data for all companies that are combined under the legal company that you specify.
Fiscal Year	Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2005, enter 5.

Running the DIAN Output XML Generation (1034) Program

Select Format 1034 (G76C1034), DIAN Output XML Generation.

Setting Processing Options for DIAN Output XML Generation (1034) (R76C9F36)

Processing options enable you to specify default processing values.

Process

Version of R76C9F34	Enter the version of the R76C9F34 program from which the system determines the fiscal year on which to report.
Execution Mode for XML Generation	Enter 01 if this report is the initial generation of the XML file. Enter 02 if this is a replacement generation of the XML file.
Replacement Sending Number	If you entered 02 in the Execution Mode for XML Generation processing option, enter the submission number for this generation of the report. For example, if this is the third submission of the report that you are sending to DIAN after submitting two other reports, enter 3.
Version Number for Header XML	Enter the version number that the system prints in the header record for the XML file. If you do not complete this processing option, the system uses a default value of 06.

Reviewing and Modifying Record Types for DIAN

This section provides an overview of how to review and modify record types for DIAN and lists the forms used to review and modify record types.

Understanding How to Review and Modify Record Types for DIAN

Use the DIAN Concepts Add/Review program (P76C0F50) to review and modify the records that exist in the temporary tables that are generated by the filter programs. You can select the format with which the system displays the records and change the concept (record type) for the record, if necessary.

Note. If you determine that records for a format or concept are missing, you must change the data selection for the concept and rerun the filter program to repopulate the temporary table.

The system displays an Edit Concept form when you select the format with which to display records. The Edit Concept form varies depending on the type of information stored in the temporary table. For example, when you choose to display records for the formats that you use to report general ledger transactions, the system displays an Edit Concept form that includes the object account and subsidiary, ledger type, business unit, company, and amounts. When you choose to display records for accounts payable transactions, the system displays an Edit concept form that includes the supplier number and tax ID, and the payment amount and date.

Forms Used to Review and Modify Records Types (Concepts) for DIAN

Form Name	FormID	Navigation	Usage
Work With Legal Formats	W76C0F50A	Format menu (G76C1001, G76C1002, and so on), DIAN Concepts Add/Review	Search for and select a record for a specified format.
Edit Concept	W76B0F51B W76C0F52B W76C0F53B W76C0F54A W76C0F54B W76C0F55A	Select a format, and then click Select.	The Edit Concept form that appears is based on the fields in the temporary table that is populated by the filter program. Review the concepts for each record.
Select New Concept	W76C0F50D	Select a record, and select Choose Concept from the Row menu.	Change the concept for the record.

Generating the XML File Interactively

In addition to using a menu option to generate the XML file, you can interactively generate the XML file. This section lists the forms that you use to interactively generate the XML file.

Forms Used to Generate the XML File Interactively

Form Name	FormID	Navigation	Usage
Work With Legal Formats	W76C0F50A	Format menu (G76C1001, G76C1002, and so on), DIAN Concepts Add/Review	Search for and select a record for a specified format.
Select XML Generation Mode	W76C0F50B	On the Work With Legal Formats form, select a format and then select Generate XML from the Form menu.	Specify whether the file generation is a replacement file or a new file.
Select Sequence for Legal Format	W76C0F50C	On the Select XML Generation Mode form, select the Replacement option.	If you are generating a replacement file, select the file that you want to regenerate and then click Select.