C
claryn
Hello and TIA for any assistance.
This question is re: an inventory tracking system. I have read through the
excellent information located on Allen Browne's website
http://allenbrowne.com/AppInventory.html and have been greatly helped. I
have applied the general principles using an inventory in table, and an
inventory out table. This principle is also applied for production purposes,
where the additions to inventory reduce raw materials, and the raw materials
are increased by shipments received. Therefore the inventory of raw
materials received vs used needs to be tracked, and also the inventory of
produced goods vs. shipped goods. Hope this makes sense.
With that as a basis, I now need to incorporate the following 2 elements.
1. The inventory consists of compounds (salts to be precise). So it may be
20% of NaCl, 40% MgCl, 20% ZO2 and 20% salt4. So if you produce 10,000 lbs
of product, it will use a weight of these different ingredients equal to the %
* total produced: 2000 NaCl, 4000 MgCl, etc. Hope this makes sense.
The question for this part is, should I store these values in a table based
upon each production batch, or should I generate them in a query where I
multiply production amounts * percentages, which I then compare vs. raw
materials received?
2. Part 1 is complicated by the fact that the composition can change over
time. The % of NaCl can change over time from say 20% to 19%, and it would
skew results if we mulitply past production, done at say 20% originally, by
say 19% if that is what is used today.
This makes me averse to using a query because the values change. On the
other hand, i am averse to stored calculated values in a table. Perhaps
there is a way to use a query if you can use just the specific composition
based on dates, but I have not figured out a way to do this.
If you need more clarification on a specific point, please ask. I may just
not have communicated something clearly.
thank you for your time and assistance,
Nathan
This question is re: an inventory tracking system. I have read through the
excellent information located on Allen Browne's website
http://allenbrowne.com/AppInventory.html and have been greatly helped. I
have applied the general principles using an inventory in table, and an
inventory out table. This principle is also applied for production purposes,
where the additions to inventory reduce raw materials, and the raw materials
are increased by shipments received. Therefore the inventory of raw
materials received vs used needs to be tracked, and also the inventory of
produced goods vs. shipped goods. Hope this makes sense.
With that as a basis, I now need to incorporate the following 2 elements.
1. The inventory consists of compounds (salts to be precise). So it may be
20% of NaCl, 40% MgCl, 20% ZO2 and 20% salt4. So if you produce 10,000 lbs
of product, it will use a weight of these different ingredients equal to the %
* total produced: 2000 NaCl, 4000 MgCl, etc. Hope this makes sense.
The question for this part is, should I store these values in a table based
upon each production batch, or should I generate them in a query where I
multiply production amounts * percentages, which I then compare vs. raw
materials received?
2. Part 1 is complicated by the fact that the composition can change over
time. The % of NaCl can change over time from say 20% to 19%, and it would
skew results if we mulitply past production, done at say 20% originally, by
say 19% if that is what is used today.
This makes me averse to using a query because the values change. On the
other hand, i am averse to stored calculated values in a table. Perhaps
there is a way to use a query if you can use just the specific composition
based on dates, but I have not figured out a way to do this.
If you need more clarification on a specific point, please ask. I may just
not have communicated something clearly.
thank you for your time and assistance,
Nathan