Currency to convert from is required to retrieve exchange rate information

(4) Share

Report

Posted on by DAS-07080332-0

196

hi everyone ,

our finance team is receiving an error message when trying to generate a payment from a vendor payment journal in F&O , currency is CAD offset account is CAD , method of payment is check .

payment have 3 customers , all 3 customers have their currency set to CAD ,

chceked General Ledger -> Setup -> Ledger CAD for accounting currency and reporting currency

theres no CAD to CAD set in Currency exchange rate and we dont to set its a workaround .

maybe 1 thing is noticed is that all our vendors language are set to En-CA but 1 of these vendors in this payment journal is set to en-CA would that cause an issue

thanks in advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (1)

Sort by

CA Neeraj Kumar 5,135 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

There are few questions:

1) What's the business requirement to use vendor payments journal for paying customers?

2) Are you still able to select the invoices to settle?

3) What's the transaction currency for invoices marked for settlement?

Basis these questions, we shall try to give further suggestions.

Regards,

Neeraj Kumar

Was this reply helpful? Yes No
DAS-07080332-0 196 on at

Like (1)

Report
Copy link

Link copied!

hi @CA Neeraj Kumar they said that they are trying to refund a customer payment .. they said they had this error before and was able to fix it by ensuring that customer also had a vendor record set up.

theres no pending invoices to be settled under any vendor in AP

not sure how to check question 3

Was this reply helpful? Yes No
CU12091753-0 4 on at

Like (1)

Report
Copy link

Link copied!

That error usually comes up when the currency field isn’t defined on the transaction you’re trying to settle. Using the vendor payments journal for customer payments is a bit unusual, so the first thing is to clarify why that’s needed. If you can still select the invoices, double-check the transaction currency on those invoices — if it’s missing or mismatched, the system can’t pull the exchange rate. Once we know the exact requirement and currency setup, it’ll be easier to suggest the right fix

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 5,135 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

As you mentioned in question 2, no invoices are selected so question became not applicable..

What is meant by "customer also had a vendor record setup"? Is it using same party as vendor and also as customer?...

Unless system is having transaction currency other than accounting and reporting currency, it doesn't search for currency exchange rate but as you are telling it same currency CAD as transaction currency as same to Accounting and reporting.. It's really looking strange as of now..

Let me check something around it in my trial environment

Regards

NK

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,661 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I tested this in my own test environment and was able to generate a check successfully without getting the same error.

My first thought goes to triangulation currency setup. Can you please check if a triangulation currency has been configured in your environment? If so, make sure the proper conversion exists for CAD to CAD (or via the triangulation currency), otherwise the system will throw an exchange rate error during payment generation.

One more thing I was curious about, I noticed you are using a Customer account inside a Vendor payment journal. Is this being done only to generate checks from the system, or is there another business reason behind it? Normally, vendor payment journals are meant for vendors, and for customers you’d use a customer payment journal (or customer/vendor consolidation if you need cross-settlement).

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
André Arnaud de Cal... 305,150 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you tell us how you created the journal lines? Was this manually, using the customer refund option, or another option?

The triangulation as mentioned below can't be the culprit. Triangulation means that you are calculating the currency amount from currency A to B via currency C using exchange rates between A-C and B-C.

Was this reply helpful? Yes No
Suggested answer

Syed Haris Shah 1,661 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@André Arnaud de Calavon You’re right, triangulation doesn’t seem to be the cause here, as you pointed out.

@DAS-07080332-0 I have tested the same scenario in my test environment multiple time, the check was generated without error. Another angle we could try is to remove the entire journal, recreate it from scratch, and see if the issue persists. If it does, it may be worth checking whether there are any customizations impacting this area. Alternatively, you could also by setting up currency combination (for example, CAD to EUR instead to CAD to CAD) to confirm if the behavior is consistent.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No
Verified answer

DAS-07080332-0 196 on at

Like (1)

Report
Copy link

Link copied!

was not able to find whats the issue nor replicate the issue in another environment so user ended up doing a journal to move the credit to the vendor

Was this reply helpful? Yes No