This question has been flagged
1 Reply
3110 Views
currencycost_price
Avatar
Dale

Can someone please assist me with this setup if possible.

I am operating in ZAR. I have set my ZAR currency as Base and I have set the currency rate to 1.000000. I will be purchasing from a U.S supplier and so I have set the USD currency to the current rate of 10.4587.

I have created a USD pricelist for purchase and based it on the Cost Price of my products. When I do a purchase order using the USD pricelist I want to see the USD price I pay for the item. I.e. A ZAR product at 1000ZAR should be equal to 95.614USD. However the calculation in the price list MULTIPLIES the currency and not divides. So I am getting 10485.70USD instead.

Must I change the currency or the somehow adjust the formula to arrive at the correct rate or have I got the whole thing wrong?

Thanks

Avatar
Discard
Avatar
Dale
Author Best Answer

So the answer is, when I enter my currency I need to enter it not as at the rate at which I buy it for (in my case R10.05 per USD) but rather as how many USD's are in 1 of my currency (ZAR). Obviously. Silly question, hope this helps someone else in my position

Avatar
Discard