Small and medium business | Business Central, N...

Answered

Currency exchange rate error in Requisition worksheet

(3) Share

Report

Posted on by STP

1,016

Hi all,

I'm testing 'Requisition worksheet' in UAE, it should be straight forward, however, I've got an error message about the currency. The local currency is USD, the currency in both project and customer are Blank (USD). So it's a bit weird to me to have this error. Hence, when I setup an exchange rate for AED and then run the requisition worksheet again. It does work, but the amount is in AED, not USD. Have you experienced this? or have any thought?

P.S. There is no other transactions with these items.

Thanks!

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Teagen Boll 3,334 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

There will be data somewhere that is related to demand in your system using an FX rate of AED. I would check all vendors and customers. I would then check Sales Lines (Sales Orders and Invoices) and Projects.

For now the best fix is to just add a generic rate for AED and run the requisition worksheet.

Do you have an additional reporting currency setup in your General Ledger Setup page. That could also be triggering it.

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No
Suggested answer

RockwithNav 9,225 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Somewhere system might be picking, For now you can define the same in the currencies -> exchange rate and this error will be gone. Once you will post there wont be any impact on forex side if it's not getting used so nothing to worry.

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 18,299 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello,

This usually means the Requisition Worksheet is picking AED from the purchasing side, not from the project/customer side. In Business Central, if LCY is USD, then blank currency = USD, so the error proves that AED is coming from somewhere else, most likely the vendor, item vendor, purchase price/price list, SKU/replenishment setup, or another planning-related setup used to create the purchase suggestion. Adding an AED exchange rate only allows BC to continue, but it does not fix the root cause; it just makes the suggested purchase line calculate in AED. I would personalize/show the Currency Code field on the requisition worksheet line, then trace the suggested vendor and check the vendor card and related purchase price/item vendor setup. If the purchase should be in USD, keep the vendor currency blank, because blank means LCY/USD.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

STP 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Oussama.

It is found that there is a default vendor in the item card, and the default currency has been setup as AED in the vendor card.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Currency exchange rate error in Requisition worksheet

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Currency exchange rate error in Requisition worksheet

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates