Format 1006 file for Colombia configuration

This article explains how to set up and issue a format 1006 file in both XML and Excel output formats.

This report includes value added tax (VAT) generated on sales transactions, VAT recovered on purchase returns, and national consumption tax (NCT).

Prerequisites

Before generating and printing the report, complete the following prerequisites:

• Set the country/region of the legal entity's address to Colombia.
• Enable the country/region-specific Latin American (LATAM) feature for Colombia and the general LATAM feature.
• Download the specific report configurations from the Dataverse configuration repository:

• Learn more in Import Electronic reporting (ER) configurations from Dataverse.
• Configure the Electronic Reporting (ER) parameters. Learn more in Configure the Electronic reporting (ER) framework.

Configure tax applications

1. Go to Organization administration > Setup > LATAM > Tax application and create a new record.
2. In the Tax application Id field, enter 1006.
3. Go to Organization administration > Global address book > Addresses > Address setup > Country/region.
4. Select Colombia and go to LATAM > Tax application.
5. Create a new record.
6. In the Tax application Id field, select 1006.
7. In the Tax application code field, enter the country/region code according to the Colombian normative.
8. Go to Organization Administration> Setup > LATAM > Tax ID type.
9. On the top menu, go to Tax application and create a new record.
10. In the Tax application Id field, select 1006.
11. In the Tax application code field, enter the tax ID code according to the Colombian normative.

For more information, see Tax application for Latin America.

Configure application-specific parameters for format 1006

Lookups and conditions are designed so you can select the combination of document classifications and tax codes used in transactions.

After you meet the prerequisites and configure the tax application codes, follow these steps for both formats:

1. Go to Organization administration > Workspaces > Electronic reporting and select Reporting configuration.
2. On the left, select LTM Tax Report > File format 1006.
3. On the Action Pane, select Configurations > Application specific parameters > Setup.
4. In the Lookups section, select ApplicableCreditNote and follow these steps:
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Yes.
   3. In the Document classification id. field, select a document class used for purchase invoices that contain VAT.
5. In the Lookups section, select TaxType and follow these steps:
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Generated tax.
   3. In the Tax code field, select a value that represents the VAT generated in sales.
   4. Select Add.
   5. In the Lookup result field, select Tax refund.
   6. In the Tax code field, select an option that represents the VAT returns in purchase returns.
6. In the Lookups section, select ApplicableInvoice and follow these steps:
   1. In the Conditions section, select Add.
   2. In the Lookup result field, select Yes.
   3. In the Document classification id. field, select the document class used for purchase invoices.

Issue a format 1006 file for XML and Excel output

1. Go to Tax > Inquiries and reports > LATAM > Tax reporting.
2. In the Format mapping field, select File format 1006 for the XML output or File format 1006 Excel for the Excel output.
3. For the XML output only, enter 1006 in the Tax application ID field.
4. Select a date range.
5. Select OK.