This chapter provides an overview of tax rate areas for Colombia and discusses how to:
Set up economic activity information.
Set up tax parameters.
Set up general parameters for tributary codes.
Set up the system for tax reporting.
See Also
You use the Tax Rate/Areas program (P4008) to set up tax rate area types to specify whether a tax area is for solidarity, withholding, or value-added tax (VAT). In Colombia, VAT is also known as IVA (impuesto al valor agregado). The system stores tax rate area information in the Taxes table (F4008). After you use the Tax Rate/Areas program to enter tax rate areas, the system displays the Additional Tax Information form on which you enter the economic activity code for Colombia.
See Setting Up Economic Activity Code Information.
You should set up tax rate areas within a structure, for example, A BBB CCC D. This table represents how you can set up the structure:
Character |
Example |
A (Tax type) |
G (General VAT) |
BBB (Tax concept) |
COM (Purchasing) HON (Fees) SER (Services CMI (Commissions) ARR (Leasing) M (Manual tax settlement) Note. Use M when there is no specific VAT or withholding percentage and the tax calculation is entered manually. |
CCC (Tax subgroup) |
For COM (Purchasing):
For SER (Services):
For ARR (Leasing):
For M (Manual tax settlement):
|
Using this example, tax areas could be:
GCOMGEN: General VAT for automatic general purchases.
EHONGENM: Manual exempt general fees.
Tax Rules
You set up tax rules by company in the Tax Rules program (P0022). When you set up tax rules for Colombian companies, enter 1 for the Tolerance Amt Warning, 0 for Tolerance Amt Error, and select the Tax on Gross Including Discount option.
See Also
This section provides an overview of economic activity codes, lists prerequisites, and discusses how to associate economic activity codes to tax rate areas.
When you use the Tax Rate/Areas program to set up tax rate codes for Colombia, the system automatically displays the Additional Tax Information form on which you associate the economic activity code to the tax rate area. The system saves the code that you enter to the Additional Tax Areas - COL table (F76C4008).
When you enter standard vouchers or logged vouchers, the system retrieves the economic activity code when it calculates taxes on the vouchers. The system saves information about the relationship between the voucher and the economic activity code in the A/P Ledger Tag Table - COL table (F76C4011). If no economic activity code exists for the tax rate code in the F76C4008 table, the system uses the economic activity code from the supplier's address book record. If no code exists in the address book record, the system returns an error.
When you set up tax rates codes you can enter or modify the economic activity code for existing tax rate codes by selecting the tax rate code and then selecting Regional Info from the Row menu on the Tax Rate/Area Revisions form.
You further define economic activity by specifying the effective dates, tax rate, and minimum amount on which the tax is assessed. You use the I.C.A. program (P76CI00) to specify the dates, rate, and amount by the city and economic code. You set a processing option in the I.C.A. program to identify the system 00 category code in which you set up codes for the source city for which you pay taxes by city and economic activity.
Before you complete the task in this section:
Verify that the value in the Localization Country Code field in the User Profile Revisions program (P0092) is CO (Colombia).
Verify that the economic activity codes are set up in the 01/07 UDC table.
Form Name |
FormID |
Navigation |
Usage |
Work With Tax Rate/Areas |
W4008A |
Tax Parameters (G76C412), Tax Rate/Areas |
Review and select existing records. |
Tax Rate/Area Revisions |
W4008B |
Click Add on the Work With Tax Rate/Areas form. |
Enter tax rate area information. |
Additional Tax Information |
W76C4008B |
Click OK on the Tax Rate/Area Revisions form. |
Associate the economic activity code to the tax rate area. |
Work With Economic Activity |
W76CI00B |
Tax Parameters (G76C412), I.C.A. |
Review and select existing records. |
Economic Activity |
W76CI00D |
Click Add on the Work With Economic Activity form. |
Specify the effective dates, tax rate, and minimum amount by city and economic activity code. |
Processing options enable you to specify default processing values for programs and reports.
Currency
Currency Code - From |
Specify the currency code in which you process the records. |
Category Code |
Specify the system 00 category code in which you set up the codes to identify the source city for which you pay taxes by city and economic activity. The system uses the code when it calculates taxes by economic activity. System 00 category codes are for the JD Edwards EnterpriseOne Address Book system. |
Access the Additional Tax Information form.
Economic Activity Colombia |
Enter a value that exists in the 01/07 UDC table to specify the economic activity code. |
Access the Economic Activity form.
Tax Type |
Enter the tax type in this field, which is equal to the two first characters of the GL offset defined in the tax area. |
City Code |
Leave this field blank. |
City/ Ec. Activity (city/economic activity) |
Enter a values that exists in the 00/xx UDC table to specify the economic activity code. Category code 00/xx is the category code that you specify in the Category Code processing option. Note. The system no longer uses the values in UDC 76C/AE. |
Tax Rate |
Enter the tax rate. |
Minimum Amount |
Enter the minimum value of an item that can be taxed. For example, if you enter 50, taxes are not calculated on items valued at less than 50 pesos. This field is used for processing sales and purchase orders only. |
This section discusses how to set up tax parameters for Colombia.
Form Name |
FormID |
Navigation |
Usage |
Work With Tax Parameters |
W76CI00A |
Tax Parameters (G76C412), Tax Parameters |
Review and add tax parameters. |
Tax Parameters |
W76CI00C |
Click Add or Select on the Work With Tax Parameters form. |
Revise and define tax parameters. |
Access the Tax Parameters form.
Tax Rules System |
Enter a user-defined code (H00/TX) that specifies the system to which the tax rules apply. The system allows you to select one option only. Values are: 1: AR and Sales Order 2: AP and Purchasing 3: GL and Journal Entry |
Company/Supplier Tax Payer |
Enter a user-defined code (76C/TC) that specifies the type of tax payer for the company that originates the transaction. |
Tax Type |
Enter the tax type, which is equal to the two first characters of the GL offset defined in the tax area |
Minimum Amount |
Specify whether the maximum amount that an item can be taxed must be taken into consideration to calculate withholdings. |
Economic Activity |
Specify whether the percentage of a tax must be calculated by city and economic activity. If you select Y, you must define percentages by city and economic activity. |
Tax Rate 1 |
Enter the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area. Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07. If the tax is a withholding, enter the percentage as a negative number. |
This section discusses how to set up the tributary codes.
Form Name |
FormID |
Navigation |
Usage |
General Parameters |
W76CP001A |
System Configuration (G76C1041), General Parameters |
Specify the category codes that the system uses to identify business units, accounts, and other tributary information. |
Access the General Parameters form.
This section provides overviews of next numbers, legal companies, and general system setup for tax reporting; and discusses how to:
Associate codes for natural and legal entities to DIAN (Direccion de Impuestos y Aduanas Nacionales de Colombia) document types.
Set up address book, general ledger, and other format information.
Associate minimum amounts and next numbers with DIAN format numbers.
Set up minimal amounts and foreign supplier information.
See Also
Setting Up UDCs to Use Magnetic Media for Tax Reporting
The electronic tax reporting process requires that you set up next numbers for the header of the XML files and for each format. Set up the next number for the header in system 76C in the Next Numbers program (P0002). Set up the next number for the individual formats in the Sending Number field on the Format Setup Revision form in the DIAN General Setup program (P76C0F00).
You set up legal company and transactional company relationships to enable many companies to be unified in one legal company. The relationship between the companies enables you to produce reports that combine data from more than one company. For example, you can associate the companies that you use for transaction processing (transactional companies) with companies that you use for legal reporting (legal companies) so that legal reports can contain data for more than one transactional company. At a minimum, a legal company and a transactional company relationship must exist for the default company.
Before you process records for electronic tax reporting, you must set up the system with information that the system needs to complete some of the data required by the DIAN formats.
Legal and Natural Person Information
You use the DIAN Person Code Setup COL 00 form in the DIAN Person Setup program (P76C020) to associate DIAN document types to codes that exist in the Person/Corporation Code (76C/PC) UDC table. The system saves the information in the Person Codes Setup table (F76C020). You assign codes from the 76C/PC UDC table to customers and suppliers when you set up address book records for your customers and suppliers. The system uses the association between the DIAN document type and the person or corporation code to determine the type of document used to verify a taxpayer's status. For example, you might associate the DIAN document code for the NIT (Número de Identificación Tributaria) to the code for a corporation. You also specify whether the code in the 76C/PC UDC table applies to a natural person, and whether a foreign natural person or foreign legal entity is a member of the Transference Prices Regimen.
You use the General Setup Revision form in the DIAN General Setup program (P76C0F00) to specify information about address book records. You specify the values in the Type Code (01/W0) UDC table that the system uses for names, and specify the address book category codes that the system uses for department and municipal codes.
General Ledger Information
You use the General Setup Revision form in the DIAN General Setup program to specify the model business unit that is set up for a model chart of accounts, and specify the category codes in system 09 that you set up with values for formats 1011, 1012, and 1034.
XML Generation Information
You use the General Setup Revision form in the DIAN General Setup program to identify the next numbering scheme that the system uses to number the XML submission and to define terms that identify foreign entities and entities which do not meet minimum amount requirements.
You use the Format Setup Revision form in the DIAN General Setup program to identify the minimum reportable amount for each format and to establish the next number for the report for each format.
Minor Amounts and Foreign Supplier Setup
You use the DIAN General Setup program to set up the tax ID and transaction types (document types) that the system uses when you report transactions involving:
A foreign supplier
A total that does not exceed the minimum amount for the format type.
The system saves the values that you set up to the DIAN MM Minor and Foreign Setup table (F76C0F05) and uses these values for transactions involving foreign suppliers or minimal amounts when you run the generation programs for these format types:
1001
1002
1003
1005
1006
1007
1008
1009
1012
Before you complete the tasks in this section:
Set up these UDCs:
Type Code (01/W0) to describe the codes for first name, other name, first surname, and second surname.
Address Book (system 01) category codes to describe department and municipal codes.
Account Master (system 09) category codes to identify formats used in reporting.
Identify the model business unit number in which you set up a model chart of accounts.
Access the DIAN Person Code Setup COL 00 form.
Pers/Corp – Colombia (person/corporation Colombia) |
Enter a value that exists in the Person/Corporation Code (76C/PC) UDC table that identifies the type of person or corporation to which you associate a document type. |
DIAN Doc. Type (Direccion de Impuestos y Aduanas Nacionales de Colombia document type) |
Enter a value that exists in the DIAN Document Types (76C/DT) UDC table that identifies the document type that you associate with the person or corporation. |
Nat. Per. (natural person) |
Enter Y or 1 for a natural person. Enter N or 0 for a legal person. |
For. TPR (foreign Transference Prices Regimen) |
Leave this field blank if the person or legal entity is not foreign. Enter 1 for a foreign person or legal entity who does not belong to the TPR. Enter 2 for a foreign person or legal entity who belongs to the TPR. |
Access the General Setup Revision form.
General Setup
Address Book
Access the General Setup Revision form.
Depart. Munic. Cat. Code (department and municipal category code) |
Enter a number that identifies the JD Edwards EnterpriseOne Address Book (system 01) category code that defines the department and municipal codes. |
Firm Name Alpha or Mailing |
Enter Y or 1 to specify that the system uses the mailing name from the address book record. Enter N or 0 to specify that the system uses the alpha name from the address book record. The system uses the value that you enter when the customer or supplier is a legal entity. |
Who's Who Code First Name |
Enter a value that exists in the Type Code (01/W0) UDC table to identify the field in the Who's Who record in the JD Edwards EnterpriseOne Address Book system that the system uses for the first name. |
Who's Who Code Other Name |
Enter a value that exists in the Type Code (01/W0) UDC table to identify the field in the Who's Who record in the JD Edwards EnterpriseOne Address Book system that the system uses for an additional name. |
Who's Who Code First Surname |
Enter a value that exists in the Type Code (01/W0) UDC table to identify the field in the Who's Who record in the JD Edwards EnterpriseOne Address Book system that the system uses for the first surname. |
Who's Who Code Second Surname |
Enter a value that exists in the Type Code (01/W0) UDC table to identify the field in the Who's Who record in the JD Edwards EnterpriseOne Address Book system that the system uses for the second surname. |
General Ledger
Access the General Setup Revision form.
Model Business Unit |
Enter the code that represents the model business unit used to define the accounts setup for magnetic media. |
Format 1011 Cat. Code (format 1011 category code) |
Enter the system 09 category code that identifies the 1011 format. |
Format 1012 Cat Code (format 1012 category code) |
Enter the system 09 category code that identifies the 1012 format. |
Format 1034 Cat Code (format 1034 category code) |
Enter the system 09 category code that identifies the 1034 format. |
Access the Format Setup Revision form.