FrontAccounting forum — currency problem

Re: currency problem

null@example.com (itronics) — Sat, 17 Jul 2010 20:00:50 +0000

Alvin, please do not feed the SEO troll.
Janusz

Re: currency problem

null@example.com (alvin) — Sat, 17 Jul 2010 17:24:07 +0000

Yes my own formula...

We buy at multiple location, in multiple currency. The same with sell. So in this case you buy in foreign currency, and manually calculate the sell price in base currency, so when you try to sell or print a price list for that item in a currency other then its buy currency, you get the correct price...

Re: currency problem

null@example.com (alvin) — Sat, 20 Mar 2010 01:25:18 +0000

OK, I have a problem, but it is not a bug. I will make a post over at FA Modifications...

Re: currency problem

null@example.com (itronics) — Fri, 19 Mar 2010 07:20:43 +0000

I don't see the problem here. If I need to store all sell prices in base currency, in order to make the system work right. What is the problem with the system doing it for me?

I'm stuck. From your first post I understood the problem is that system does not calculate price automatically 'when you try make a sale...'. I explained why it doesn't and what are rationale behind this.

Now you are talking about storing prices in base currency/pricelist automatically. Ok, this is another preposition. So, when and how it should be calculated to satisfy you?

Janusz

Re: currency problem

null@example.com (alvin) — Thu, 18 Mar 2010 16:52:19 +0000

If you were to automate this price problem - Alvin

This is what we want to avoid by clear defaults: automatization of problems . - Janusz

I don't see the problem here. If I need to store all sell prices in base currency, in order to make the system work right. What is the problem with the system doing it for me?

Also what is the Base for auto price calculations: used for in Company Setup? - Alvin

This is price list selected as base for price calculations, when there is no explicit price set for some items. If you have 'No base price list' here you have all automatic calculations for prices off. Maybe this is your problem? Set it to most complete/often used pricelist. - Janusz

Just wondering, wiki not updated yet, however this is not the problem, it is set to retail price list...

Re: currency problem

null@example.com (itronics) — Wed, 17 Mar 2010 21:56:22 +0000

alvin wrote:

If you were to automate this price problem [....]

This is what we want to avoid by clear defaults: automatization of problems .

Also what is the Base for auto price calculations: used for in Company Setup?

This is price list selected as base for price calculations, when there is no explicit price set for some items. If you have 'No base price list' here you have all automatic calculations for prices off. Maybe this is your problem? Set it to most complete/often used pricelist.

If you have some base price list set the price selection order described in my previous post is used.

Janusz

Re: currency problem

null@example.com (alvin) — Wed, 17 Mar 2010 16:17:01 +0000

OK, So why have a price list where you can enter a price in a foreign currency? If you need a price in foreign currency, you just print it, or get it from a sale... All done from base currency.

If you were to automate this price problem, You would enter the sale price in foreign currency, the system would do the calculation and store the price in base currency.

Also what is the Base for auto price calculations: used for in Company Setup?

Thanks Janusz, for your help...

Re: currency problem

null@example.com (itronics) — Tue, 16 Mar 2010 08:20:39 +0000

No, Alvin. I have just explained why it cannot be done automatically: To ensure that no random price is selected we have to base on clear defaults. So only three prices are considered as apprioprate:
. Price in customer currency in current pricelist.
. Price in current pricelist in default currency (USD in your case)
. The price in default pricelist and default currency

Such selected price _is_ recalculated to customer currency, so you have not to do it manually.
We cannot use any available price just because we can have 10 different non-default prices for various currencies and there is no way to select the right one as base for final price calculation. We have to avoid any ambiguity here just to avoid mistakes in use.

Janusz

Re: currency problem

null@example.com (alvin) — Mon, 15 Mar 2010 23:11:51 +0000

It is like this, you have a price list, (retail) it is what you use to sell everything to most customers. When I buy something to resale, sometimes I buy it in foreign currency so I just add the sell price in that currency. Which is fine when I sell in that currency. But as soon as I try to sell that item in the other foreign currency I have the problem.

But I guess what I need to be doing is calculating the exchange rate by hand to what the equal would be in base currency and putting that in the price list.

Right? Or maybe sometime in the future, a feature could be implemented to do this automatically.

Re: currency problem

null@example.com (itronics) — Sun, 14 Mar 2010 21:16:11 +0000

Maybe I do not understand what is your problem, or you do not understand how the price calculatons work. Let's return to the original report:

I have base currency USD, and currencies HNL, GTQ, I have a mix of all 3 currencies for sale prices, When I try to make a sale in GTQ, the items that are priced in HNL, return a 0.00, and when I try to make a sale in HNL, the items priced in GTQ return a price of 0.00

I guess you have only one pricelist and this pricelist is set as default in company settings, right? In this case if you have no price defined in USD (your home currency) there will be no price guessed for GTQ nor HNL. Just because you have no price for this item defined in default currency (USD) , and you have no price defined in your default pricelist (the only you have). If this is the case, this is correct.

Price list do the same thing...print in GTQ, price in HNL show 0.00

When printing in GTQ, you have prices in GTQ, and no price in HNL should be displayed (zero or non zero). In any report all prices should be the same as selected in sales order form.
Janusz

Re: currency problem

null@example.com (alvin) — Sun, 14 Mar 2010 13:51:37 +0000

I do not understand, the target currency chances, depending on where the sale is made. A location has items purchased in all 3 currencies. There are exchange rates between all currencies, not just the base currency.

Re: currency problem

null@example.com (itronics) — Sun, 14 Mar 2010 11:54:45 +0000

Just set the price in the target currency for the target price list. Not all can be guessed, nothing can be calculated when there is no data to be calculated from.
Janusz

Re: currency problem

null@example.com (alvin) — Sun, 14 Mar 2010 00:50:04 +0000

I see, so what do I do when I print a price list and it has products listed in retail price that some are not in base currency or selected currency? Or I try to make a Sale where one of the Items is not in the base currency or sale currency?

Re: currency problem

null@example.com (itronics) — Sat, 13 Mar 2010 20:56:37 +0000

Sales price is guessed from base price list as it is set in company setup, and from home currency, so if you have home currency USD in case of lack of price in GTQ it will NOT be guessed from HNL price. The price is guessed only using default currency and/or default price list. This is how the algorithm works - we can guess price only form defaults, not from any random price in database.

Janusz

Re: currency problem

null@example.com (alvin) — Sat, 13 Mar 2010 18:32:03 +0000

Hello Joe,

Thought I would bring this up again...

Running v2.2.6 this problem is still there. Shall I add it to the tracker?