Skip to Content
This question has been flagged
#nocurrencyrate
3 Replies
10819 Views
Avatar
Scott Fong

I think I've tried everything...

I have the above error message when I try to "deliver" a specific line item on a sales order. Curiously, the other line items on the same sales order were OK to "deliver".

I created the price list in USD I made sure my company default currency is USD I went to the accounting menu and set my currency rate as 1 for USD.

Any advice?

Avatar
Discard
Avatar
Alexis Wuestenberghs (awu)
Best Answer

Hello,

You need to make sure you have a currency rate that is older or on the first day of the invoice accounting period. You can test it by setting a currency rate in a past year.


Best, 

Avatar
Discard
Avatar
Chidozie Kingsley Okonkwo
Best Answer

I have encountered this error. The solution is to make sure you have at least two currency rate entries for the base currency and the counterpart currency. i.e. Lets say you want to convert from Dollar to Naira. You will create two currency rate entries for Dollar and two currency rate entries for Naira. The currency rates must be set with a date that is, ON or before the order date. That is just the solution. I had to debug it on my development environment to figure out why the system raises that constraint error, despite having entered a single currency rate. Thanks. Please vote my answer if it solves your problem.

Note: Path to Currency Configuration is: Accounting->Miscellaneous->Currencies

 

Avatar
Discard
Avatar
patrick
Best Answer

The error indicates that somehow there is a date on which the currency is not defined.

Under Accounting -> Miscellaneous -> Currencies, and you select your currency, you can specify the start date. Probably the date of your order is before the starting date , or after the ending date of your currency.

What is the default currency of your company? By default it is EURO, if I remember correctly.

If you want to use only US$, go to US$ and tick the box behind 'base'.

Avatar
Discard