Maybe We are not going about this in the easiest way, but I have an issue with re-pricing stock when we have Close Out sales for old stock.
I use an exported item listing to identify which products should go on clearance, but when it comes to working out sale pricing, the report shows the cost field rather then the average cost of the product. We work in multi currency with products sometimes purchased at a discount which means cost can vary wildly so the average cost is needed to accurately work out how much we can afford to reduce the price of the products
Is there a way I can produce a report which shows the average cost of the stock items? The stock summary report does this, but it uses the purchase description of the product rather than the sale description and we use the report to send to customers after reformatting in Excel & adding the sale price.
Also I'd be interested to know how others produce sales lists and show the old & new price to customers. We put '(Old Price £xxx) in the sales description & adjust the sale price on QB, so it shows on invoices, but again there might be an easier way....