We have been using average cost automatically since the beginning.  But we had always noticed some difference in the COGS.  So we decided to investigate further and discovered the problem is that when a salesperson makes an SO and sends that quote to the client, sometimes the actual sale doesn't close for a few days.  The cost at this time was $100.  In that time window we might receive new inventory at a different cost (usually higher) and even though the cost of the product is updated in the product sheet to the new cost of $200, when the SO is confirmed and an invoice is generated, the cost the SO had was the old $100 and the invoice has that old cost as well.

Is there a configuration or module that will make sure the cost is always updated to the most recent from the product sheet before generating the invoice once the SO is confirmed?