Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How does Sage 300 do FIFO?

Status
Not open for further replies.

kdien

Technical User
Jun 1, 2017
13
CA
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).
 
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
 
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?
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top