xTuple.com xTupleU Blog & News Customer Support

FIFO Costing

We are currently developing FIFO costing for xTuple and is now under beta testing. The concept of the project is to simply track fifo costing by recording all inventory add transactions into a fifo table and updating its qty for every issuance, thus tracing the qty still available for costing.

Hi,

Will this include Lot FIFO costing?

Will this be an addon?

Thanks,

Robert Charbonneau

Hi Robert,

No, this will not include Lot Fifo Costing. We are looking at developing a new Costing Method called Specific Identification to include the Lot Costing. This would create specific cost to a lot/serial.

This will be compiled as an addon. We will have it included in our online Postbook host for testing. We wouls also have Import Shipment and Costing included in there.

I can’t wait to see it when it’s done.

Regards,

Robert Charbonneau

You might want to look at this thread:

… and just in case you miss it on the forum thread, there is a spec. with a lengthy and pertinent discussion here:
http://www.xtuple.org/fifo

Hi John,

I might have missed that one. Our spec. here was simple,

  1. Created a table called fifo to record all receiving transactions referenced to invhist and a field for remaining quantity. A trigger from invhist does the routine.
  2. Another trigger from invhist is created for every issuing transaction. This trigger updates fifo for the remaining qty.
  3. A function is also created to get fifo cost, and was incorporated in postinvtransaction.