This chapter contains the following topics:
Section 6.1, "Understanding How to Generate and Modify DIAN Records"
Section 6.2, "Generating Records for DIAN Formats 1001, 1002, 1003, 1004, and 1007"
The Colombian fiscal authority (Direccion de Impuestos y Aduanas Nacionales de Colombia [DIAN]) issued resolutions 3847 and 3848 to require that companies report fiscal transactions. 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.
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:
Review records to assure that all general ledger accounts for which transactions exist have associated format numbers and concept codes.
See Identifying Missing GL Account/Format/Concept Code Associations.
For formats 1008 and 1009, 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.
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 DIAN Records.
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.
This section provides an overview of how to extract data for DIAN formats 1001, 1002, 1003, 1004, and 1007; an overview of the DIAN Output XML Generation program for formats 1001, 1002, 1003, 1004, and 1007; lists prerequisites; and discusses how to:
Run the DIAN Generate concept by Account ID program.
Set processing options for DIAN Generate concept by Account ID (R76C9F01).
Run the DIAN Output XML Generation program.
Set processing options for DIAN Output XML Generation (R76C9F02).
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.
You use format 1001 to report on payments made. The records for this format 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.
When you rn the DIAN Generate concept by Account ID program for format 1001, the system reads data in the F0911, F76C9F01, Company Additional Information (F7400010), Accounts Payable - Matching Documents (F0413), Accounts Payable Matching Document Detail (F0414), and DIAN MM Minor and Foreign Setup (F76C0F05) tables; and populates the DIAN Formats to Account ID (F76C9F02) temporary table.
The records for format 1001 include:
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.
Payment concept.
Department code
The system extracts this data for Colombian suppliers only.
Municipal code
The system extracts this data for Colombian suppliers only.
Supplier county.
The system uses the value in the F0116.ALCTR field to obtain the reporting code that is associated with the country code from the DIAN Country Code (76C/CC) UDC table.
It the F0116.ALCTR field is blank, the system obtains the country code from the address number of the supplier. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.
Payment amount for transactions with deductions.
Payment amount for transactions without deductions.
You use format 1002 to report on source withholdings made. The records for this format 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. When you run the DIAN Generate concept by Account ID program for format 1002, the system reads data in the F0911, F76C9F01, As-Of Account Payable (F0411A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F05) tables; and populates the DIAN Formats to Account ID (F76C9F02) temporary table.
The records for format 1002 include:
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.
Withholding amount.
Withholding concept.
Payment amount.
Department code.
The system extracts this data for Colombian suppliers only.
Municipal code.
The system extracts this data for Colombian suppliers only.
Supplier county.
The system uses the value in the F0116.ALCTR field to obtain the reporting code that is associated with the country code from the DIAN Country Code (76C/CC) UDC table.
It the F0116.ALCTR field is blank, the system obtains the country code from the address book record of the supplier. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.
You use format 1003 to report on amounts withheld from payments that customers made to you. The records for this format 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. When you run the DIAN Generate concept by Account ID program for format 1003, the system reads data in the F0911, F76C9F01, Receipts Header (F03B13), A/R Customer ledger As Of (F76C034A), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F05) tables; and populates the DIAN Formats to Account ID (F76C9F02) temporary table.
The records for format 1003 include:
Withholding agent's name.
The withholding agent is the company for which the tax reporting files are generated.
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.
Address of the company withholding the tax amounts.
Department code.
The system extracts this data for the company.
Municipal code.
The system extracts this data for the company.
Payment accumulated amount subject to withholding.
You use format 1004 to report on payments that are made for tributary deductions. When you run the DIAN Generate concept by Account ID program for format 1004, the system reads data in the F0911, F76C9F01, Company Additional Information (F7400010), Accounts Payable - Matching Documents (F0413), and Accounts Payable Matching Document Detail (F0414) tables; and populates the DIAN Formats to Account ID (F76C9F02) temporary table.
The records for format 1004 include:
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.
Payment amount.
Deduction concept.
You use format 1007 to report on income received. The records for this format 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. When you run the DIAN Generate concept by Account ID program for format 1007, the system reads data in the F0911, F76C9F01, A/R Check Detail file As Of (F76C034A), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F05) tables; and populates the DIAN Formats to Account ID (F76C9F02) temporary table.
The records for format 1007 include:
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.
Country code of customer.
The system uses the value in the F0116.ALCTR field to obtain the reporting code that is associated with the country code from the DIAN Country Code (76C/CC) UDC table.
It the F0116.ALCTR field is blank, the system obtains the country code from the address book record of the customer. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.
Amount received.
Discount amount.
After you review and correct the data extracted by the DIAN Generate concept by Account ID program, you run the DIAN Output XML Generation - Formats 1001, 1002, 1003, 1004, 1007 program (R76C9F02) to generate the XML file. The R76C9F02 program reads the records in the F76C9F02 table and writes records to the DIAN Output Format Header (F76C0F01) and DIAN Output Format Detail (F76C0F11) tables. It also writes the XML file to the Text Processor Header table (F007101) and Text Process Detail Table (F007111). You copy the XML file from the text processor tables to the media that you use to submit the records.
The system does not include in the output files any records for which the system generates an error message for missing information. The error messages are included on the PDF generated by the DIAN Output XML Generation program (R76C9F02). The PDF also includes error messages if errors occurred when the system inserted records into the F76C0F01 or F76C0F11 tables, or when the system generated the XML files.
The R76C9F02 program updates the record status field in the F76C9F02 table. Status codes for the RS (record status) field include:
| Code | Description |
|---|---|
| (blank) | No concept (no status) |
| 1 | Record includes the concept code that was written to the table by one of the filter programs. |
| 2 | Record includes a concept code that was manually entered in the DIAN Concepts Review program (P76C0F50). |
| 3 | The record was added to the XML file. |
| 4 | Processing for the record ended in an error. |
Before you complete the tasks in this section, run the DIAN Concept Account Setup Control Report (R76C9F00) to verify that all accounts are set up.
Select one of these navigations:
Format 1001 (G76C1001), DIAN Generate concept by Account ID - Format 1001 (version ZJDE0001).
Format 1002 (G76C1002), DIAN Generate concept by Account ID - Format 1002 (version ZDJE0002).
Format 1003 (G76C1003), DIAN Generate concept by Account ID - Format 1003 (version ZJDE0003).
Format 1004 (G76C1004), DIAN Generate concept by Account ID - Format 1004 (version ZJDE0004).
Format 1007 (G76C1007), DIAN Generate concept by Account ID - Format 1007 (version ZJDE0005).
Processing options enable you to specify default processing values.
Enter a value from the DIAN Magnetic Media Formats (76C/FM) UDC table to specify the format for which you generate records. Valid values for this program are:
01001: Payment made
01002: Source withholding made
01003: Source withholding suffered
01004: Payments made with tributary deduction
01007: Income received
Blank: Add. The system appends additional records to the existing records in the DIAN Formats to Account ID table (F76C9F02).
1: Delete. The system deletes existing records in the F76C9F02 table before writing new records.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
Select from these navigations:
Format 1001 (G76C1001), DIAN Output XML Generation (version ZJDE0001).
Format 1002 (G76C1002), DIAN Output XML Generation (version ZJDE0002).
Format 1003 (G76C1003), DIAN Output XML Generation (version ZJDE0003).
Format 1004 (G76C1004), DIAN Output XML Generation (version ZJDE0004).
Format 1007 (G76C1007), DIAN Output XML Generation (version ZJDE0005).
Processing options enable you to specify default processing values.
Specify the version of the DIAN Generate concept by Account ID program (R76C9F01) from which to retrieve the fiscal year, legal company, and format number.
This section provides an overview of format 1005 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 (1005) program.
Set processing options for DIAN Output XML Generation (1005) (R76C4F62).
You use format 1005 to report on sales VAT to pay that was originated from canceled or rescinded purchases. This format uses 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.
From 2011, the government requires to divide the Tax value into two concepts: tax value generated, and tax value by return. The system identifies the tax value type based on the document type of the transaction. You set up the returns document type in UDC table 76C/DV.
To generate records for and report on format 1005, 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 (1005) program (R764C62).
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 (F76C0F05) tables and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1005 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 1005 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.
Select Format 1005 (G76C1005), DIAN Sales VAT to Pay originated by Purchases.
Processing options enable you to set default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
Select Format 1005 (G76C1005), DIAN Output XML Generation.
Processing options enable you to set default processing values.
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.
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.
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.
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.
This section provides an overview of DIAN format 1006 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 (1006) program.
Set processing options for DIAN Output XML Generation (1006) (R76C3F52).
You use format 1006 to report on sales VAT discountable that is originated by canceled or rescinded sales. This format 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.
From 2011, the government requires to divide the Tax value into two concepts: tax value generated, and tax value by return. The system identifies the tax value type based on the document type of the transaction. You set up the returns document type in UDC table 76C/DV.
To generate records for and report on format 1006, you:
Run the DIAN Sales VAT Discountable Origination by Sales program.
Generate the XML file.
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 (F76C0F05) tables, and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1006 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.
Minimal amounts.
The system generates one summary record per customer when the income on which the tax amount is based is less than the amount specified in the DIAN General Setup program (P76C0F00).
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 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.
Select Format 1006 (G76C1006), DIAN Sales VAT Discountable originated by Sales.
Processing options enable you to set default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
Select Format 1006 (G76C1006), DIAN Output XML Generation.
Processing options enable you to specify default processing values.
Enter the version of the R76C4F50 program from which the system determines the fiscal year for the report.
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.
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.
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.
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) (R76C3F82).
You use format 1008 to report on accounts receivable pending. This format uses 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.
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 F76C0F05) 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.
The system extracts this data for Colombian customers only. If the data does not exist in the source table, the system prints an error message on the PDF report.
Municipal code.
The system extracts this data for Colombian customers only. If the data does not exist in the source table, the system prints an error message on the PDF report.
Customer country
The system uses the value in the F0116.ALCTR field to obtain the country code from the DIAN Country Code (76C/CC) UDC table.
It the F0116.ALCTR field is blank, the system obtains the country code from the address number of the customer. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.
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.
Processing options enable you to specify default processing values.
Enter the concept code that describes the information included in the report.
Select Format 1008 (G76C1008), DIAN Accounts Receivable Pending.
Processing options enable you to specify default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
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.
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 number of a range of version numbers.
Enter the last number of a range of version numbers.
Select Format 1008 (G76C1008), DIAN Output XML Generation.
Processing options enable you to specify default processing values.
Enter the version of the R76C4F80 program from which the system determines the fiscal year on which to report.
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.
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.
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.
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).
You use format 1009 to report on accounts payable pending. This format uses 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.
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 (F76C0F05) 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.
The system extracts this data for Colombian suppliers only. If the data does not exist in the source table, the system prints an error message on the PDF report.
Municipal code.
The system extracts this data for Colombian suppliers only. If the data does not exist in the source table, the system prints an error message on the PDF report.
Supplier country.
The system uses the value in the F0116.ALCTR field to obtain the country code from the DIAN Country Code (76C/CC) UDC table. If the F0116.ALCTR field is blank, the system obtains the country code from the address number of the supplier. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.
This report retrieves the value in the Open Amount field in the F0411A table to calculate the accounts payables pending by supplier.
Processing options enable you to set default processing values.
Enter the concept code that describes the information included in the report.
Select Format 1009 (G76C1009), DIAN Accounts Payable Pending.
Processing options enable you to set default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
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.
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 number of a range of version numbers.
Enter the last number of a range of version numbers.
Select Format 1009 (G76C1009), DIAN Output XML Generation.
Processing options enable you to set default processing values.
Enter the version of the R76C4F90 program from which the system determines the fiscal year on which to report.
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.
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.
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.
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).
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.
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.
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.
Select Format 1011 (G76C1011), DIAN Tributary Information.
Processing options enable you to specify default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
Select Format 1011 (G76C1011), DIAN Output XML Generation.
Processing options enable you to specify default processing values.
Enter the version of the R76C9F11 program from which the system determines the fiscal year on which to report.
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.
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.
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.
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).
You use format 1012 to report on tributary information for certificates and titles. This format uses 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.
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 (F76C0F05) 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
Country code.
The system uses the value in the F0116.ALCTR field to obtain the country code from the DIAN Country Code (76C/CC) UDC table.
It the F0116.ALCTR field is blank, the system obtains the country code from the address number of the company. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.
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.
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.
Select Format 1012 (G76C1012), DIAN Tributary Information (Certificates, Titles).
Processing options enable you to specify default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which to generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
Select Format 1012 (G76C1012), DIAN Output XML Generation.
Processing options enable you to specify default processing values.
Enter the version of the DIAN Tributary Information (Certificates, Titles) program from which the system determines the fiscal year on which to report.
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.
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.
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.
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).
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.
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.
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.
Select Format 1034 (G76C1034), DIAN Consolidate Balance Sheet.
Processing options enable you to specify default processing values.
Enter a value that exists in the DIAN Magnetic Media Formats UDC table (76C/FM) to specify the legal report number.
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.
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.
Enter the fiscal year for which you generate the report. For example, to generate the report for the fiscal year 2008, enter 8.
Select Format 1034 (G76C1034), DIAN Output XML Generation.
Processing options enable you to specify default processing values.
Enter the version of the R76C9F34 program from which the system determines the fiscal year on which to report.
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.
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.
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.
This section provides an overview of how to review and modify record types for DIAN and lists the forms used to review and modify concept codes.
Use the DIAN Concepts Add/Review program (P76C0F50) to review and modify the concept codes 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: DIAN formats 1005 and 1006 do not have concept codes. |
|
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 or the DIAN Concepts Review form when you select the format with which to display records. The 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.
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.
| 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. |