|
 |
Newsgroups: comp.databases
From: "Donald J Kinney" <kin...@ndak.net>
Date: 2000/02/14
Subject: Re: Inventory DB
Mark L. Breen <m...@solution-providers.ie> wrote in message > Hello All, calculate the actual > My questions is regarding the structure of a database that > I have two types of transactions, one the increases the > inventory level, I can sum all the increases and subtract desirable to store the from that all the > decreases. This would give me my inventory balance. > Obviously, that query could get quite slow, so it is > actual balances in an inventory table. This would give calculated field, but even you an immediate > record of what is in stock for a particular part. I am considering > including an Adjustments table. This will basically keep track of the old > balance, the adjustment and the new balance. > My question is how do you guys handle this kind of stuff? > the banks use this tactic. Keep one database with records for the different parts with > You advice will be much appreciated. > Thanks in advance, > Best Regards > Mark Breen two fields for each period of time one for Items received and one for Items sold. Also have a Total on Hand field and of course the part number fields. Using months as your time period you will have a total of 26 fields. This will also give you a way to see how fast the turn around on the parts is. You will see when you received the parts and the time it took to sale the parts before reordering. Update the total field either daily or when you receive sale the part as part of your program. Donald You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||