This chapter contains the following topics:
Note: The programs for working with tax reporting and generating an XML file are grouped under submenus under the Magnetic Media Processing menu (G76CMM). |
The Colombian fiscal authority (Direccion de Impuestos y Aduanas Nacionales de Colombia [DIAN]) issued resolutions 3847/3848 that 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 tax information to DIAN. To use the software to report the fiscal transactions:
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.
Set up address book, general ledger, and other information that the system uses when you generate the DIAN magnetic files.
Set up associations between concept codes, formats, and general ledger accounts.
Set up data selection for formats 1008 and 1009.
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 .
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.
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:
1005
1009
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:
1006
1008
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.
These formats generate general ledger reports:
1011
1012
1034
You must report a fiscal ID of 222222222 for records that have a minimal amount. 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 222222222. and the transaction type as 43.
The filter programs that you use to populate the workfiles for formats 1008 and 1009 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 with the data selection that is needed for that record type. For example, if format 1008 has three concepts for which you must generate a report, create a separate version for each of the three 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:
You run the filter programs over tables that include information about accounts payable, accounts receivable, or general ledger transactions. The system populates one of four 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.
This table shows the temporary tables that are populated by filter programs, and actions that you must take before running the filter program:
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.
You run the DIAN Generate Output Formats 1001, 1002, 1003, 1004, 1007 program (R76C9F02) to generate the XML files for formats 1001, 1002, 1003, 1004, and 1007. You run the DIAN Output XML Generation program for formats 1005, 1006, 1008, 1009, 1011, 1012, and 1034. Different versions of the XML output programs exist for each format.
When you run an XML output 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 XML output 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.
You can run the XML output programs from the DIAN Concepts Add/Review program (P76C0F50) or from the menu for the formats.