Skip to Content
Menu
This question has been flagged
13 Replies
7821 Views

Hi All, seems my currencies lost entirely for no reasons, any one can help to sort out what happened for that?

Before I have four currencies there, but right now I lost them totally.

image description

Hope my question is clear for you, thank you so much!


After I try to upgrade base module, I found I can not do it because:

image description


I tried to create a currency, because the original currencies are all gone, but I can not and with below warning, implies old currencies should still there but have no idea where they are:

image description

Avatar
Discard

Hi, Brenda.li, have you already solved this problem? I came across the same problem with you these days. If you have solved this or had some suggestions, could you reply me? many thanks!

Best Answer

The errormessage is about openERP being unable to find the currency rate for the given date or period.

The solution is to make sure there is a currency rate for the given date/period. This might be accomplished by upgrading your installation of openERP (upgrade base as Keyur mentioned), or you can manually create a currency rate for a period (Accounting -> Miscellaneous -> Currencies; click on the currency you want to change; Click on the button 'Edit'; click on 'Add new Item' at the bottom;type a correct date and the rate you want to use; click in the button Save)

Avatar
Discard
Author

Hi Patrick, I can not upgrade base module which Keyur mentioned because my database has some purchase order....records. And I can not manually create a currency (with currency rate) because the original ones are all gone, it is blank there, and i can not create with the warning(screenshot showed in my question) as well.

It worked for me. After disable the "base" checkbox I could add custom period

Best Answer

I ran into this problem recently.  I haven't been able to fix the "no currency rate associated..." error but found a workaround I can live with.  Very simple, to daily change the currency rates just press OK to the error window and, although there are no currencies shown, you can just search for the currencies you need in the search bar and then they will appear in the list view.

Avatar
Discard
Best Answer

Try to upgrade your base module. By that way you may have currencies back.

Avatar
Discard
Author

Yes? You means upgrade the version to the latest one(I am using version 7.0-20130327-002325 right now)? Because I tried to create one currency(assume it was deleted itself) and system said you can not do that because unique code reason. so i think it implies the currencies should still there in system but somewhere I do not know.

Here I've got the same problem when I create new currency record. Current rate is already set to 0 and readonly field so we can't create our currency that way. The problem is solved by discarding the changes or reloading the page. Even if there are any issues then try to upgrade base module in settings->Modules->Installed Modules->Base.

Author

Thanks but I can not update the base module. the screen shot of warning notes is as above in my question.

Best Answer

Hi,

Currency is already there in your database. You have defined currencies and used them but currency rate is not there so it is not able to calculate amount.

You can fix this by updating value into database also.

Email : info@acespritech.com
Skype : acespritech
Blog : acespritechblog.wordpress.com

Avatar
Discard

Hi Dharmesh. I think there are some restrictions in version 7.0, currency record can't be created directly from web client. The Current Rate field in currency form view is set to '0' by default and it is readonly. So is it the proper way to change directly in database every time we get error like this?

There is no restriction in OE 7 and rate fields be always editable otherwise it will never possible to update new rate for currencies.

Author

Hi Dharmesh, I did set up currency rate before, and the amount can be calculated by the rate i set. The situation now is I lost my old currency records(with their own currency rates) entirely, and now i can not upgrade base module and create currency.

Related Posts Replies Views Activity
1
Apr 24
1594
2
Jan 24
1703
2
Nov 23
2541
1
Mar 24
1853
4
Sep 23
16645