currency problem

Hello Alvin,
I have been looking at the algorithms for fetching the sales prices and I detected an error in the sequence in picking up the correct price.
You may have run into this problem
You say you are running 2.2.2. The release we are running is 2.2.4. I think, however, that you can download this file from the CVS Main trunk

/Joe

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

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

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 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.

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

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

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

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

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

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...

AM