Hi,

I have a bit of a confusion with the MTO products, and value taken into account when the sales order is completed.

For the MTO(make to order) product, though the item is same, each production order differs to another in terms of consuming raw items, hence resulting in the overall manufacturing cost.

Say, we have a MTO item called "Test Item"

and have completed the manufacturing order and have 2 of them on hand as below:

Please consider above stock for example. Since I've set the inventory as FIFO, the cost in product/ product variant seems to be auto updated with 50 (i think that's because it's supposed to leave the inventory next as per FIFO).

 But since in real life it's not always the case the order that get's confirmed last will have the last delivery.

So, now if i complete the S00031 transfers (WH/OUT) with the correct lot number (000002), order first, it picks the 50 as value as opposed to 7000.

So, in such case, is there a way to pick the value based on the lot number, or it's associated manufacturing order, instead of the FIFO cost? Or changing the Costing method for such MTO product would be a good idea?

Or any method that considers the cost based on the lot number would also work, i suppose.

Any suggestion/ solutions would be greatly appreciated.

Thanks