How does Sage 300 do FIFO?

[kdien]

We are running Sage 300 2014 (62A) and have been trying to work out how Sage deals with FIFO. Specifically, how does it determine which item (at which cost) to cost first when consumed?
It would help tremendously if someone could help with the logic behind the whole thing, especially how to link an inventory-out transaction back to the original inventory-in one (and subsequently the date the original happened).

 

[Jay Converse]

It uses FIFO "buckets" in the ICCOST table. Also, when the buckets run out because of negative inventory, there's an "offset" amount in ICILOC that the system uses before the first FIFO bucket.

Sage 300 Whisperer

 

[kdien]

So whenever the inventory comes out (shipment, transfer from, receipt return, etc.) the system always checks and uses the offset bucket in ICILOC first? Or are there exceptions depending on the type of IC transactions?

 

[Jay Converse]

I don't know about ALL transactions, I never tested a receipt return, but the others do it. Note that if you want perfect costing, do lot or serial.

Sage 300 Whisperer

 

[kdien]

OK this may be a long shot but is there a way to query an item in inventory (joining different tables) to get how many on hand and what makes up that amount?
For example:
Item ABC, 50 on hand total $5200, made up of:
- 20 at $100 from RCP100
- 20 at $105 from RCP101
- 10 at $110 from RCP102

 

[Jay Converse]

Look at ICILOC and ICCOST. Don't overthink it.

Sage 300 Whisperer