P
Paul Ilacqua
I'm building a bill of materials type application and need to maintain a
seed number entered manually by cycle counters every week as a starting
Inventory balance. Then based on production (as plusses) and consumption (as
minuses), calculate running balances for approx 900 part numbers. The 2nd
days calculations will be based on the reduced or incremented balance not
the seed number.
So my current plan is to have a table as
Part Number Seed Balance
12656 1200 988
34322 1234 3423
This base data will be updated 4 times a day and the current number will
probably change 4 times a day on certain parts. My question is... is this
structure sufficient or should I datetime stamp the update time in another
column? I would like to have this data auditable so as to assure accuracy
and to be able to say on day 5 that this is why the balance is what it is.
Hopefully someone out there has run into this situation of how to deal with
running balances.
I appreciate your help....
Paul
seed number entered manually by cycle counters every week as a starting
Inventory balance. Then based on production (as plusses) and consumption (as
minuses), calculate running balances for approx 900 part numbers. The 2nd
days calculations will be based on the reduced or incremented balance not
the seed number.
So my current plan is to have a table as
Part Number Seed Balance
12656 1200 988
34322 1234 3423
This base data will be updated 4 times a day and the current number will
probably change 4 times a day on certain parts. My question is... is this
structure sufficient or should I datetime stamp the update time in another
column? I would like to have this data auditable so as to assure accuracy
and to be able to say on day 5 that this is why the balance is what it is.
Hopefully someone out there has run into this situation of how to deal with
running balances.
I appreciate your help....
Paul