Understanding Tax Reporting for Colombia
This section provides an overview of tax reporting for Colombia, lists prerequisites, and discusses how to:
Run the record selection programs.
Update the NIT for records not reported.
Verify data to report.
Update records to report.
Prepare files to send to DIAN.
Generate and validate the file for DIAN.
Purge the worktable for magnetic media.
Understanding Tax Reporting for Colombia
The Colombian Fiscal Authority (Direccion de Impuestos y Aduanas Nacionales [DIAN]) requires that certain tax information be reported by using magnetic media. You must report the flow of funds into and out of accounts. This flow of funds is referred to as movements.
When you prepare records to report, the system writes information about the records that you select from the F0911, F0902, F0411A, and F76C031A table to the F76C575 table. You then review the records in the F76C575 table and make any necessary changes. You then run programs that write data from the F76C575 table to the F76C571, F76C572, and F76C573 tables. Finally, you generate the magnetic media that you send to DIAN by running the Generation/Validation for DIAN program. This program reads the records in the F76C575, F76C571, and F76C572 tables and writes records to the F007101 and F007111 tables from which you create the magnetic media.
As a final step of the process, you purge the F76C575 table prior to beginning the tax reporting process for the next reporting period. The other tables used in this reporting process are not purged; instead, the system overwrites the data in the tables when you next run the programs that populate the tables.
Process to Report Taxes by Magnetic Tape
To generate and review the information to report, and to create the files to send to DIAN:
Run record selection programs to populate the F76C575 table:
Movement Selection (R76C0110).
Detail AS OF for Accounts Payable (P04423).
Account Receivable Report (R03B4201B).
Accounts Receivable “AS OF” (R76C03B11).
Liabilities Selection (R76C0119A).
G/L Balances Selection (R76C0125).
(R76C130)
Update the tax ID number (Número de Identificacion Tributaria [NIT]) of records that are not reported by running the R76C0155 program.
Generate reports to review and verify data:
Lack of Accounts in the Model B.U. (R76C0143).
Accounts with Movements but not parametered (R76C0144).
Cross Between F0911 and F76C575 (R76C0145).
Detail Movements by NIT, Code and Subcode (R76C0140).
Summarize Movements by NIT, Code and Subcode (R76C0142).
Modify records, as necessary, by using the Revision of Information program (P76C575).
Prepare data to send to DIAN by populating required tables in the JD Edwards EnterpriseOne software:
Prepare the File to Send to DIAN (R76C0120A).
Prepare the File for Economic Groups to Send to DIAN (R76C0120B).
Prepare the File for NIT 222222222 to Send to DIAN (R76C0132).
Upload data to the F007101 and F007111 tables by running the Generation/Validation File DIAN (R76C0135) program.
Create the magnetic media by copying files from the F007111 table using the Text File Processor (P007101) program.
Run the Depuration of F76C575 (R76C0150) program to purge the F76C575 table.
Prerequisites
Before completing the tasks in this section:
Verify that appropriate values are set up in the UDCs used for tax processing.
Verify that the general parameters are set up.
Verify that the appropriate flat-file cross-reference exists in the F47002 table.
Running the Record Selection Programs
This section provides an overview of the selection programs and discusses how to:
Run the Movement Selection program.
Set processing options for Movement Selection (R76C0110).
Generate the Accounts Receivable “AS OF” report.
Set processing options for Accounts Receivable “AS OF” (R76C03B11).
Print the Liabilities Selection report.
Set processing options for Liabilities Selection (R76C0119A).
Print the G/L Balances Selection report.
Set processing options for G/L Balances Selection (R76C0125).
Run the Identification and Stamping of Movements program.
Set processing options for Identification and Stamping of Movements (R76C0130).
Understanding the Record Selection Programs
Run the selection programs to select records from the F0911, F0902, F0411A, and F76C031A tables.
Movements Selection Program (R76C0110)
Run the Movements Selection program to select the accounts to report. The system selects records from the F0911 table, totals the amounts in the accounts by tributary code and subcode, and writes the totals to the F76C575 table. The system verifies that the posting code for the records selected is either D or Y.
You must run this program prior to running the other record selection programs.
Accounts Receivable “AS OF” Report (R76C03B11)
Run the Accounts Receivable “AS OF” program to select records from the F76C031A table and write records to the F76C575 table. You run this report after running the Movements Selection report and the standard as of reports. The system enables you to select the total amount of liabilities and credits by customer or supplier for the F0411A and F76C031A tables.
See JD Edwards EnterpriseOne Accounts Receivable Selected Reports.
Liabilities Selection (R76C0119A)
Run this report after running the R76C0110 and R04901A programs. When you run this program, the system selects records from the F0411A and F76C031A tables and writes records to the F76C575 table.
You should establish different versions of this report to generate records for different GL classes.
G/L Balances Selection (R76C0125)
When you run this report, the system writes to the F76C575 table other expenses and income accounts from the F0902 table. Use this report to select records that do not appear in the JD Edwards EnterpriseOne Accounts Payable and JD Edwards EnterpriseOne Accounts Receivable tables.
Run this report after running the Movements Selection program.
Stamping of Movements (R76C0130)
When you run the Identification and Stamping of Movements (R76C0130) program, the system updates the records in the F76C575 table to indicate whether the record contains minimum value required by DIAN. The system updates the G/L Posting Code - Cash field (data item ALT6) with a 1 if the record meets or exceeds the minimum value, and updates the field with a 2 if the records does not surpass the minimum value. For records updated with a 2, the system also writes the alternative NIT (222222222) to the Math Numeric 10 field (data item MATH10).
The system uses the value in the Special Handling Code field of the Max Amount for Magnetic Tape (76C/TR) UDC table to determine whether the records exceed the minimum value.
Run the Stamping of Movements program after running the Movements Selection program. You can also run this report to update the F76C575 table if you made changes to the NIT or other changes the address book records of suppliers or customers. To update records due to changes in the address book, enter 1 in the Act. Info processing option.
Printing the Movements Selection Report
Select Selection of Information (G76C1010), Movements Selection.
Setting Processing Options for Movement Selection (R76C0110)
Processing options enable you to specify the default processing for programs and reports.
Supplier
|
Received not invoiced |
Enter 1 to have the system access the F43121 table for purchase documents. If you leave this processing option blank, the system accesses the F0911 table. |
|
Third to Report |
Specify whether the system reports the third value based on the address book number or the subledger. |
|
NIT Control Company |
Enter the tax ID number of the company for which you report taxes, if the reporting company is a control, or parent, company. For example, if you report under one parent company, enter the tax ID number of the parent company. If the reporting company is not a control company, enter 0. |
Printing the Accounts Receivable “AS OF” Report
Select Selection of Information (G76C1010), Accounts Receivable “AS OF”.
Setting Processing Options for Accounts Receivable “AS OF” (R76C03B11)
Processing options enable you to specify the default processing for programs and reports.
As Of Date
|
As Of Date |
Enter the date that the system uses to recalculate records. |
Printing the Liabilities Selection Report
Select Selection of Information (G76C1010), Liabilities Section.
Setting Processing Options for Liabilities Selection (R76C0119A)
Processing options enable you to specify the default processing for programs and reports.
Options
|
Field to Summarize |
Enter 1 to summarize by the gross amount. Leave this processing option blank to summarize by the open amount. |
|
Amount Summarized By |
Leave this processing option blank to summarize by supplier or customer. Enter 1 to summarize by the supplier or customer and the account. |
|
Print Details |
Enter 1 to print account details. Leave this processing option blank to print a summary report. |
|
NIT Control Company |
Enter the tax ID number of the company for which you report taxes, if the reporting company is a control, or parent, company. For example, if you report under one parent company, enter the tax ID number of the parent company. If the reporting company is not a control company, enter 0. |
Other Values
|
Tributary Code |
Enter the tributary code that the system assigns to the selected records. |
|
Tributary Sub Code |
Enter the tributary subcode that the system assigns to the selected records. |
|
Category Code to Classify Supplier or Customer |
This processing option is not used. |
|
Value to Report |
Enter 1 to generate the report with the accumulated payment amount. Enter 2 to generate the report with the second value. |
|
Batch Type |
Enter the batch type that the system uses to select records to process. |
|
Batch Number |
Enter the batch number. |
Printing the G/L Balances Selection Report
Select Selection of Information (G76C1010), G/L Balances Selection.
Setting Processing Options for G/L Balances Selection (R76C0125)
Processing options enable you to specify the default processing for programs and reports.
Fiscal Period
|
Fiscal Period |
Enter the period for which the system generates the report. |
|
NIT Control Company |
Enter the tax ID number of the company for which you report taxes, if the reporting company is a control, or parent, company. For example, if you report under one parent company, enter the tax ID number of the parent company. If the reporting company is not a control company, enter 0. |
Printing the Identification and Stamping of Movements Report
Select Special Processes (G76C1020), Identification and Stamping of Movements.
Setting Processing Options for Identification and Stamping of Movements (R76C0130)
Processing options enable you to specify the default processing for programs and reports.
Act. Info
|
Update |
Enter 1 to update address book and tributary identification number. |
|
Company |
Enter the company for which you update information. |
Updating the NIT for Records Not Reported
This section provides an overview and discusses how to run the Massive Stamp to NIT 2222222 program.
Understanding the NIT Update for Records Not Reported
Run the Massive Stamp to NIT 2222222 program (R76C0155) to change the NIT number for records that you are not required to report. When you run this program, the system reads the records in the F76C575 table and changes to 2222222 the NIT number for records for which the value in the G/L Posting Code - Cash field (data item ALT6) is equal to 2. This process enable you to change the value of records for which the G/L Posting Code - Cash field mistakenly contained a value of 1 instead of a value of 2.
Run the Massive Stamp to NIT 2222222 after you run the Movements Selection and Identification and Stamping of Movements programs.
Updating the NIT Number
Select System Configuration (G76C1041), Massive Stamp to NIT 2222222.
Setting Processing Options for Massive Stamp to NIT 2222222 (R76C0155)
Processing options enable you to specify the default processing for programs and reports.
Marked
|
Override Selected Records |
Enter 1 to create the report using the original NIT number. Enter 2 to change the NIT number to 2222222 for all selected records. |
Verifying Data to Report
This section provides an overview of the reports you use to verify data and discusses how to:
Print the Detail Movements by NIT, Code, and Subcode report.
Print the Summarize by NIT, Code, and Subcode report.
Print the Lack of Accounts in the Model B.U. report.
Print the Accounts with movements but not parametered report.
Set processing options for Accounts with movements but not parametered (R76C0144).
Print the Cross between F0911 and F76C575 report.
Set processing options for Cross between F0911 and F76C575 (R76C0145).
Understanding Reports to Verify Data
After you run the programs to select the data to report, verify that the data is correct prior to generating the final files.
Detail Movements by NIT, Code, and Subcode (R76C0140)
When you run the Detail Movements by NIT, Code, and Subcode program, the system reads records in the F76C575 table and generates a report that includes the detail of the accounts. The data is organized by NIT, tributary code, and tributary subcode. Use this report to verify that all accounts are correctly categorized.
No processing options exist for this report.
Summarize Movements by NIT, Code and Subcode (R76C0142)
When you run the Summarize Movements by NIT, Code and Subcode program, the system reads records in the F76C575 table and generates a report that includes a summary of the accounts organized by NIT, tributary code, and tributary subcode. Use this report to verify that all accounts are correctly categorized.
No processing options exist for this report.
Lack of Accounts in the Model B.U. (R76C0143)
When you run the Lack of Accounts in the Model B.U. program, the system reads the records in the F0901 table and generates a report that shows the accounts that exist in the F0901 table that do not exist in the F76C575 table.
No processing options exist for this report.
Accounts with Movements but not Parametered (R76C0144)
Run the Accounts with Movements but not Parametered program to generate a report showing the accounts that had activity during the reporting period, but for which no data was written to the F76C575 table. The system does not write records for accounts which do not meet the parameters set up to identify accounts that must be reported.
Cross Between F0911 and F76C575 (R76C0145)
Run the Cross Between F0911 and F76C575 program to generate a report that shows the accounts that exist in the F0911 table and do not exist in the F76C575 table. You set processing options to specify which accounts in the F0911 table the system selects for comparison.
Printing the Detail Movements by NIT, Code, and Subcode Report
Select Reports (G76C1030), Detail Movements by NIT, Code, and Subcode.
Printing the Summarize Movements by NIT, Code and Subcode Report
Select Reports (G76C1030), Sumarize Movements by NIT, Code and Subcode.
Printing the Lack of Accounts in the Model B.U. Report
Select Reports (G76C1030), Lack of Accounts in the Model B.U.
Printing the Accounts with Movements but not Parametered
Select Reports (R76C1030), Accounts with Movements but not Parametered.
Setting Processing Options for Accounts with Movements but not Parametered (R76C0144)
Processing options enable you to specify the default processing for programs and reports.
Detail Inf.
|
Print Accounts |
Enter 1 to print all accounts. Leave this processing option blank to print only those accounts that do not exist in the business unit model. |
Printing the Cross Between F0911 and F76C575 Report
Select Reports (R76C1030), Cross Between F0911 and F76C575.
Setting Processing Options for Cross Between F0911 and F76C575 (R76C0145)
Processing options enable you to specify the default processing for programs and reports.
Data
|
Level |
Specify the level at which the system totals amounts. Values are: Blank: Account / SubAccount 1: Account / SubAccount / BatchType 2: Account / SubAccount / BatchType / DocType 3: Detail |
|
Date From for G/L movement selection |
Enter the first day of the range of dates for which you run the report. |
|
Date Thru for G/L movement selection |
Enter the last day of the range of dates for which you run the report. |
|
Company |
Enter the company number for which you run the report. |
|
Ledger Type |
Enter a value that exists in the Ledger Type (09/LT) UDC table to specify the ledger type for which you run the report. |
|
Posted Code |
Enter the posted code for which you run the report. |
Updating Records to Report
Use the Revision of Information program (P76C575) to make corrections to records you report.
This section discusses how to:
Update general tax information.
Enter economic group information.
Enter tributary 95 information.
Enter tributary 96 information.
Enter tributary 99 information.
Common Fields Used in This Section
|
Person Type |
Enter a value that exists in the Person/Corporation Code (76C/PC) UDC table to identify whether the entity is an individual or a corporation. |
|
Trade Name |
The system completes this field with the name under which the company conducts business when you complete the Third field. |
|
Third |
Enter the address book number of the supplier or customer. |
|
Tributary Code |
Enter a value that exists in the system 09 category code that you established to identify tributary codes. |
|
Tributary Subcode |
Enter a value that exists in the system 09 category code that you established to identify tributary subcodes. |
Forms Used to Update Tax Account Information
|
Form Name |
FormID |
Navigation |
Usage |
|
Work with update Information |
W76C575AA |
Special Processes (G76C1020), Revision of Information |
Review and select existing records. |
|
Update Record |
W76C575AB |
Click Add on the Work with update Information form. |
Modify tax information. |
|
Economic Groups |
W76C575AF |
On the Update Record form, select Economic Groups from the Form menu. |
Enter tributary codes and subcodes and general ledger values. |
|
Reg. Type 95 |
W76C575AD |
On the Update Record form, select Reg. 95 from the Form menu. |
Enter, review, or modify information for tributary type 95. |
|
Reg. Type 96 |
W76C575AE |
On the Update Record form, select Reg. 96 from the Form menu. |
Enter, review, or modify information for tributary type 96. |
|
Reg. Type 99 |
W76C575AG |
On the Update Record form, select Reg. 99 from the Form menu. |
Enter, review, or modify information for tributary type 99. |
Updating Tax Information
Access the Update Record form.
|
Dep. Mpio Code (Codigo de departamento Municipio) municipal code |
Enter the municipal code. The code must exist in the system 09 category code UDC that is set up to identify municipal codes as specified by DIAN. |
|
Tributary Identification |
Enter the tax ID number. |
|
Customer Bank Acct # (customer bank account number) |
Enter the bank account number of the supplier or customer. |
|
First Value |
Enter the accumulated payment amount. |
|
Second Informed Value |
Leave this field blank. |
|
It reports |
Enter an alternate GL posting code. Records with codes of 1, 2, or X are reported. Records for which this field is blank are not reported. |
|
Alternating NIT |
Enter an alternative NIT. |
Entering Economic Group Information
Access the Economic Groups form.
|
G/L Positive Value |
If the account balance is a positive value, enter the amount in this field. |
|
G/L Negative Value |
If the account balance is a negative value, enter the amount in this field. |
|
It Reports |
Enter an alternative GL posting code. Records with a code of R are reported. Records for which this field is blank are not reported. |
Entering Tributary Code 95 Information
|
Establishment Name |
Enter the commercial name of the company. |
|
Dep. Mpio. Code (Codigo de departamento Municipio) municipal code |
Enter the municipal code. The code must exist in the system 09 category code UDC that is set up to identify municipal codes as specified by DIAN. |
|
Invoicing Type, Invoicing Prefix, Initial Invoice Range, and Final Invoice Range |
These fields are not used. |
Entering Tributary Code 96 Information
Entering Tributary Code 99 Information
Preparing Files to Send to DIAN
This section provides an overview of the programs that prepare files and discusses how to:
Generate the File to Report DIAN program.
Set processing options for File to Report DIAN (R76C0120A).
Generate the Prepare the File for Economic Group program.
Set processing options for Prepare the File for Economic Group (R76C0120B)
Generate the Prepare the File for NIT 2222222 program.
Understanding the Programs to Prepare Files for DIAN
After you run the reports to verify data and make corrections to the records as necessary, run the programs that extract the data to report.
Prepare the File to Send to DIAN (R76C0120A)
Run the Prepare the File to Send to DIAN program to select the records in the F76C575 which must be reported. The system selects the records from the F76C575 table that include the value 1 in the G/L Posting Code - Cash field (data item ALT6), verifies that the person code and additional tax ID information from the address book is present, and writes records to the F76C571 table.
Run this report after running the programs to verify data and prior to running the NIT 2222222 program (R76C0132).
Prepare the File for Economic Groups to Send to DIAN (R76C0120B)
Run the Prepare the File for Economic Groups to Send to DIAN program to select records from the F76C575 table that include the value R (yes) in the G/L Posting Code - Cash field (data item ALT6), The system write records to the F76C571 table.
Prepare the File for NIT 2222222 (R76C0132)
Run the Prepare the File for NIT 2222222 program after you run the Prepare the File to Send to DIAN program. The Prepare the File for NIT 2222222 to Send to DIAN program selects records from the F76C575 table that include the value of 2 in the G/L Posting Code - Cash field (data item ALT6) and inserts records into the F76C572 and F76C577 tables. A value of 2 indicates that the account does not meet the minimum amount to report.
Run this program after you run the Prepare the File to Send to DIAN program.
There are no processing options for this program.
Generating the File to Send to DIAN
Select Generation File DIAN (G76C1040), Prepare the File to send to DIAN.
Setting Processing Options for Prepare the File to send to DIAN (R76C0120A)
Processing options enable you to specify the default processing for programs and reports.
Data
|
Fiscal Year |
Enter the year for which you run the report. |
|
Rounding |
Enter 1 to round amounts to the nearest thousand. If you leave this processing option blank, the system does not round amounts. |
|
Address Line |
Enter the internet address to which you send the file. |
Generating the Economic Groups File to Send to DIAN
Select Generation File DIAN (G76C1040), Prepare the File for Economic Groups to send to DIAN.
Setting Processing Options for Prepare the File for Economic Groups to Send to DIAN (R76C0120B)
Processing options enable you to specify the default processing for programs and reports.
Data
|
Fiscal Year |
Enter the year for which you run the report. |
|
Rounding |
Enter 1 to round amounts to the nearest thousand. If you leave this processing option blank, the system does not round amounts. |
|
Address Line |
Enter the internet address to which you send the file. |
Generating the NIT 2222222 Report
Select Generation File DIAN (G76C1040), Prepare the File for NIT 2222222 to Send to DIAN.
Generating and Validating the File for DIAN
Run the Generation/Validation File DIAN (R76C0135) program to populate the F007101 and F007111 tables. You populate these tables before you use the Text File Processor program (P007101) to create the magnetic files to send to the tax authority. The system reads the data in the F76C575, F76C571, and F76C572 tables to write records to the F007101 and F007111 tables.
This section discusses how to:
Run the program to populate the text file processor tables.
Set processing options for Generation/Validation File DIAN (R76C0135).
Generating and Validating the File for DIAN
Select Generation File DIAN (G76C1040), Generation/Validation File DIAN.
Setting Processing Options for Generation/Validation File DIAN (R76C0135)
Processing options enable you to specify the default processing for programs and reports.
File
|
Generate File |
Enter 1 to generate the file for the economic group. Leave this processing option blank to generate the general file. |
Purging the Work Table for Magnetic Media
Run the Depuration of F76C575 program (R76C0150) to purge all records from the F76C575 table prior to beginning the tax reporting process for the next reporting period. This section discusses how to purge the F76C575 table.
Purging the F76C575 Table
Select System Configuration (G76C1041), Depuration of F76C575.