web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Settle open transaction
Microsoft Dynamics AX (Archived)

Settle open transaction

(0) ShareShare
ReportReport
Posted on by Community Member

Dear Experts,

I can't get my head around - I`m trying to settle open transaction for general/purchase journal and I keep getting this error "An exchange rate cannot be found for exchange rate type Default between currencies USD and GBP on exchange date ." I don't see anything wrong with the currency exchange rates. It only seems to appear to happen for 1 supplier. 

Any suggestions where to check?

Kind Regards

V

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Settle open transaction

    Hi,

    Which exchange rate type is being used Ledger?

    Based upon it, you should verify whether there exists a valid rate in the default type.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Settle open transaction

    Hi V,

    What is the date that is specified when you try to settle that transation?

    Does an exchange rate between the USD and GBP exist for this or an earlier date?

    Ludwig

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Settle open transaction

    Hi Ludwig,

    Transaction date was on 18/10/2016 and yes, there is an exchange rate for USD to GBP from date 10/10/2016 to 09/12/2016.

    I do believe that supplier parameters(Purchasing Demographics - currency) were modified after the transaction date to USD from GBP, as it fixed the error message changing it back to GBP. I`m not quite sure yet if that was the issue

    Rahul - we are using default exchange rate type

    Regards

    V

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Settle open transaction

    Hi V,

    Have you checked "Solution 3742350Error message: "An exchange rate cannot be found for exchange rate type Closing between currencies CAD and USD on exchange rate date" when settling invoices" on LCS?

    Probably try to follow the steps described there to see if this fixed your issue:

    1.      General ledger > Setup > Currencies > Currency exchange rate

    2.     In the currency exchange rate (form), select Exchange rate type: Closing

    3.     Select the CAD to USD

    4.     In the From date (field) click on the calendar and Click the Clear date (button)

    5.     In the Exchange rate lists, sort by Start date lowest to highest  

    6.     Right-click on the Slider bar and select the Top (option)

    7.     Note the First start date is 11/16/2010

    8.     Click the Add (button) and enter the following

        a.     Start date: Leave this blank

        b.     Exchange rate: I used 1.00 but any rate will suffice provided it’s not 0.00.          

    9.     Click the close (button) to close the Currency exchange rate (form)

    10.   Accounts payable > Common > Vendors > All vendors

    11.    In the All vendors list page (form), select vendor 502089

    12.   Action pane > Invoice (tab) > Settle (section) > Settle open transactions (button)

    13.   System opens Cancel settlement (dialog)

    14.   Settle open transactions (form) now opens without throwing the error message

    Hope this helps,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans