OdooWiki OCA HUB

Colombia TRM

l10n_co_currency_rate_update folder_open OCA/l10n-colombia open_in_new
Accounting/Localizations License: AGPL-3

This module implements the currency exchange rate query using data provided by the Superintendencia Financiera de Colombia. It extends the currency_rate_update module from the OCA/currency repository and adds the Superfinanciera provider:

> - Superintendencia Financiera de Colombia (ported by [Yan Chirino - IKU Solutions]): > Implements the daily exchange rate query using the API provided by the Superfinanciera. > For more information, visit >

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Adds a new exchange rate provider for Colombia that automatically fetches the daily USD/COP TRM rate from the Superintendencia Financiera and updates Odoo currency rates.

This module extends the currency rate update feature with a new provider called "Superfinanciera Colombia". Once installed, a ready-to-use provider record is created that runs every day and updates the rate for the US Dollar (base.USD).

  • The provider only works when the company's base currency is COP; otherwise Odoo shows an error explaining that Superfinanciera is only suitable for companies with COP as base currency.
  • It supports only the COP and USD currencies.
  • For each day in the requested period, it queries the Superfinanciera web service and stores the resulting rate in Odoo.

Users manage it from the currency rate provider screen (the same place where other automatic rate providers are configured). The provider appears in the Service list as "Superfinanciera Colombia".

The module touches the res.currency.rate.provider model by adding the new service option and the logic to retrieve rates. No new menus or reports are added; it relies on the existing currency rate update screens and scheduled job.

Models and fields (1)
  • res.currency.rate.provider · extends an existing modelservice

Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 1 confirmed, 8 with no information of 9 versions.

Sources · Odoo 18.0

Confirmed on 2026-11-03 in branch 18.0 of OCA/l10n-colombia.

terminal Installation and usage

OCA documentation · Odoo 18.0
  • Install the module from the Apps menu
  • The module will automatically create a scheduled action for daily TRM updates

Automatic Operation

Once installed, the module operates automatically:

  • Daily Updates: The scheduled action runs daily to fetch the latest TRM rate
  • Automatic Rate Creation: USD currency rates are automatically created/updated for all companies
  • Logging: All operations are logged for monitoring and troubleshooting

Manual TRM Update

If you need to manually update the TRM rate:

  • Go to Go to Invoicing > Configuration > Currency Rates Providers
  • Select specific provider "Superfinanciera Colombia"
  • Find the action "Update Rates Now"

Configuration

No additional configuration is required. The module uses the official Superfinanciera web service endpoint and automatically handles:

  • Date formatting
  • SOAP request construction
  • Response parsing
  • Error handling

Monitoring

Check the Odoo logs to monitor TRM updates:

  • Successful updates will show: "TRM vigente en la fecha [date] es de: [rate] COP"
  • Rate creation/updates will be logged with company and rate information
  • Any errors will be logged with full exception details

Troubleshooting

If TRM updates fail:

  • Check internet connectivity
  • Verify Superfinanciera service availability
  • Review Odoo logs for specific error messages
  • Ensure the scheduled action is active and properly configured

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.