TCMB Exchange Rates

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


TCMB Exchange Rates for Dolibarr
Import the Central Bank of the Republic of Türkiye (TCMB) daily rates into Dolibarr multicurrency
   All TCMB currencies Buying · Selling · Banknote Correct dating Archive backfill Cross rates Free · GPLv3

Overview

TCMB Exchange Rates is a free external module for Dolibarr ERP/CRM that imports the daily indicative exchange rate bulletin of the Central Bank of the Republic of Türkiye (TCMB) into the rate table of the Dolibarr Multicurrency module.

It writes through Dolibarr core classes (no direct SQL on core tables) and does not modify any core file.

Publisher and support

Item Information
Publisher M. Burak Şentürk
Website https://buraksenturk.net
Support https://github.com/mbrksntrk/dolibarr-tcmb-kur/issues
Source code https://github.com/mbrksntrk/dolibarr-tcmb-kur

Module information

Information Detail
Module name TCMB Exchange Rates (tcmbkur)
Module number 194093
Main use Daily TCMB exchange rates in Dolibarr multicurrency
Type External Dolibarr module
Family Financial
Documented version 1.0.0
Dolibarr compatibility Dolibarr 20.0 or higher (developed and tested on 24.0)
PHP compatibility PHP 8.1 or higher, with curl, simplexml
Required modules Multicurrency
Dolibarr core modification No
License GNU GPL v3 or later (with an author attribution term)
Price Free
Available languages Turkish, English

Official links

Main features

  • Any currency of the bulletin (default USD, EUR, GBP); missing currencies are created in Dolibarr.
  • Rate type: forex buying (Turkish tax-law practice), forex selling, banknote buying/selling, or buying/selling average.
  • Correct dating: the bulletin of day D is stored for the next business day (can be disabled); weekends skipped. Works with MULTICURRENCY_USE_RATE_ON_DOCUMENT_DATE.
  • Backfill: past bulletins are fetched from the TCMB archive to fill missing days; holidays fall back to the last published bulletin.
  • Non-TRY main currency: cross rates are computed when the company works in EUR, USD…
  • Both Dolibarr directions written correctly (rate and rate_direct); 100-unit rates (e.g. JPY) normalised per unit.
  • Daily scheduled job, no duplicates for the same date.
  • Setup page with the current bulletin, Import now, Backfill and a run log (llx_tcmbkur_log).
  • MCP tools for the Dolibarr 24 AI module: tcmb_rates, tcmb_sync.

Configuration

From Home → Setup → Modules → TCMB Exchange Rates: currencies, rate type, date behaviour, backfill days. Then in Home → Setup → Scheduled jobs, set TcmbKurDailySync after 16:00 (Türkiye time) and disable the core "update all currency rates" job so the two sources do not overlap.

User permissions

  • Read TCMB rates
  • Update TCMB rates

Installation

  1. Download module_tcmbkur-x.y.z.zip from DoliStore or GitHub Releases.
  2. Home → Setup → Modules → Deploy/install external app/module, or unzip into htdocs/custom/.
  3. Enable the Multicurrency module, then TCMB Exchange Rates.
  4. Open the setup page and use Backfill to load the last 30 days.

Summary

TCMB Exchange Rates keeps Dolibarr multicurrency rates in line with the official Central Bank of Türkiye bulletin — correct rate type, correct date, history backfill and cross rates — using only standard Dolibarr classes.