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 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