The Price Book export creates a super Excel spread-sheet for the manipulation of selling prices. However, most companies need to maintain their margins against a cost price - sometimes the latest, sometimes the average. Since the &last price& paid is in currency (and therefore a foreign currency conversion might be required) the provision of the current average cost price (in base currency) would allow companies to manipulate their prices with the least development effort. For one customer, we did define a price band reserved for cost prices - and populated it using a SQL routine. This is also an alternative approach that achieves the same benefit for the Sage200 users.
Guest
