How to handle this scenario??

Hi Team,

We have a requirement where in say for e.g we are selling goods to our subsidiaries in same operating unit using internal orders and importing them into Order Management.

The selling price which we use is the cost price of the item.

The issue comes when we raise next month sales order this month (As all Item costs are previous ones becasue we have not run MAC which is usually done during Month end )

So we are forced to take 2 months prior cost for the products and make a price list.

Is there any work around for this scenario so as to match the price to the current cost.