I have removed the field "Purchase Price" from all our forms because it is confusing to everyone. We deal in multi-currency so I using "Item Defined Cost" which is calculated from the "Preferred Vendor Cost" and converted into local currency each night using a scheduled mass update.
Recently I have offered to run a staff shop for one of my suppliers and I want to make a special price list based upon cost +10%. However the only way to update customer price levels is with Lists/Mass Update/Update Prices, the problem is that the source cost prices for this function is "Purchase Price". The problem I have is the "Purchase Price" field is filled with wrong prices, they are not my current costs. If I was a betting man I would say that they are the prices from 4 years ago when I removed the "Purchase Price" from my forms.
My questions are:
[LIST=1]
[*]What is the "Preferred Price"used for by the system? Is it likely to have any accounting implications for inventory valuation or P&L?
[*]Can I make the purchase price equal to the "Preferred Vendor Price"
[*]Is it safe to do a "Saved CSV Import" and set the "Preferred Price" to "NULL". the reason I ask this is because it says "If you do not enter a price it will show the most recent purchase price by default". But that is useless the most recent purchase might have been two years ago, I can't base my current selling price based upon the last price I paid for them, I need to base it on my current replacement cost. However the pop-up then goes on to say "If you select a preferred vendor for this item, the price shown in the currency selected on the vendor's record. If no preferred vendor is selected, the price is shown in your base currency."(The first sentence makes no grammatical sense) So this reads to me as If perform a mass update prices and select my customers price level and then select the purchase price +10% it will set the selling price in local currency equal to the vendors price in its currency +10% e.g. supplier is charging £1.00 GBP selling price list will be set to $1.10 USD. Is this really how is works?
[/LIST]
I don't understand why this is so difficult it must be quite common for sellers to want to set selling prices based upon a margin and that margin will be based upon CURRENT prices not historical costs.
Please help me understand what is happening here because my only work around is to do a csv export of costs and then a CSV import of selling prices. I don't want to make this a daily task, I simply want to automate the selling prices to be my current costs plus a margin.