Inventory Management System

Question

Post reply

Inventory Management System

srikanthkamuju

SSC Veteran

Points: 262
More actions
December 12, 2009 at 1:00 am

#218642

Hi All,
Basically i don't have knowledge in Inventory Management System. so any one can help me the flow of inventory management system and data base design for small business, like invoices purchase orders, stores
Thanks in Advance
January 30, 2023 at 9:53 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

My suggestion to you would be to create a requirements document.

Some simple questions which need to be answered before starting the database design would be:

1. What model of a system - first in, first out or last in first out or both flows be implemented with first in, first out for products which might have a "use before date". Or the third option which is neither first in / first out or last in/first out.

2. Is product cost to be tracked in the inventory system, so that the inventory value can be arrived at for fiscal period accounting purposes?

3. Do you have to track which item and number of, are shipped to what outlet (store or customer)?

Additional items added at 12:35

4. Will the inventory system have to calculate and set re-order levels for stocked items? Then when stock on hand is at or below the re-order point generate a report for purchasing.

5, Are stocked items seasonsal items / non-seasonal or a mixture of both. Seasonal would be something like bathing suits, while non-seasonal might be nuts and bolts.

And as you familiarize yourself with the complexity of a good inventory system you will find more questions that must be answered before starting the design of your database.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

You might pick up a copy of this as well: http://www.amazon.com/Server-Relational-Database-Design-Implementation/dp/143020866X/ref=sr_1_1?ie=UTF8&s=books&qid=1260635050&sr=8-1

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Heh... look in Books Online and the AdventureWorks database that comes free with SQL Server. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

briogene SSC-Addicted Points: 498 More actions · Answer 4

You could try going for this book at this link

http://www.vkinfotek.com/

ramalakshmi Valued Member Points: 57 More actions · Answer 5

Hi All,

Inventory Management Flow

Item Master

Item Name , Item Code , Make , Specifications, Opening Bal,

Qty in Hand, Reorder Level , Cost Price , Selling Price

Bill of Material ( if Manufacturing Company)

Note: Not Required if Trading Company

Purchase Order to be Placed to Supplier for Insufficient Qty

Material Inward from Supplier - Stock to be added. Purchase Order Status should be completed.

Material Outward to Customer - Stock to be Reduced.

Invoice (Bill) , DC( Delivery Challan) , GP ( Gate Pass) should be

generated.

Purchase Ledger

Sales Ledger

Daily Stock Ledger with Inward and outward of Material

Analysis Reports

1. Supplier Wise / Manufacturer Wise Sales

2. Item Wise Sales

3. Customer Wise Sales

4. Stock Report etc.,

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 6

This isn't a subject to be taken lightly... inventory management is complex and frequently changing. It's not something that can be learned correctly in a couple of hours especially if you don't have a very, very good background in database design.

My suggestion would be to get some professional help on this one.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Very well put, Jeff. There are multiple ways to handle inventory, and modeling is not something you learn in a day. It takes time, and if you've never done it, you ought to have someone that has experience work with you and review your designs.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 8

I agree with both Jeff and Steve, but I'd like to add that their comments apply to more than just Inventory Management System. Database design is not something that should be taken lightly. A poorly designed database can break a system, especially as the number of records increases.

The book referenced by Steve is a great book. I have the SQL Server 2005 version. It will certainly open your eyes to what you need to consider in your design.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 9

Exactly.

My MIS degree program devoted 2 semesters (courses) to Systems Analysis and Design.

ssaxena.emin Grasshopper Points: 19 More actions · Answer 10

Irrespective of the size of business you have, one thing is for sure effectual inventory control management [/url/]is not a thing to be missed. if you are new to inventory management, you need to first of all become familar with the inventiry management software as this would make the further chores easy...:-)

samjamjohnson Grasshopper Points: 21 More actions · Answer 11

I would have to agree with Jeff, Steve, and Alvin. Trying to design an inventory management system may be difficult and can cost you your time and your effort. If you could, I would recommend using programs that already exist to help you with your small business. One suggestion I would give is try using Mailware. It helps manage orders and has that inventory management [/url]aspect that you are looking for.

vardhanhrishi SSC Enthusiast Points: 100 More actions · Answer 12

Here you are all are right and I would like to suggest you that if you want to learn inventory management system, first go with proper online system and use them for getting ideas because its little hard to understand and to go direct.

Orderhive is a Multi Channel Cloud based Inventory Management Software[/URL] Sign Up for FREE