G
gknapp
Hi Myrna,
The workbook contains 4 sheets, Inventory (a snapshot of Quantit
On-Hand for each type of product), Receiving Log (to place incomin
product into inventory sequentially by receipt date, assign a
inventory code, track on-hand for each receipt), Usage Log (to dra
from inventory by inventory code), Lists (to maintain a list o
vendors, product types).
Age of inventory is by the sequence of receipt in the Receiving Log.
set up a table to the right of the actual log with a column for eac
product type - each row corresponding to a record in the log. Th
table generates a '1' for the first occurrence of the product type i
the log with qty on-hand > 0; blank otherwise. At most a single '1' i
each column of the table. In the 2 columns to the right of this table
the 1st column identifies the product type corresponding to this '1'
the 2nd column provides the inventory code for this record. This form
an array of mostly blank cells with at most 5 pairs of entries - one fo
each of the 5 product types. I have been unable to use this table wit
LOOKUP, MATCH with/without exact matching. This table cannot b
sorted. I have been unable to use R1C1 information to provide a
indirect reference to this inventory code from the Usage Log.
believe it should be able to be done - I just haven't quite figured i
out yet.
From the Usage Log, the user can select the product type from
pull-down list. He should then be presented with the inventory code o
the product to be used next - and also the quantity on-hand from tha
code. Only then can I claim to have a FIFO sytem for my inventory.
Instructing and then expecting people to grab the oldest material fro
the shelf is not a system.
Thanks for any help.
Gil Knap
The workbook contains 4 sheets, Inventory (a snapshot of Quantit
On-Hand for each type of product), Receiving Log (to place incomin
product into inventory sequentially by receipt date, assign a
inventory code, track on-hand for each receipt), Usage Log (to dra
from inventory by inventory code), Lists (to maintain a list o
vendors, product types).
Age of inventory is by the sequence of receipt in the Receiving Log.
set up a table to the right of the actual log with a column for eac
product type - each row corresponding to a record in the log. Th
table generates a '1' for the first occurrence of the product type i
the log with qty on-hand > 0; blank otherwise. At most a single '1' i
each column of the table. In the 2 columns to the right of this table
the 1st column identifies the product type corresponding to this '1'
the 2nd column provides the inventory code for this record. This form
an array of mostly blank cells with at most 5 pairs of entries - one fo
each of the 5 product types. I have been unable to use this table wit
LOOKUP, MATCH with/without exact matching. This table cannot b
sorted. I have been unable to use R1C1 information to provide a
indirect reference to this inventory code from the Usage Log.
believe it should be able to be done - I just haven't quite figured i
out yet.
From the Usage Log, the user can select the product type from
pull-down list. He should then be presented with the inventory code o
the product to be used next - and also the quantity on-hand from tha
code. Only then can I claim to have a FIFO sytem for my inventory.
Instructing and then expecting people to grab the oldest material fro
the shelf is not a system.
Thanks for any help.
Gil Knap