Re: How would you...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Fred,
I appreciate any input. What started out as a simple project has blossomed.
I think I'm going to call in a local company to provide a little one-on-one
training, to assist me. I've been reading the books, and I've looked at
Allen Brown's site, etc. and I know from all I've read that structing my
tables correctly at first is so critical.

As I've mentioned, I haven't worked on the actual programming side for a few
years, so my programmer's brain is a little rusty...

(Also, since this project started there are more aspects that they want me
to capture...)

Thank you again - it is so great to have this resource of knowledge! I will
be posting more in the future (I'm sure!)




"Fred" wrote:

I don't want to interfere with the main excahnge, but it looks like it might
have died out, and just consider my comments to be a sidebar.

At the 30,000' view level, you have to decide how it is that you are going
to "know" inventory. You are implying that this will be done from
transactions. Jumping to this is probably a much bigger job than you
realize, and you will need to create operating procedures that capture data
for anything that will add or deduct from inventory, and then get your people
to follow them. You might want to start small on this.

Then, if you decide to "know" inventory based on transactions, you need to
decide between:

1. Record all transactions (plus enter initial inventory as a transaction)
and then have your computator :-) just sume them up when the current
inventory value is needed. I think that Allen Brown's site has an example
that does it using this method.

2. Have a number in a field which represent current inventory, and then
have transactions modify that number. (once and only once for each
transaction)

Finally, your initial answer to aside, having "site" in a product table
doesn't look right unless there is a one-to-one relationship between those
two, which I doubt. But I can't suggest an alternative without really
knowoing what's in that table.
.

Relevant Pages

  • RE: Inventory
    ... You can do an update query to adjust the quantity value in your inventory ... bill should probably include the ability to have a qty for each bill item. ... link to the Bill of Materials table to release those items from inventory. ... > I need it to subtract from my Inventory Transactions table per the example ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Normalised Stock Table
    ... Next you have to define your mission in detail with respect to transaction ... tracking and inventory tracking of individualized/serialized items and items ... cause all transactions and tracking to occur at the individualized ...
    (microsoft.public.access.tablesdbdesign)
  • Re: maintaining on-hand balances in an inventory
    ... You can drop the trigger idea and drop the inventory level from the item ... I believe keeping the quantity on hand in the item master is normal ... let's assume that your transactions table is as follows ...
    (microsoft.public.sqlserver.programming)
  • Re: Inventory-Am I on wrong path?
    ... Josh, if you can calculate the inventory, there is absolutely no need to ... and NOT store the dependent value. ... You probably do need a way to handle transactions a bit more than you have. ... This is for receiving only. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Rqst for Inventory Database Best Practices
    ... Since you did not tell us anything that makes this inventory unique, ... calculate the stock based on the sum of all transactions. ... New transactions are once again summed against the most recent audit ...
    (comp.databases.ms-sqlserver)