Transaction Table For Inventory Control

[Manning]

After a lot of searching, printing and highlighting I want to double check that I have the right idea.

I have a simple inventory control database. From reading the forum, it seems the best approach is to drop the detail lines table of the purchase order (incoming) and the detail lines table of the sale invoices (outgoing) and make one table for all transactions.

The Transactions Table would also keep records of inventory adjustments from inventory counts, etc. Each transaction would be given a type so I know in which direction the stock count moves in (adding or subtracting) when I sum the totals for each item.

Otherwise, I need union queries to ensure all tables are considered in my calculations.

My database is simple (thankfully). Let me know that I am on the right track I like the solution but like any new student, a little reassurance is appreciated.

 

[L'apprentis]

Sounds pretty right to me unless I missed something. I am still on the learning curve myself but I have done a transaction Sample Database that you can find in the sample section of the forum if you haven't found it yet (The sample is far from being amazing but it could probably give you a good idea of where to head)

 

[Manning]

Funny enough, I had saved it a couple of weeks ago, but now that I look at it again, it makes a lot more sense.

Thanks for putting up your sample.

 

[JennySmith]

I would like help on the same issue

I am working on developing a printer supply inventory and after doing research on this site I think it should have a transaction table. Is the sample database that L'apprentis mentioned still available? I don't see it listed in the sample section of the forum.

Or if anyone can refer me to a topic/previous post that would be beneficial to me I would greatly appreciate it. I've been searching on this forum for a couple hours and I haven't found one yet that really explains how to do it.

Thank you for your help