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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

there is no currency exchange rate within the filter

(0) ShareShare
ReportReport
Posted on by 20

There is no currency exchange rate within the filter

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    hampton bay Profile Picture
    65 on at

    Hi there

    try out this link, should help

    dynamicsuser.net/.../150034.aspx

    goodluck :)

  • Suggested answer
    TWBlaisdell Profile Picture
    on at

    Hello Albert,

    Thank you for posting on the Forum.  I will provide some general guidance to consider. It is difficult to pinpoint without knowing exactly what process was being completed when the error was generated.

    The most common issue is as follows. In Purchase & Payables Setup and Sales & Receivable Setup,  there is an option for default posting date.  If the default posting date option is set to NO date, then you will get this error.  To work around this error, you will need to enter a Posting Date prior to selecting a Vendor No. in the Header.  You can change the setting in the P&P and S&R Setup to default the posting date to Work Date to prevent getting this error in the future. You cannot have a blank posting date on a header for a transaction that uses currency.  Without a date, NAV doesn't have the necessary information to establish the correct exchange rate to use for the transaction.

    The alternative would be to change code to default to a standard date, such as the work date. In Table 330 (Currency Exchange Table), a change by a certified NAV developer could be made as follows:

    ...

    FindCurrency(Date : Date;CurrencyCode : Code[10];CacheNo : Integer)

    //MBS - begin

    IF Date = 0D THEN

    Date := WORKDATE;

    //MBS - End

    IF (CurrencyCode2[CacheNo] = CurrencyCode) AND (Date2[CacheNo] = Date) THEN

    Rec := CurrencyExchRate2[CacheNo]

    ...

    ...

    FindCurrency2(Date : Date;CurrencyCode : Code[10];Number : Integer)

    //MBS - begin

    IF Date = 0D THEN

    Date := WORKDATE;

    //MBS - end

    CurrencyExchRate3[Number].SETRANGE("Currency Code",CurrencyCode);

    CurrencyExchRate3[Number].SETRANGE("Starting Date",0D,Date);

    ...

    ***********************************************************

    Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability or fitness for a particular purpose. This mail message assumes that you are familiar with the programming language that is being demonstrated and the tools that are used to create and debug procedures.

    Please note that this is a sample process only to provide you with the guidelines and NOT an official fix from Microsoft. I strongly recommend that the sample process suggested be tested both by you and the customer, in a suitable test environment, before adapting it to a production (live) environment. Please note that the sample process being suggested in this communication cannot be considered an official fix or service pack for the reported issue, and hence the partner takes all responsibility for its implementation and ongoing support as well as future upgrades.

    ***********************************************************

    I hope the information helps provide guidance to address your specific issue.

    Best Regards

    Tom

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans