Colombia Context

The Colombia Localization SuiteApp offers custom fields to help you meet Colombia's tax and government requirements

In NetSuite OneWorld accounts, you'll see Colombia-specific custom fields 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:

If you select multiple subsidiaries on an entity record and at least one is in Colombia, you'll see Colombia-specific fields.

Field name	Description	Available	Feature
Colombia Document Type	This is the entity's document type based on the ID number— TIN for companies and CC (ID Card) for individuals.	*Entity	Magnetic Media information Electronic Invoicing
Colombia Identification Number	A public document number that uniquely identifies the person or company.	*Entity/Subsidiary	Magnetic Media information Electronic Invoicing
Colombia Verification Digit	A verification digit used when the ID type is TIN.	*Entity/Subsidiary	Magnetic Media information Electronic Invoicing
First Name	The entity's first name, if it's an individual.	*Entity	Magnetic Media information Electronic Invoicing
Second Name	The entity's middle name, if they have one and are an individual.	*Entity	Magnetic Media information Electronic Invoicing
Last Name	The entity's first last name, if they're an individual.	*Entity	Magnetic Media information Electronic Invoicing
Second Last Name	The entity's second last name, if they have one and are 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	This appears when the entity is a consortium, so you can include member info and participation percentages.	*Entity	Electronic invoicing
DIAN Nature	Characteristics that help determine the right regime for an organization or entity.	*Entity	Magnetic Media Information
Tax Regime	The entity’s tax regime	*Entity	Electronic invoicing
Tax Schema	The entity’s tax obligations	*Entity	Electronic invoicing
DIAN Taxpayer's Obligations	The entity’s tax obligations.	*Entity/Subsidiary	Electronic invoicing
Third-party Entity	This is a custom segment that's automatically created when you register a customer, vendor, employee, and so on. Important: Make sure you enable the Third-party Entity field on all transaction forms, both at the 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's 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 it's applied to third parties. Self-withholding: you're applying it to your own sales transactions.	Tax code	Magnetic Media Information Electronic Invoicing
VAT Tax Code	Check the box if the tax code is for VAT, whether it's for sales or purchases.	Tax code	Magnetic Media Information
VAT Free Day Exempt	It shows if the tax code applies to VAT exemptions on “VAT exempt day"	Tax code	Electronic invoicing
Withholding Category	The withholding category associated to the code — like withholding at source, VAT, ICA, CREE or a special rent code.	Tax code	Magnetic Media Information Electronic Invoicing
Concept 1003	The withholding concept used for Magnetic Media Information format 1003.	Tax code	Magnetic media Information

To make sure electronic invoicing works, fill out these fields in your sales transactions:

Field name	Description	Belonging to	Feature
DIAN Certification Date	Document certification date	Content in the transaction	Electronic invoicing
DIAN Resolution	The resolution linked to the transaction for assigning its number.	Content in the transaction	Electronic invoicing
DIAN Resolution Number	The number given to the transaction based on the selected resolution.	Content in the transaction	Electronic invoicing
DIAN INCOTERM	International Commerce Terms — these show the agreed rules for delivering goods in international sales.	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 this is a contingency transaction.	Content in the transaction	Electronic invoicing
International Trade	It indicates if the invoice is for international trade, based on the selected invoice type.	Content in the transaction	Electronic invoicing
DIAN Support Document	It indicates that this is a support document.	Content in the transaction	Support document Vendor Bill
Massive process details	Details about any massive process associated to the transaction.	Content in the transaction	Electronic invoicing
Memo Type	The reason for the credit or 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	The payment method agreed on for canceling the invoice amount.	Content in the transaction	Electronic invoicing
DIAN Reference Document Type	The reference document type for contingency invoices.	Content in the transaction	Electronic invoicing
DIAN Related Invoices	It's 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 for the invoice records; 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	The written amount after multiplying the total transaction amount by the exchange rate.	Content in the transaction	Electronic invoicing
Tariff Heading	The item's tariff code number	Transaction line	Electronic invoicing
Print Items?	Field used to determine if the components in a group of items are printed on the electronic document.	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

Here are the NetSuite standard fields used in Colombia Localization, along with their purpose and record. If you're developing anything related to these fields, make sure you do it before running 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 employee 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