Recent content by Cobbler
-
C
FIFO Value
The sample database listed in the IP has been used as a learning tool for creating my own FIFO database. Further, almost all inventory database samples I have seen are set up as a "buy item from Company A and sell it to Company B" situations (the one referenced is no different) so do not... -
C
FIFO Value
I've been playing with the sample database from the "Sample Databases" forum titled, "FIFO Stock", posted by Khawar. (Sorry, can't post the link) This database does a really good job of keeping track of inventory on a FIFO basis but it does not keep track of the value of the inventory on a... -
C
Theory... Inventory Serialization
In my Inventory Database, I have purchasing functions and issuing function and inventory tracking functions. Because I have a PO Details table which includes lines for each inventory item and its current price on any given PO, I really have a defacto serial number for each part/PO combination...