AnsweredAssumed Answered

FIFO Inventory System

Question asked by dcassano on Sep 26, 2013
Latest reply on Oct 4, 2013 by dcassano

I was asked to create an Inventory Database, no problem. I used the starter solution provided in FMP12. I modified it to fit our known needs, wrote scripts, and created reports. Now I need to create a FIFO Inventory database that selects the oldest issued purchase order for that item, record it and do a “count down” until that p.o. is at zero units, then select the next, etc. I also need an inventory report that will demonstrate the unit count available, by applicable p.o., total actual cost which will give me the Total Stock Value. I have looked through various web sites and even checked youtube for some direction on how to get this done. Can anyone offer some help or direction on creating a FIFO Inventory System. Thanks Debbie