[Sharon]

We have a sales order converted into an invoice. The cost price that comes up in the two is not the same and hence the margin % goes from 61.5% to -131.2%. Why does this happen?

[COBS Tech Support]

Current cost price is always determined (recalculated) at time of invoicing. If any activity has effected cost price between placing the order and making the sale, the sale cost price will be different if you have told the system to use last cost or average cost or FIFO cost. I.e., deliveries of more stock, sales of stock (in some cases), adjustments to cost prices on the stock record, and so on. The cost price on the sales order is not copied into the sales price on the invoice produced. This would be a mistake because for some businesses there may be a time gap between when an order is placed and when stock is shipped to the customer and costing could have since changed significantly.