PDA

View Full Version : Foreign supplier pricing


Carl Lilley
03-30-2003, 08:35 AM
Hi
I have a pricing problem with my suppliers, most of whom are based in Europe, while I am in the UK.
My pricing from my suppliers is in Euro's and throughout last year had the QB rate set at 0.625 or 1.6€ /£.
The Euro is now strengthening, and I am now posting exchange rate losses to the P&L because the actual exchange rate is nearer 1.48€/£.
If I change my QB currency rate however, it then calculates all my item prices incorrectly, because unlike the sales side, you can only have an item cost price in your own native currency. QB then calculates the actual foreign price using the exchange rate set in QB.
Help please.
Carl.

RobJoy
03-30-2003, 11:59 AM
I think you're stuck with manually altering your purchase prices.

james@mp
01-27-2005, 01:51 PM
Are there any updates to this subject, Would be nice if we could enter the euro price of an item into this box eh

RobJoy
01-27-2005, 03:25 PM
Taking a few minutes break from clients' tax & VAT returns . . .

What about using the iif export / Excel import business to export your item list with current cost, using Excel to do a mass change, then importing them back to overwrite the prices. Haven't thought this through in detail, REALLY can't think about it properly until Tuesday, but maybe this will be enough to get you started.

Page
04-22-2007, 02:02 AM
Data Fishing?