We are having a constant issue with the cost pricing of our products which is also affecting our profit analysis on quotations.
We import all our product pricing with a cost price and sales price. This should always be the default cost pricing used.
When we raise Purchase Orders to our suppliers, sometimes there is a variation on the cost price if they have a promotion or similar so we overwrite the cost in the purchase order.
Our problem then comes when we order the same product again, the price Sage pulls through to a new purchase order is that from the previous order, rather than what should be the default cost price. This price is also used in the next quotation we sent to a client, and although sales price remains unaffected, the cost price is and so we can't rely on the profit analysis.