Microsoft Dynamics GP (Archived)

Multicurrency Exchange Rate Table Setup

(0) Share

Report

Posted on by Community Member

Hi,

I used Exchange rate table to convert USD to CAD daily.

But Expiration Date for Rate everyday is given just one day after.

In SQL server or Rates table I can change for old entries but for new entries I need to know how we setup.

I want to make expiration day fixed for whole financial year.

For Example: Now we are in June 2017, I want all the exchange rates expiration to be on 31st March 2018.

Can anyone please help me?

Thanks,

Kumar.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Tim Wappat 5,713 on at

Like (1)

Report
Copy link

Link copied!

From your question I think you asking if you may set an exchange rate to cover a period of one year.

By setting the start and end dates and clicking the [insert] button, you may do this as shown:

after inserting we can see the date is now covering until next year...

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Thank you Tim.

I know about this but in this case:

Everyday it adds the rate automatically and I need to change the expiration date for the rate every day.

So I want to make the expiration date default to Mar 31st for every new rate added everyday.

Thank you.

Kumar.

Was this reply helpful? Yes No
Suggested answer

iruser2 2,048 on at

Like (2)

Report
Copy link

Link copied!

Hi

You will not be able to make GP automatically select Mar 31.

You can choose rate frequency = none which will turn off the expiration date, as shown here

or

you can choose Annually. That will make the rates last a year.

or

you can choose miscellaneous which lets you set the number of days before expiration, but that would need to go down by 1 every day until you got to March 31.

I would be tempted to go with annual, and still enter a rate every day.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you iruser2. I will try this.

Thanks,

Kumar.

Was this reply helpful? Yes No
Tim Wappat 5,713 on at

Like (0)

Report
Copy link

Link copied!

Ah - I see you are using the frequency, iruser2 has is covered above.

Tim.

Was this reply helpful? Yes No