Others

How to Increase Currency Rate Decimal Precision in Business Central

WPS Editor Oct 1, 2026 868 views

Question details

An organization needs to increase the currency exchange-rate precision from six to seven decimal places, but cannot find the corresponding setting.

How to Increase Currency Rate Decimal Precision in Business Central

Product: Dynamics 365 Business Central
Device & OS: not provided
Scenario: Modifying the currency exchange-rate settings to allow seven decimal places for higher financial precision.
Observed behavior: The field required to edit and increase the decimal precision is missing or unavailable when attempting to edit the currency record.

Before you start

Ensure you have the necessary administrator or financial controller permissions in Business Central before attempting to modify system-level currency configurations.

Solution 1Recommended

Contact Dynamics 365 Business Central Support

Because the available currency-rate precision depends heavily on your specific Business Central configuration and version, contacting support is the recommended path when the field is missing.

In some versions or localized builds of Business Central, the maximum decimal precision for exchange rates is strictly capped at six places by default. System-level modifications may be required to extend this to seven places.

Gather Environment Details

Log into Business Central, click the Help icon (?), and navigate to 'Help and Support' to copy your environment and version details.

Access the Admin Center

Navigate to the Dynamics 365 Business Central admin center or your Microsoft Partner portal.

Submit a Support Ticket

Create a new support request detailing the need to increase currency exchange-rate precision to seven decimal places, mentioning that the standard configuration field is unavailable.

Contact Dynamics 365 Business Central Support

Partner Assistance: If your Business Central environment is managed by a Microsoft Partner, you should contact them directly, as they may have custom extensions restricting the decimal precision.

Solution 2

Verify Standard Currency Page Settings

Check if the standard exchange rate field is simply hidden from your current view before escalating to support.

Free Microsoft Office alternative

Handle High-Precision Financial Data with WPS Office

While waiting for Business Central support to enable seven-decimal precision, you can export your financial tables and perform highly precise currency calculations using WPS Spreadsheet, a free and powerful Office alternative.

1. Export Data: Export your currency and financial ledgers from Business Central directly to an Excel file.
2. Open with WPS: Launch WPS Spreadsheet and open the exported .xlsx file.
3. Format Precision: Highlight your exchange rate cells, right-click, select 'Format Cells', and set the Number decimal places to 7.

Fully compatible with Microsoft Excel (.xlsx) files exported from Business Central.Supports high-precision decimal calculations natively in WPS Spreadsheet.Free, lightweight, and features a familiar tabbed interface for seamless workflow transitions.Rich formatting tools to easily display seven or more decimal places in financial reports.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the decimal precision field missing in my Business Central currency record?

The availability of this field often depends on your specific Business Central version, regional localization, or administrator configurations. Certain setups restrict this field to prevent calculation rounding errors.

What is the default currency exchange-rate precision in Business Central?

By default, standard Business Central environments typically handle currency exchange rates with a maximum precision of six decimal places.

Can I force Business Central to display 7 decimal places using personalization?

If the underlying field exists but is hidden by the default page layout, you might be able to add it via the 'Personalize' menu. However, if the field is restricted by the system's database schema or backend configuration, personalization will not make it available.

Office Quick Solutions