FrontAccounting forum — No exchange rate

Re: No exchange rate

null@example.com (apmuthu) — Mon, 16 Jun 2014 04:00:19 +0000

The exchange rates table is where you would need to manually put in such data but how would that be useful since you will not be entering any transactions for that period?

Re: No exchange rate

null@example.com (kvvaradha) — Thu, 05 Jun 2014 09:48:04 +0000

can it possible to get Exchange rates automatically for every year data. Even the past years currnecy conversion value too.

Thanks in advance.

Re: No exchange rate

null@example.com (AlanP) — Fri, 12 Nov 2010 14:07:20 +0000

I found a solution. There is a problem with the branch record for the client. When the sales order entry page appears there is no branch available in the drop down list even though a branch was entered into the system. After I added a second branch for the client, then it shows up in the drop down list and the exchange rate errors go away. Then I deleted the first branch record and there were no more problems. Thus, there was some problem with the first branch record that kept it from loading that triggered the exchange rate message.

Re: No exchange rate

null@example.com (thhui) — Fri, 04 Jun 2010 12:50:19 +0000

You can manually add an exchange rate and everything will be OK.
Just once and for all!

Re: No exchange rate

null@example.com (tom) — Thu, 04 Feb 2010 03:32:07 +0000

That fixed it

Thanks!

Re: No exchange rate

null@example.com (joe) — Wed, 03 Feb 2010 15:27:25 +0000

CVS Main updated with /includes/banking.inc

/Joe

Re: No exchange rate

null@example.com (joe) — Wed, 03 Feb 2010 15:21:40 +0000

Yes, tom. We will have to test for null values in currency_code. I will fix this in /includes/banking.inc

/Joe

Re: No exchange rate

null@example.com (tom) — Wed, 03 Feb 2010 11:52:05 +0000

I had that error like that.

I went to: "Banking and General Ledger" -> "Bank Accounts" and had NO selected for the "Dflt" for all accounts

thanks
-------------------------------------
Well I still get it.

"Cannot retrieve exchange rate for currency as of 02/03/2010. Please add exchange rate manually on Exchange Rates page."

From Customer Payment page.

I do have search customer list and the default customer is NULL, maybe the first one should come up by default?

tom

Re: No exchange rate

null@example.com (joe) — Tue, 02 Feb 2010 00:22:39 +0000

Hello everybody that have had this db error message.
I have found the reason for this message "Cannot retrieve exchange rate for currency as of 31/01/2010".
It occurred when doing cash sales (that includes a payment).
There is a missing Cash Bank Account for the Default Sales Pos.
Please create one or check that you have the correct Cash Bank Account for your Sales Pos. Then it works.

This is a very rare error message. It may happen in the foreign COAs if no bank accounts are defined but a sales pos is defined with a non existing cash account. These COAs should have had an initial 'no cash' defined.
I will see if we can get a better error message.

/Joe

Re: No exchange rate

null@example.com (doknet) — Mon, 01 Feb 2010 17:49:13 +0000

Here again the story, which I did, and gave me the error before making the change suggested by MorkvonOrk

I' Get up a new company
Create/Update Companies -> Database Script -> es_ES-iso-220.sql ( Chart of Accounts 2.2 espanish)

In new database, whith prefix 1_

Step to step

Create Fiscal Year create 2010
Delete all other fiscal Year. Previus Company Setup ---> Fiscal Year: Select 2010

Banking and General Ledger -> Currencies
Create currency Pesos $ ARS
Unchek ---> Automatic exchange rate update

Company Setup ---> Home Currency: --> selec Pesos

In Currencies
Delete all other currencys

Company Setup ---> Fiscal Year: Select 2010
Iventary
Create Items
Sales Price ---> Currency: Pesos (this one)

SALES
Add and Manage Customers ---> Create Client
Customer's Currency: Pesos
Sales Areas : Create Argentina

And

Direct Invoice -->
Get error
Cannot retrieve exchange rate for currency as of 01/29/2010. Please add exchange rate manually on Exchange Rates page.
What's wrong?

Transactions -> Exchange Rates

There is only one coin ( Currencie)
And the menssage

The selected currency is the company currency.
The company currency is the base currency so exchange rates cannot be set for it.

I created the new dollar coin but continued to error same I have a single currency

,
Upload the database en http://www.ta21.com.ar/front224.sql.zip

If someone can check if there is any inconsistency
Since already thank you very much

I clone the application site with the same soft base in other server, (linux, php, mysql same) The first application site although he had added another currency (dollar) still did not work The second worked fine.

Sorry for my English

Re: No exchange rate

null@example.com (itronics) — Mon, 01 Feb 2010 17:08:23 +0000

Javascript files are compressed and cached in company/x/js_cache directory, but this should be cleaned and restored on every login. Nice it works now for you, but still we do not know the exact source of problems.
Janusz

Re: No exchange rate

null@example.com (doknet) — Mon, 01 Feb 2010 03:37:49 +0000

Thanks for answering, it works perfect. It is very good this application
I hope to learn to use it and collaborate.

In company I have uncheck search customer list.

As a comment if it serves some purpose. Before changing the code as MorkvonOrk said, I clone the application site with the same soft base (linux, php, mysql) The first application site although he had added another currency (dollar) still did not work The second worked fine. (there is some cache or something in the application?).

I reiterate now everything works fine.

Many thanks

Re: No exchange rate

null@example.com (itronics) — Sun, 31 Jan 2010 23:07:45 +0000

Well, I don't know where the problem can be as I cannot reproduce it. Seems the first displayed customer in customers list has empty currency set in debtors_master? Is this message displayed for every selected customer? Do you have this problem when 'Search customers list' option is on or off?

Janusz

Re: No exchange rate

null@example.com (MorkvonOrk) — Sun, 31 Jan 2010 14:42:29 +0000

OK. I got the message (red message at top of form) when entering direct invoices and when entering bank deposits and then choose "client". Transactions that touch the client-accounts.

Initially I thought the problem would be solved by adding the else-clause after the initial if. But seems my systems generates empty currency-codes. I have only one currency EUR and thus no exchange table...

Re: No exchange rate

null@example.com (itronics) — Sun, 31 Jan 2010 14:10:03 +0000

Passing null as currency shoulbe considered as a bug. Where and when you see the error message?
Janusz