First in First out

[Guest]

I need help in figuring out how to implement FIFO. I order a product and it is put in inventory with a PO and price. Then I may order some more in a few months before I use up all the old, it is added in with its own PO and price. Now when I take out of inventory I want to use up all the items from the first order then switch to the next one.

Any help would be nic
Thank
Ji

 

[Jason Morin]

You need a date stamp at the time the product into
inventory. Maybe use an "expected arrival" date on the PO.
But how does this relate to Excel? Questions like this
should be directed to:

http://www.allexperts.com/getExpert.asp?Category=2466

HTH
Jason
Atlanta, GA

-----Original Message-----
I need help in figuring out how to implement FIFO. I

order a product and it is put in inventory with a PO and
price. Then I may order some more in a few months before I
use up all the old, it is added in with its own PO and
price. Now when I take out of inventory I want to use up
all the items from the first order then switch to the next
one.