Exchange Rate from NBP

Dynamics 365 Operations

Eliminate manual entry and guarantee financial accuracy with the Exchange Rate from NBP tool. Specifically built for Polish organizations and international firms reporting in PLN, this extension automates the daily retrieval of official currency exchange rates from the National Bank of Poland (Narodowy Bank Polski). By integrating directly with the NBP API, it ensures your system is always updated with the correct, legally required rates, saving your accounting team hours of manual work and protecting your business from costly valuation errors.

Key benefits

Daily automation: Automatically fetch Table A, B, or C rates according to the official NBP publication schedule.
Full regulatory compliance: Align your accounting with Polish tax laws, including the inclusion of a "Publication Date" field for transparent auditing.
Historical data recovery: Easily fill gaps in your exchange rate history caused by holidays, weekends, or temporary communication issues.
Reduced human error: Remove the risk of typos in currency rates that can lead to significant discrepancies in financial statements and tax returns.
Seamless D365 integration: Works natively within the standard Dynamics 365 exchange rate provider framework – no complex setup required.

Examples of usage

Daily mid-rate imports

Configure a batch job to automatically import Table A mid-rates every business day at 12:30 PM, ensuring all afternoon invoices use the latest official data.

Polish tax law compliance

Automatically apply the "prior-day rule" where the system identifies and uses the NBP rate published on the day preceding the invoice date, as required for VAT purposes in Poland.

Closing period backfilling

If a public holiday or technical issue caused a gap in rates, use the historical import feature to select a date range and "fill the holes" before running month-end revaluations.

Exotic currency management

Use the Table B support to pull weekly rates for less liquid currencies, ensuring your diverse international portfolio is always valued against the official central bank benchmark.

How it works?

1. Provider setup

Enable the NBP provider within the standard Currency Exchange Rate Providers menu in Dynamics 365. All communication is secured via HTTPS.

2. Rate table mapping

Choose which NBP tables (A, B, or C) you need and map the official NBP currency codes to your internal system currencies.

3. Scheduling and automation

Define the frequency of the updates. Most organizations set this to run once daily to coincide with the NBP’s mid-day publication.

4. Validation and logging

The tool fetches the XML data, validates the structure, and populates the exchange rate table. A history log allows you to verify every successful import.