Others

Fix Business Central Planning Line Item Cost Using Wrong Currency

Partner Editor Sep 25, 2026 869 views

Question details

The user needs to correct the currency used for item costs in project planning lines so that it matches the project's foreign currency rather than the local currency.

How to Fix Business Central Planning Line Item Cost Using the Wrong Currency

Product: Microsoft Dynamics 365 Business Central
Device & OS: not provided
Scenario: Inserting an item with a foreign project currency (e.g., CAD) into a project planning line where the unit cost fails to update from the local currency (e.g., USD).
Observed behavior: The item unit cost retains the local currency instead of automatically changing to the project's foreign currency, leading to inaccurate mixed-currency metric calculations.

Before you start

Ensure you have the necessary administrative permissions in Business Central to view and modify project, customer, item, and currency setup configurations.

Solution 1Recommended

Verify Project, Item, and Currency Setup

Check the core configuration of your project and items to ensure the foreign currency is properly applied and exchange rates are updated.

In Business Central, item costs default to the local currency based on inventory setups, whereas resources might pull directly from the project's currency settings. Adjusting the item and project configurations can often resolve this discrepancy.

Check Project Currency

Navigate to the specific Project Card and verify that the 'Project Currency Code' field is correctly set to the required foreign currency (e.g., CAD).

Review Item Setup

Open the Item Card for the affected item, go to the 'Costs & Posting' FastTab, and verify its costing method and standard cost configurations.

Inspect Currency Exchange Rates

Search for and open the 'Currencies' page. Select the foreign currency used in your project, click on 'Exchange Rates', and ensure the rates against your local currency are current.

Verify Project, Item, and Currency Setup

Configuration Dependencies: This behavior heavily depends on specific Business Central localization and your company's financial setup. If standard configuration adjustments do not work, localized extensions might be interfering.

Solution 2

Consult the Dynamics Community Forum for Localized Issues

If standard configurations do not fix the issue, seek specialized investigation from Microsoft engineers, as localization rules may apply.

Free Microsoft Office alternative

Manage Your Project Financials Seamlessly with WPS Office

While Dynamics 365 handles your complex ERP tasks, you can easily export, analyze, and format your project cost metrics using WPS Spreadsheet. It offers a powerful, free environment to manipulate mixed-currency data efficiently.

Fully compatible with Microsoft Excel (.xlsx) formats for easy export of Business Central financial data.Built-in currency formatting and formula tools for accurate project cost reporting and conversion.Lightweight and free alternative to Microsoft Office.Familiar user interface makes data analysis and financial metric corrections quick and seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why does a resource change currency but an item does not in Business Central?

Resources and items rely on different underlying costing setups. Resources generally pull pricing and costs directly from the project's default currency settings, while items are often strictly tied to inventory costing methods based in the local currency unless explicitly configured for multiple currencies.

How do mixed currencies affect my project metrics?

If local currency (e.g., USD) and foreign currency (e.g., CAD) unit values are added together without proper conversion on the planning line, your total project costs and profitability metrics will be mathematically inaccurate.

Can I manually change the unit cost currency on a planning line?

Yes. Depending on your user permissions, you can manually edit the Unit Cost field on the planning line to reflect the correct foreign currency value. However, automating this via the correct system setup is recommended to avoid human error.

Office Quick Solutions