Base currency setup: Canadian Dollars (CAD)
Goods & Services, Parts etc. setup in USD
The SL ver. 2.4 has a bug when generating PO in
different currency.
We are buying and selling goods mostly in USD but our
base currency is CAD; for this reason we prefer to
setup inventory prices in USD.
When I enter a Purchase Order the prices should be
recall from the part setup and stay at the same value
and the currency they were sutup under that perticular
Vendor.
Example: if I setup part number and enter particular
vendor cost at 7.50USD
When trying to generate PO for this vendor in USD the
system should recall price 7.50USD but the part number
flactuate according to exchange factor and it
shouldn't. It should be recall from part setup as 7.50USD.
Though when I enter exchange 2.00 the part number
recalls from setup as 5.05; I don't know how it
calculate it but it is not correct.
The same thing is happening when I generate "Sales
Invoice" it divides the price by the exchange rate but
it shouldn't; the price should be recalled from the
part number + setup group. If I enter group USD and
set price 9.50USD for that part as USD group; it seems
to me when I generate Sales Invoice that price should
be recalled from that group for this customer.
However, when I enter exchange 3.00 it divides the
price 9.50 by 3 and recalls it as 3.17USD.
Is it how it suppose to work or there is a flow in a
design?
To my understanding the way it suppose to work is a follow:
Under part entry there is unit COST and Sell Price, the
system assume that these prices are the currency the
system is in. Below there is room to enter vendor
name, part number, cost and currency.
If the vendor is setup as USD vendor and I set price
for that part number for this vendor in USD that price
should be taken for the PO and NO CONVERSION should
taken place when recalling the price, for example if I
enter price 7.50USD for that vendor and this part
number and recall it on the PO the price should show-up
as 7.50USD (but it doesn't). The conversion take place
only during posting based on the exchange entered.
Same is for Sales Orders if I have a customer set to
USD group and part number has the group USD selected
and sell price in USD entered that price should be
entered into the Sales Order without conversion.
Conversion should take place only if that fields is empty.
#Joseph