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:

Note:

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	Magnetic Media information Electronic Invoicing
Colombia Identification Number	Public document number that allows the unequivocal identification of the individual or legal entity.	*Entity/Subsidiary	Magnetic Media information Electronic Invoicing
Colombia Verification Digit	Verification digit identification number. This type of field applies when TIN is the type of identification.	*Entity/Subsidiary	Magnetic Media information Electronic Invoicing
First Name	Name of the entity in case of being an individual.	*Entity	Magnetic Media information Electronic Invoicing
Second Name	In case of having a middle name and if the entity is an individual.	*Entity	Magnetic Media information Electronic Invoicing
Last Name	Entity’s first last name in case of being an individual	*Entity	Magnetic Media information Electronic Invoicing
Second Last Name	In case of having a second last name and if the entity is an individual	*Entity	Magnetic Media information Electronic Invoicing
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	Magnetic Media information Financial Reports

*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: Withholding: If the withholding is practiced to third parties Self-withholding: If it’s a self-withholding practiced during sales transactions.	Tax code	Magnetic Media Information Electronic Invoicing
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	Magnetic Media Information Electronic Invoicing
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	Support document Vendor Bill
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
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	Electronic invoicing XML mapping Written amount calculation
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	Electronic invoicing XML mapping Written amount calculation
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	Electronic invoicing XML mapping Written amount calculation
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

General Notices