Colombia Context
The Colombia Localization SuiteApp provides Colombia-specific custom fields to comply with tax and other government requirements in Colombia.
In NetSuite OneWorld accounts, Colombia-specific custom fields are available when one of the following conditions is met (the first condition has the highest priority):
-
The subsidiary country of the record is Colombia.
-
If no subsidiary is selected, the subsidiary country of the NetSuite user is Colombia.
The following table summarizes the DIAN-required custom fields that are integrated with NetSuite records:
When multiple subsidiaries are selected on an entity record, Colombia-specific fields are available if Colombia is the country of at least one of the subsidiaries
Field name |
Description |
Available |
Feature |
---|---|---|---|
Colombia Document Type |
Entity document type according to the ID number. TIN is the most commonly used for Colombian legal entities, and CC (ID card) for Colombian individuals. |
*Entity |
|
Colombia Identification Number |
Public document number that allows the unequivocal identification of the individual or legal entity. |
*Entity/Subsidiary |
|
Colombia Verification Digit |
Verification digit identification number. This type of field applies when TIN is the type of identification. |
*Entity/Subsidiary |
|
First Name |
Name of the entity in case of being an individual. |
*Entity |
|
Second Name |
In case of having a middle name and if the entity is an individual. |
*Entity |
|
Last Name |
Entity’s first last name in case of being an individual |
*Entity |
|
Second Last Name |
In case of having a second last name and if the entity is an individual |
*Entity |
|
Invoicing Email |
The email address where electronic invoicing files should be sent to. |
*Entity |
Electronic invoicing |
Is Consortium |
It appears when the entity is a consortium to identify if the members and participation percentage should be included. |
*Entity |
Electronic invoicing |
DIAN Nature |
Characteristics that allow for the determination of an applicable regime to an organism or entity. |
*Entity |
Magnetic Media Information |
Tax Regime |
Entity’s tax regime |
*Entity |
Electronic invoicing |
Tax Schema |
Entity’s tax obligations |
*Entity |
Electronic invoicing |
DIAN Taxpayer's Obligations |
Entity’s tax obligations. |
*Entity/Subsidiary |
Electronic invoicing |
Third-party Entity |
Personalized segment automatically created when registering a customer, vendor, employee, etc.
Important:
Make sure the Third-party Entity field is enabled for all the transaction forms both at a line and header level. |
Entity |
|
*Entity can be considered a customer, vendor, employee, third party, contact, partner.
The following fields should be considered for the items catalog’s operation:
Field name |
Description |
Belonging to |
Feature |
---|---|---|---|
Brand -Colombia |
Item brand (required for international businesses) |
Item |
Electronic invoicing |
DIAN Electronic Inv. Code |
Product ID classification used for electronic invoicing. |
Item |
Electronic invoicing |
Tariff Heading |
It is a 10-digit numeric code, through which a determined product can be identified anywhere in the world. The Harmonized System (HS) establishes a common numeric and text system that allows for the classification of international products as well. |
Item |
Electronic invoicing |
Fulfillment of the following fields on the Tax Codes is required for assigning withholdings in the Magnetic Media information and electronic invoicing:
Field name |
Description |
Belonging to |
Feature |
---|---|---|---|
Withholding Type |
Should be assigned:
|
Tax code |
|
VAT Tax Code |
The verification box should be checked if it corresponds to the sales tax VAT both for sales and purchase. |
Tax code |
Magnetic Media Information |
VAT Free Day Exempt |
It shows if the tax code applies for VAT exemptions on “VAT exempt day" |
Tax code |
Electronic invoicing |
Withholding Category |
Withholding category associated to the code, may it be withholding at source, VAT, ICA, CREE or withholding category associated to the special rent code. |
Tax code |
|
Concept 1003 |
This is the withholding concept for format 1003 of Magnetic Media Information. |
Tax code |
Magnetic media Information |
To guarantee the electronic invoicing process, the following fields should be fulfilled in the sales transactions:
Field name |
Description |
Belonging to |
Feature |
---|---|---|---|
DIAN Certification Date |
Document certification date |
Content in the transaction |
Electronic invoicing |
DIAN Resolution |
Resolution associated to the transaction to assign the transaction number |
Content in the transaction |
Electronic invoicing |
DIAN Resolution Number |
Number assigned to the transaction according to the selected resolution |
Content in the transaction |
Electronic invoicing |
DIAN INCOTERM |
International Commerce Terms. In an international goods sale contract, it reflects the rules of voluntary agreement of the parties with regard to the goods delivery conditions. |
Content in the transaction |
Electronic invoicing |
DIAN Invoice Type |
Invoice type code for electronic invoicing. |
Content in the transaction |
Electronic invoicing |
Contingency |
It shows if it is a contingency transaction. |
Content in the transaction |
Electronic invoicing |
International Trade |
It indicates if it is an international trade invoice according to the selected invoice type. |
Content in the transaction |
Electronic invoicing |
DIAN Support Document |
It indicates that it is a support document. |
Content in the transaction |
|
Massive process details |
Massive process details associated to the transaction |
Content in the transaction |
Electronic invoicing |
Memo Type |
Purpose of the credit/debit note |
Content in the transaction |
Electronic invoicing |
DIAN Operation Type |
Transaction operation type code for electronic invoicing |
Content in the transaction |
Electronic invoicing |
DIAN Payment Method |
Agreed payment method for cancellation of the invoice amount |
Content in the transaction |
Electronic invoicing |
DIAN Reference Document Type |
Reference document type on contingency invoices |
Content in the transaction |
Electronic invoicing |
DIAN Related Invoices |
It is the transaction associated to the invoice records when the transaction type is Debit Note. |
Content in the transaction |
Electronic invoicing |
DIAN Service Date |
Service date |
Content in the transaction |
Electronic invoicing |
Successfully Invoiced |
It shows if the certification process was successful |
Content in the transaction |
Electronic invoicing |
Technological Provider File Number |
Technological service provider application number |
Content in the transaction |
Electronic invoicing |
DIAN Transaction Type |
Transaction type associated to the invoice records, it could be a debit note or an invoice. |
Content in the transaction |
Electronic invoicing |
QR code |
QR information |
Content in the transaction |
Electronic invoicing |
PDF URL |
PDF URL |
Content in the transaction |
Electronic invoicing |
XML URL |
XML URL |
Content in the transaction |
Electronic invoicing |
Written Value |
Written transaction amount |
Content in the transaction |
Electronic invoicing |
COP DIAN Written Amount |
Written amount resulting from the total transaction amount multiplied by the exchange rate. |
Content in the transaction |
Electronic invoicing |
Tariff Heading |
Tariff code number associated in the item |
Transaction line |
Electronic invoicing |
Print Items? |
Field used to determine if the components in a group of items are printed in the electronic document or not. |
Transaction line |
Electronic invoicing |
Third Party Entity |
Customer associated to the product or service |
Transaction line |
Electronic invoicing |
Reference Price |
Reference price for foreign trade |
Transaction line |
Electronic invoicing |
NetSuite standard fields used in Colombia Localization are listed below, indicating their use and the record they belong to. It is important to take them into account because if you are currently developing any requirement associated to those fields, these developments should be executed before the Localization scripts.
Record |
Record level |
Field |
Type |
Feature |
---|---|---|---|---|
Invoice |
Header |
Customer |
View |
Third-party assignment |
Invoice |
Header |
Date |
View |
Electronic invoicing: document date |
Invoice |
Header |
Due Date |
View |
Electronic invoicing XML mapping |
Invoice |
Header |
Subtotal |
View |
|
Invoice |
Header |
Subsidiary |
View |
Electronic invoicing configuration search |
Invoice |
Header |
Invoicing Address |
View |
Electronic invoicing XML mapping |
Invoice |
Header |
Shipping Address |
View |
Electronic invoicing XML mapping |
Invoice |
Header |
Terms |
View |
Electronic invoicing XML mapping |
Invoice |
Header |
Currency |
View |
Electronic invoicing XML mapping |
Invoice |
Header |
Exchange Rate |
View |
Electronic invoicing XML mapping |
Invoice |
Taxes |
Tax Code |
View |
Electronic invoicing XML mapping |
Invoice |
Taxes |
Tax Basis |
View |
Electronic invoicing XML mapping |
Invoice |
Taxes |
Tax |
View |
Electronic invoicing XML mapping |
Invoice |
Taxes |
Tax Amount |
View |
Electronic invoicing XML mapping |
Invoice |
Item |
Item |
View |
Electronic invoicing XML mapping |
Invoice |
Item |
Description |
View |
Electronic invoicing XML mapping |
Invoice |
Item |
Rate |
View |
Electronic invoicing XML mapping |
Invoice |
Item |
Tax Amount |
View |
Electronic invoicing XML mapping |
Invoice |
Item |
Total Amount |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Customer |
View |
Third-party assignment |
Credit Memo |
Header |
Date |
View |
Electronic invoicing: document date |
Credit Memo |
Header |
End Date |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Subtotal |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Subsidiary |
View |
Electronic invoicing configuration search |
Credit Memo |
Header |
Invoicing Address |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Shipping Address |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Terms |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Currency |
View |
Electronic invoicing XML mapping |
Credit Memo |
Header |
Exchange Rate |
View |
Electronic invoicing XML mapping |
Credit Memo |
Taxes |
Tax Code |
View |
Electronic invoicing XML mapping |
Credit Memo |
Taxes |
Tax Basis |
View |
Electronic invoicing XML mapping |
Credit Memo |
Taxes |
Tax |
View |
Electronic invoicing XML mapping |
Credit Memo |
Taxes |
Tax Amount |
View |
Electronic invoicing XML mapping |
Credit Memo |
Item |
Item |
View |
Electronic invoicing XML mapping |
Credit Memo |
Item |
Description |
View |
Electronic invoicing XML mapping |
Credit Memo |
Item |
Rate |
View |
Electronic invoicing XML mapping |
Credit Memo |
Item |
Amount |
View |
Electronic invoicing XML mapping |
Credit Memo |
Item |
Total Amount |
View |
Electronic invoicing XML mapping |
Credit Memo |
Apply |
Sales Invoice |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Customer |
View |
Third-party assignment |
Cash sale |
Header |
Date |
View |
Electronic invoicing: document date |
Cash sale |
Header |
End Date |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Subtotal |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Total |
View |
|
Cash sale |
Header |
Subsidiary |
View |
Electronic invoicing configuration search |
Cash sale |
Header |
Invoicing Address |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Shipping Address |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Terms |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Currency |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Exchange Rate |
View |
Electronic invoicing XML mapping |
Cash sale |
Taxes |
Tax Code |
View |
Electronic invoicing XML mapping |
Cash sale |
Taxes |
Tax Basis |
View |
Electronic invoicing XML mapping |
Cash sale |
Taxes |
Tax |
View |
Electronic invoicing XML mapping |
Cash sale |
Taxes |
Tax Amount |
View |
Electronic invoicing XML mapping |
Cash sale |
Item |
Item |
View |
Electronic invoicing XML mapping |
Cash sale |
Item |
Description |
View |
Electronic invoicing XML mapping |
Cash sale |
Item |
Rate |
View |
Electronic invoicing XML mapping |
Cash sale |
Item |
Amount |
View |
Electronic invoicing XML mapping |
Cash sale |
Item |
Total Amount |
View |
Electronic invoicing XML mapping |
Cash sale |
Header |
Payment Method |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Customer |
View |
Third-party assignment |
Cash refund |
Header |
Date |
View |
Electronic invoicing: document date |
Cash refund |
Header |
Due Date |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Subtotal |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Total |
View |
|
Cash refund |
Header |
Subsidiary |
View |
Electronic invoicing configuration search |
Cash refund |
Header |
Invoicing Address |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Shipping Address |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Terms |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Currency |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Exchange Rate |
View |
Electronic invoicing XML mapping |
Cash refund |
Taxes |
Tax Code |
View |
Electronic invoicing XML mapping |
Cash refund |
Taxes |
Tax Basis |
View |
Electronic invoicing XML mapping |
Cash refund |
Taxes |
Tax |
View |
Electronic invoicing XML mapping |
Cash refund |
Taxes |
Tax Amount |
View |
Electronic invoicing XML mapping |
Cash refund |
Apply |
Sales Invoice |
View |
Electronic invoicing XML mapping |
Cash refund |
Header |
Payment Method |
View |
Electronic invoicing XML mapping |
Vendor Bill |
Header |
Vendor |
View |
Third-party assignment |
Vendor Bill |
Header |
Date |
View |
Support document generation |
Vendor Bill |
Header |
Due Date |
View |
Support document generation |
Vendor Bill |
Header |
Subtotal |
View |
Support document generation |
Vendor Bill |
Header |
Subtotal |
View |
Support document generation Written amount calculation |
Vendor Bill |
Header |
Subsidiary |
View |
Support document generation |
Vendor Bill |
Header |
Invoicing Address |
View |
Support document generation |
Vendor Bill |
Header |
Terms |
View |
Support document generation |
Vendor Bill |
Header |
Currency |
View |
Support document generation |
Vendor Bill |
Header |
Conversion rate |
View |
Support document generation |
Vendor Bill |
Taxes |
Tax Code |
View |
Support document generation |
Vendor Bill |
Taxes |
Tax Basis |
View |
Support document generation |
Vendor Bill |
Taxes |
Tax |
View |
Support document generation |
Vendor Bill |
Taxes |
Tax Amount |
View |
Support document generation |
Subsidiary |
Header |
Name |
View |
Third-party creation |
Subsidiary |
Tax register |
Name |
View |
Third-party creation |
Customer |
Header |
Company Name |
View |
Third-party creation |
Customer |
Tax register |
Number |
View |
Third-party creation |
Customer |
Header |
Entity ID |
Write |
Entity ID generated with ID number and name |
Vendor |
Header |
Company Name |
View |
Third-party creation |
Vendor |
Tax register |
Number |
View |
Third-party creation |
Vendor |
Header |
Vendor ID |
Write |
Entity ID generated with ID number and name |
Employee |
Header |
Name |
View |
Third-party creation |
Employee |
Header |
Employee ID |
Write |
Entity ID generated with ID number and name |
Partner |
Header |
Company Name |
View |
Third-party creation |
Partner |
Tax register |
Number |
View |
Third-party creation |
Partner |
Header |
Entity ID |
Write |
Entity ID generated with ID number and name |
Contact |
Header |
Company Name |
View |
Third-party creation |
Contact |
Tax register |
Name |
View |
Third-party creation |
Contact |
Header |
Entity ID |
Write |
Entity ID generated with ID number and name |
Other entities |
Header |
Company Name |
View |
Third-party creation |
Other entities |
Tax register |
Number |
View |
Third-party creation |
Other entities |
Header |
Entity ID |
Write |
Entity ID generated with ID number and name |
Transactions |
Header |
Entity |
View |
Third-party assignment |
Subsidiary |
Header |
Name |
View |
Third-party creation |
Subsidiary |
Tax register |
Number |
View |
Third-party creation |