How to Maintain Inventory Transactions in Access

K

Karan

Dear all,

I want to maintain the Inventory Transactions of our company stocks. We have
around 20 customers and couple of suppliers. I have taken Northwind
database has a sample and done the tables viz, Category, Products (we have
around 80 Products), Employees, Orders, Order Details, Suppliers & Shippers.
Now i want to maintain the Stock in-flow and out-flow. for example:

1) We purchase the Items from Suppliers > I want to add the purchased qty.
to my stock to each item (80 Models)
2) We supply to our customers > I want to deduct stock. and have the closing
stock or Stock left in hand.

I know you'll can help me in this regard. Thanks in Advance.

Karan.
 
K

Karan

Mr. Browne,

I thank you for the valuable help. I did understood the idea but, i
couldn't execute it. Is there any sample file to refer and proceed. I am a
beginner to MS Access and couldn't able to do what is there in that example.

Once again thanks for help and tips.

Karan.
 
A

Allen Browne

There is not a sample database, because in our experience there is no
one-size-fits-all solution. Some cases involve multiple sites, perishable
goods that have to be handled on a FIFO basis, individual serial numbers
that need to be tracked, variations in valuation (where the purchase prices
vary wildly), and many other factors.

So, there will be a learning curve if you choose to do this yourself:
1. getting the data structure correct (absolutely crucial, though not
necessarily difficult);
2. learning queries (crucial, not too difficult);
3. learning VBA (big curve if you have never programmed before).
 
K

Karan

Dear All,

Please, help me in do the below said inventory database.

i need it very badly, and couldn't able to do it myself. I think with all
your help i might get what i want !!

Please, give me suggestions and tips on how to go about it.

As i said i have taken the Northwind sample database as an example and build
the tables.

Mainly, stocks which comes from purchaser and going out to the buyers.

Waiting for valuable tips !

Karan.
 
K

Karan

Dear all / Mr. Allen Browne,

As i said earlier that i want to maintain our inventory, i want to take the
Quantity On Hand. I have gone through your website and done the tables
accordingly. The Acquisition, Acquisition Detail and Stock Take Tables and
the remaining tables exist as mentioned(Northwind Traders Database)

1) Acquisition Table contains > Field1: AcqID(AutoNumber) Field2:
AcqDate(Date/Time) and Field3: AcqNote (Memo)

2) Acquisition Detail Table Contains > Field1: AcqDetailID(AutoNumber)
Field2: AcqID(Related to Acquisition Table) Field3: ProductID (Related to
Product Table) Field4: Quantity(Number) Field5: UnitPrice(Currenty)

3) Stock Take Table Contains > Field1: StockTakeID(Autonumber) Field2:
StockTakeDate(Date/Time) Field3: ProductID (Related to Product Table)
Field4: Quantity(Number)

I have created the reletionships also according to your sample Function.
Now i want to put the Function onHand. I don't know how to do that and also
do i need to build any query before i can calculate stock on hand. please
help me in this regard. I am under tremendrous pressure from all corners.
I want to do this, which will help me in a great deal. Any tips will be
highly valued.

Thanks and waiting for replies !!!

Thanks in advance

Karan
 
K

Karan

Mr. Browne,

Firstly, i am sorry for CC to your mail ID forgive me. I want the below
said to be done. i don't have a clue about it. please help me !

As i said earlier that i want to maintain our inventory, i want to take the
Quantity On Hand. I have gone through your website and done the tables
accordingly. The Acquisition, Acquisition Detail and Stock Take Tables and
the remaining tables exist as mentioned(like the Northwind Traders Database)

1) Acquisition Table contains > Field1: AcqID(AutoNumber) Field2:
AcqDate(Date/Time) and Field3: AcqNote (Memo)

2) Acquisition Detail Table Contains > Field1: AcqDetailID(AutoNumber)
Field2: AcqID(Related to Acquisition Table) Field3: ProductID (Related to
Product Table) Field4: Quantity(Number) Field5: UnitPrice(Currenty)

3) Stock Take Table Contains > Field1: StockTakeID(Autonumber) Field2:
StockTakeDate(Date/Time) Field3: ProductID (Related to Product Table)
Field4: Quantity(Number)

You have given the code for Quantity On Hand in your Website. Please help
me in how to put in to a Event Procedure.

I have created the reletionships also according to your sample Function.
Now i want to put the Function onHand. I don't know how to do that and also
do i need to build any query before i can calculate stock on hand. please
help me in this regard. I am under tremendrous pressure from all corners.
I want to do this, which will help me in a great deal. Any tips will be
highly valued.

Thanks and waiting for your valueble reply !!

Thanks in advance

Karan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top