E
esparzaone
I started with the inventory template and configured it to suit my needs so
this gives you an idea of what my database looks like. I used the suggestion
by allen brown and set up a stocktable, Acquired table, and Acquired detail
table. I need to have a guide for coding to be able to have the system to do
fifo by quantity and price. The prices change by vendor and cardboard
prices. So everytime the product is used/wasted/or transferred I need for it
to start from the beginning to take it out of inventory by quantity and
price.
Any ideas would be appreciated.
Zenia
this gives you an idea of what my database looks like. I used the suggestion
by allen brown and set up a stocktable, Acquired table, and Acquired detail
table. I need to have a guide for coding to be able to have the system to do
fifo by quantity and price. The prices change by vendor and cardboard
prices. So everytime the product is used/wasted/or transferred I need for it
to start from the beginning to take it out of inventory by quantity and
price.
Any ideas would be appreciated.
Zenia