Adding Inventory Management

[Guest]

I posted this question afew days ago, but for some reason I never got a
single response...perhaps it was too vague.

I have a database that I use to create project details such as Bill of
sales, bill of materials and project descriptions. I would like to add the
ability to control inventory. I have looked at the MS Templates and have not
been able to grasp the concepts used.
I have a Materials Table and I am guessing I need to add a table that holds
the purchases and sales to the inventory. What I can't get is the way the
Units On Hand in the template works. At the end of the day, I would like to
be able to add a material from stock and see the remainder on hand like the
"Tea Lady" does.
Camro69 helped me to get a great form that lets me select a material from a
list and then add it to a Bill of Materials (see post 10/23/2005, Move field
entries from form to form using global variables).
I would not have gotten this far without the help of theis great diecussion
site...please don't forsake me know.
Jack

 

[Guest]

Hi Jack,

Have you seen Allen Browne's article that covers Inventory?

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I posted this question afew days ago, but for some reason I never got a
single response...perhaps it was too vague.

I have a database that I use to create project details such as Bill of
sales, bill of materials and project descriptions. I would like to add the
ability to control inventory. I have looked at the MS Templates and have not
been able to grasp the concepts used.

I have a Materials Table and I am guessing I need to add a table that holds
the purchases and sales to the inventory. What I can't get is the way the
Units On Hand in the template works. At the end of the day, I would like to
be able to add a material from stock and see the remainder on hand like the
"Tea Lady" does.

Camaro69 helped me to get a great form that lets me select a material from a
list and then add it to a Bill of Materials (see post 10/23/2005, Move field
entries from form to form using global variables). I would not have gotten
this far without the help of theis great discussion site...please don't
forsake me now.

Jack

 

[Arvin Meyer [MVP]]

I like to use 2 fields. One for Purchases and one for Sales. Inventory is
always the difference between them minus spoilage or theft.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

After a long delay, I am back to sort this out. I am not sure your answer
landed it's mark with me. Do you use them in the Materials Table or in a
seperate table for inventory adjustments. I read the article Mr Wickerath
suggested. It basically required me to add an acquisitions table and then a
query that worked out the math between items used in the tblMaterialDetails
and items added in the tblAcquisitionDetails. I believe DSum was the main
element in that method (which I am not too familiar with). Are you sugesting
something different?
Jack