I have the scenario where I don't want Sales order COGS to be posted before the Product receipt has been posted. Let me explain with an example.
ItemA is Registered on a Purchase order into the warehouse and then put away into a picking location. Product receipt is not posted at this time. The registered quantity is sold on a sales order, which is packing slip updated and invoiced. This all happens on the same day.
ItemA is actual costed, and since AX did not know the cost at the time the sales order was invoiced, the cost on the item record is used. This cost is posted to the G/L: COGS is debited, Stock is credited. At this time, PO Product Receipt (which will debit the Stock account) has not been posted.
I want to avoid this scenario, and I am happy to ensure that ItemA cannot be sold until after the product receipt has been posted. I can use 'Stock status' to make the item unavailable for sale.
I thought about a modification to the product receipt routine, to make it update the Stock status, but I cannot see how AX can know, once the item has been put away, which stock 'belongs' to the product receipt.
I also thought about the 'Financial negative inventory' tick box on the Item Model Group. This would ensure the stock could not be sales invoiced until enough had been purchase invoiced. But there is nothing similar for packing slip / product receipt.
I literally have no ideas. Any suggestions welcome!
