|
| 1 | +======== |
| 2 | +Colombia |
| 3 | +======== |
| 4 | + |
| 5 | +Introduction |
| 6 | +~~~~~~~~~~~~ |
| 7 | + |
| 8 | +Electronic invoicing for Colombia is available from Odoo 12 and |
| 9 | +requires the next modules: |
| 10 | + |
| 11 | +#. **l11n_co**: All the basic data to manage the accounting module, |
| 12 | + contains the default setup for: chart of accounts, taxes, |
| 13 | + retentions, identification document types |
| 14 | +#. **l10n_co_edi**: This module includes all the extra fields that are |
| 15 | + required for the Integration with Carvajal T&S and generate the |
| 16 | + electronic invoice, based on the DIAN legal requirements. |
| 17 | + |
| 18 | +Workflow |
| 19 | +~~~~~~~~ |
| 20 | + |
| 21 | +.. image:: media/colombia01.png |
| 22 | + :align: center |
| 23 | + |
| 24 | +Configuration |
| 25 | +~~~~~~~~~~~~~ |
| 26 | + |
| 27 | +1. Install the Colombian localization modules |
| 28 | +--------------------------------------------- |
| 29 | + |
| 30 | +For this, go in Apps and search for Colombia. Then click Install for |
| 31 | +the first two modules. |
| 32 | + |
| 33 | +.. image:: media/colombia02.png |
| 34 | + :align: center |
| 35 | + |
| 36 | +2. Configure credentials for Carvajal T&S web service |
| 37 | +----------------------------------------------------- |
| 38 | + |
| 39 | +Once that the modules are installed, in order to be able to connect |
| 40 | +with Carvajal T&S Web Service, it's necessary to configure the user |
| 41 | +and credentials, this information will be provided by Carvajal T&S. |
| 42 | + |
| 43 | +Go to :menuselection:`Accounting --> Configuration --> Settings` and |
| 44 | +look for the *Colombian Electronic Invoice* section. |
| 45 | + |
| 46 | +.. image:: media/colombia03.png |
| 47 | + :align: center |
| 48 | + |
| 49 | +Using the Testing mode it is possible to connect with a Carvajal T&S |
| 50 | +testing environment. This allows users to test the complete workflow |
| 51 | +and integration with the CEN Financiero portal, which is accessible |
| 52 | +here: https://cenfinancierolab.cen.biz |
| 53 | + |
| 54 | +Once that Odoo and Carvajal T&S is fully configured and ready for |
| 55 | +production the testing environment can be disabled. |
| 56 | + |
| 57 | +3. Configure your report data |
| 58 | +----------------------------- |
| 59 | + |
| 60 | +As part of the configurable information that is sent in the XML, you |
| 61 | +can define the data for the fiscal section and the bank information in |
| 62 | +the PDF. |
| 63 | + |
| 64 | +Go to :menuselection:`Accounting --> Configuration --> Settings` and |
| 65 | +look for the *Colombian Electronic Invoice* section. |
| 66 | + |
| 67 | +.. image:: media/colombia04.png |
| 68 | + :align: center |
| 69 | + |
| 70 | +4. Configure data required in the XML |
| 71 | +------------------------------------- |
| 72 | + |
| 73 | +4.1 Partner |
| 74 | ++++++++++++ |
| 75 | + |
| 76 | +4.1.1 Identification |
| 77 | +^^^^^^^^^^^^^^^^^^^^ |
| 78 | + |
| 79 | +As part of the Colombian Localization, the document types defined by |
| 80 | +the DIAN are now available on the Partner form. Colombian partners |
| 81 | +have to have their identification number and document type set: |
| 82 | + |
| 83 | +.. image:: media/colombia05.png |
| 84 | + :align: center |
| 85 | + |
| 86 | +.. tip:: When the document type is RUT the identification number needs |
| 87 | + to be configured in Odoo including the verification digit, Odoo |
| 88 | + will split this number when the data to the third party vendor is |
| 89 | + sent. |
| 90 | + |
| 91 | +4.1.2 Fiscal structure (RUT) |
| 92 | +^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| 93 | + |
| 94 | +The partner's responsibility codes (section 53 in the RUT document) |
| 95 | +are included as part of the electronic invoice module given that is |
| 96 | +part of the information required by the DIAN . |
| 97 | + |
| 98 | +These fields can be found in :menuselection:`Partner --> Sales & |
| 99 | +Purchase Tab --> Fiscal Information` |
| 100 | + |
| 101 | +.. image:: media/colombia06.png |
| 102 | + :align: center |
| 103 | + |
| 104 | +Additionally two booleans fields were added in order to specify the |
| 105 | +fiscal regimen of the partner. |
| 106 | + |
| 107 | +4.2 Taxes |
| 108 | ++++++++++ |
| 109 | + |
| 110 | +If your sales transactions include products with taxes, it's important |
| 111 | +to consider that an extra field *Value Type* needs to be configured |
| 112 | +per tax. This option is located in the Advanced Options tab. |
| 113 | + |
| 114 | +.. image:: media/colombia07.png |
| 115 | + :align: center |
| 116 | + |
| 117 | +Retention tax types (ICA, IVA, Fuente) are also included in the |
| 118 | +options to configure your taxes. This configuration is used in order |
| 119 | +to correctly display taxes in the invoice PDF. |
| 120 | + |
| 121 | +.. image:: media/colombia08.png |
| 122 | + :align: center |
| 123 | + |
| 124 | +4.3 Journals |
| 125 | +++++++++++++ |
| 126 | + |
| 127 | +Once the DIAN has assigned the official sequence and prefix for the |
| 128 | +electronic invoice resolution, the Sales journals related to your |
| 129 | +invoice documents need to be updated in Odoo. The sequence can be |
| 130 | +accessed using developer mode: :menuselection:`Accounting --> Settings |
| 131 | +--> Configuration Setting --> Journals`. |
| 132 | + |
| 133 | +.. image:: media/colombia09.png |
| 134 | + :align: center |
| 135 | + |
| 136 | +Once that the sequence is opened, the Prefix and Next Number fields |
| 137 | +should be configured and synchronized with the CEN Financiero. |
| 138 | + |
| 139 | +.. image:: media/colombia10.png |
| 140 | + :align: center |
| 141 | + |
| 142 | +4.4 Users |
| 143 | ++++++++++ |
| 144 | + |
| 145 | +The default template that is used by Odoo on the invoice PDF includes |
| 146 | +the job position of the salesperson, so these fields should be |
| 147 | +configured: |
| 148 | + |
| 149 | +.. image:: media/colombia11.png |
| 150 | + :align: center |
| 151 | + |
| 152 | +Usage and testing |
| 153 | +~~~~~~~~~~~~~~~~~ |
| 154 | + |
| 155 | +1. Invoice |
| 156 | +---------- |
| 157 | + |
| 158 | +When all your master data and credentials has been configured, it's |
| 159 | +possible to start testing the electronic invoice workflow. |
| 160 | + |
| 161 | +1.1 Invoice creation |
| 162 | +++++++++++++++++++++ |
| 163 | + |
| 164 | +The functional workflow that takes place before an invoice validation |
| 165 | +doesn't change. The main changes that are introduced with the |
| 166 | +electronic invoice are the next fields: |
| 167 | + |
| 168 | +.. image:: media/colombia12.png |
| 169 | + :align: center |
| 170 | + |
| 171 | +There are three types of documents: |
| 172 | + |
| 173 | +- **Factura Electronica**: This is the regular type of document and |
| 174 | + its applicable for Invoices, Credit Notes and Debit Notes. |
| 175 | +- **Factura de Importación**: This should be selected for importation |
| 176 | + transactions. |
| 177 | +- **Factura de contingencia**: This is an exceptional type that is |
| 178 | + used as a manual backup in case that the company is not able to use |
| 179 | + the ERP and it's necessary to generate the invoice manually, when |
| 180 | + this invoice is added to the ERP, this invoice type should be |
| 181 | + selected. |
| 182 | + |
| 183 | +1.2 Invoice validation |
| 184 | +++++++++++++++++++++++ |
| 185 | + |
| 186 | +After the invoice is validated an XML file is created and sent |
| 187 | +automatically to Carvajal, this file is displayed in the chatter. |
| 188 | + |
| 189 | +.. image:: media/colombia13.png |
| 190 | + :align: center |
| 191 | + |
| 192 | +An extra field is now displayed in "Other Info" tab with the name of |
| 193 | +the XML file. Additionally there is a second extra field that is |
| 194 | +displayed with the Electronic Invoice status, with the initial value |
| 195 | +"In progress": |
| 196 | + |
| 197 | +.. image:: media/colombia14.png |
| 198 | + :align: center |
| 199 | + |
| 200 | +1.3 Reception of legal XML and PDF |
| 201 | +++++++++++++++++++++++++++++++++++ |
| 202 | + |
| 203 | +The electronic invoice vendor receives the XML file and proceeds to |
| 204 | +validate the structure and the information in it, if everything is |
| 205 | +correct the invoice status changes to "Validated" after using the |
| 206 | +"Check Carvajal Status" button in the Action dropdown. They then |
| 207 | +proceed to generate a Legal XML which includes a digital signature and |
| 208 | +a unique code (CUFE), a PDF invoice that includes a QR code and the |
| 209 | +CUFE is also generated. |
| 210 | + |
| 211 | +After this: |
| 212 | + |
| 213 | +- A ZIP containing the legal XML and the PDF is downloaded and |
| 214 | + displayed in the invoice chatter: |
| 215 | + |
| 216 | +.. image:: media/colombia15.png |
| 217 | + :align: center |
| 218 | + |
| 219 | +.. image:: media/colombia16.png |
| 220 | + :align: center |
| 221 | + |
| 222 | +- The Electronic Invoice status changes to "Accepted" |
| 223 | + |
| 224 | +1.4 Common errors |
| 225 | ++++++++++++++++++ |
| 226 | + |
| 227 | +During the XML validation the most common errors are usually related |
| 228 | +to missing master data. In such cases, error messages are shown in the |
| 229 | +chatter after updating the electronic invoice status. |
| 230 | + |
| 231 | +.. image:: media/colombia17.png |
| 232 | + :align: center |
| 233 | + |
| 234 | +After the master data is corrected, it's possible to reprocess the XML |
| 235 | +with the new data and send the updated version, using the following |
| 236 | +button: |
| 237 | + |
| 238 | +.. image:: media/colombia18.png |
| 239 | + :align: center |
| 240 | + |
| 241 | +.. image:: media/colombia19.png |
| 242 | + :align: center |
F438
| 243 | + |
| 244 | +2. Additional use cases |
| 245 | +----------------------- |
| 246 | + |
| 247 | +The process for credit and debit notes is exactly the same as the |
| 248 | +invoice, the functional workflow remains the same as well. |
0 commit comments