We have an Item that is set to FIFO in the Costing Method, but is a 'Special Order' Item (so should always be purchased on a linked Purchase Order from a Sales Order).
The Item Receipt for the Item from the Purchase Order shows the correct GL value on the Receipt going into Stock, but when the Sales Order is Fulfilled, the GL Value shown on the Item Fulfilment is a different value.
Is this because we have FIFO set, and the Fulfilment is taking the GL Stock value from the oldest item 'in stock'? (Technically we should never have any of these items in stock - they should all be purchased on linked SO/POs - but we occasionally have returns etc to deal with so these would show as 'in stock').
How exactly does FIFO work? Does it take the value of the oldest Item in stock? Is it per location (or across the whole subsidiary?).
Logically, I would have hoped that a Special Order item would take the stock value cost from the linked PO receipt (overriding the FIFO setting) - but I'm guessing this isn't the case?
I have started to look at the possibility of changing these items to Serialized or Lot Numberer items - would that overcome this problem?