哥伦比亚

网络研讨会

您可以在下面找到带有本地化的一般说明以及如何配置它的视频。

介绍

哥伦比亚的电子开票可从 otoo 12 获得, 需要下一个模块:

  1. l10n_co: All the basic data to manage the accounting module, contains the default setup for: chart of accounts, taxes, retentions, identification document types

  2. l10n_co_edi:此模块包括与Carvajal集成所需的所有额外字段,并根据DIAN法律要求生成电子开票。

工作流

../../../_images/colombia01.png

配置

Install the Colombian localization modules

install 模块,请转到 Apps,删除 Apps 过滤器并搜索 “Colombia”。然后单击前两个模块的“安装”。

../../../_images/colombia02.png

配置 Carvajal Web 服务的凭据

一旦安装了模块,为了能够与Carvajal Web Service连接,有必要配置用户和凭据,此信息将由Carvajal提供。

进入 会计->配置->设置 并查找 哥伦比亚电子开票 章节.

../../../_images/colombia03.png

使用测试模式,可以与Carvajal测试环境连接。这允许用户测试完整的工作流程以及与CEN金融门户的集成,可在此处访问:

CTS (Carvajal T&S)

https://cenflab.cen.biz/site/

CSC (Carvajal Servicios de Comunicación)

https://web-stage.facturacarvajal.com/

CSC 是新数据库的默认值。

一旦Odoo和Carvajal完全配置并准备好投入生产,就可以禁用测试环境。

Configure your report data

As part of the configurable information that is sent in the XML, you can define the data for the fiscal section and the bank information in the PDF.

进入 会计->配置->设置 并查找 哥伦比亚电子开票 章节.

../../../_images/colombia04.png

Configure data required in the XML

往来账

ID

As part of the Colombian Localization, the document types defined by the DIAN are now available on the Partner form. Colombian partners have to have their identification number and document type set:

../../../_images/colombia05.png

小技巧

When the document type is RUT the identification number needs to be configured in Odoo including the verification digit, Odoo will split this number when the data to the third party vendor is sent.

Fiscal structure (RUT)

The partner’s responsibility codes (section 53 in the RUT document) are included as part of the electronic invoice module given that is part of the information required by the DIAN .

These fields can be found in Partner ‣ Sales & Purchase Tab ‣ Fiscal Information

../../../_images/colombia06.png

Additionally two booleans fields were added in order to specify the fiscal regimen of the partner.

税率

If your sales transactions include products with taxes, it’s important to consider that an extra field Value Type needs to be configured per tax. This option is located in the Advanced Options tab.

../../../_images/colombia07.png

Retention tax types (ICA, IVA, Fuente) are also included in the options to configure your taxes. This configuration is used in order to correctly display taxes in the invoice PDF.

../../../_images/colombia08.png

日记账

一旦 DIAN 为电子开票解析分配了官方序列和前缀,就需要在 Odoo 中更新与您的开票文档相关的销售日记帐。 可以使用 developer mode: :menuselection:`Accounting –> Settings –> Configuration Setting –> Journals`</developer-mode> 访问该序列。

../../../_images/colombia09.png

Once that the sequence is opened, the Prefix and Next Number fields should be configured and synchronized with the CEN Financiero.

../../../_images/colombia10.png

用户

The default template that is used by Odoo on the invoice PDF includes the job position of the salesperson, so these fields should be configured:

../../../_images/colombia11.png

用法和测试

结算单

When all your master data and credentials has been configured, it’s possible to start testing the electronic invoice workflow.

开票创建

The functional workflow that takes place before an invoice validation doesn’t change. The main changes that are introduced with the electronic invoice are the next fields:

../../../_images/colombia12.png

There are three types of documents:

  • Factura Electronica: This is the regular type of document and its applicable for Invoices, Credit Notes and Debit Notes.

  • Factura de Importación: This should be selected for importation transactions.

  • Factura de contingencia: This is an exceptional type that is used as a manual backup in case that the company is not able to use the ERP and it’s necessary to generate the invoice manually, when this invoice is added to the ERP, this invoice type should be selected.

Invoice validation

After the invoice is validated an XML file is created and sent automatically to Carvajal, this file is displayed in the chatter.

../../../_images/colombia13.png

An extra field is now displayed in “Other Info” tab with the name of the XML file. Additionally there is a second extra field that is displayed with the Electronic Invoice status, with the initial value “In progress”:

../../../_images/colombia14.png

Common errors

During the XML validation the most common errors are usually related to missing master data. In such cases, error messages are shown in the chatter after updating the electronic invoice status.

../../../_images/colombia17.png

After the master data is corrected, it’s possible to reprocess the XML with the new data and send the updated version, using the following button:

../../../_images/colombia18.png ../../../_images/colombia19.png

Additional use cases

The process for credit and debit notes is exactly the same as the invoice, the functional workflow remains the same as well.