How to put this in inventory system

[Jay]

I have a new project in VB.NET and I am having problem figuring out how to
make an inventory on this. I am not new to inventory system but my client
has a hardware which is kinda different from a department store.

The scenario is this. A box may contain 3 different parts.

Example:

Piston Assembly Mitsubishi D1700 has three different parts like:

Tp Piston Mitsubishi D1700 50.00
Tp Piston Pin Mitsubishi D1700 30.00
Tp Piston Pin Searclip Mitsubishi D1700 10.00

Now how can I make an inventory on every box and every parts?

Example if I have 3 boxes on hand.

I can sell a box or I can also sell each part. If somebody buy only Tp
Piston Mitsubishi D1700 my inventory should be

2 box = Piston Assembly Mitsubishi D1700

Qty Description
2 Tp Piston Mitsubishi D1700
3 Tp Piston Pin Mitsubishi D1700
3 Tp Piston Pin Searclip Mitsubishi D1700

Note: prices are just an example.

Unlike in department store where for example I have 1 box of Uni Ballpen and
it contains 20 pieces I can easily track down it's inventory because it has
a similar part (i.e. all are ballpen and it has the same price).

Any thoughts is highly appreciated.

 

[Cor Ligthert[MVP]]

Jay,

It is always the same, customers don't know how to do their inventory, and
you should clear the black box.

Think on a plane, they are going by flight, not by passengers.

The problem is that this can only be done as every passenger has a passport,
I assume they parts you are doing are not, so in my idea an impossible
problem to solve.

When I learned working with computers I learned it from a guy who said, as
you in smaller parts not can do it by hand, you cannot do it with a
computer. The computer helps you only if it is more.

Cor

 

[Gregory A. Beamer]

I have a new project in VB.NET and I am having problem figuring out how to
make an inventory on this. I am not new to inventory system but my client
has a hardware which is kinda different from a department store.

The scenario is this. A box may contain 3 different parts.

So what does that tell you about the data? Think it through.

You need a table that represents box and one that represents part. If we
have to pull from only one location, we can create a box with only one part.
If we can pull from both, then we pull from both and don't need to set this
higher level concept.

I agree with Cor on the idea of a flight and passengers. They are just two
tables. Then you might have additional tables to describe things like
passport, etc.

--
Peace and Grace,
Greg

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

************************************************
| Think outside the box! |
************************************************

 

[James Hahn]

The problem is very common in automative parts, but occurs in many other
places as well. You need a system that supports simple jobs - ie parts and
no labor/overhead. It's often called a kitting system, but the principal is
the same. A kit is an item of inventory that has some special features.

If your stock 3 boxes then you have:
0 Tp Piston Mitsubishi D1700 Kit*
3 Tp Piston Mitsubishi D1700
3 Tp Piston Pin Mitsubishi D1700
3 Tp Piston Pin Searclip Mitsubishi D1700

You sell one nox (a piston kit). The system 'know' that it's a kit and
'knows' what makes up the kit, so it processes the sale as one of each kit
component. Your stock is:
0 Tp Piston Mitsubishi D1700 Kit*
2 Tp Piston Mitsubishi D1700
2 Tp Piston Pin Mitsubishi D1700
2 Tp Piston Pin Searclip Mitsubishi D1700

You need to handle a kit as (a) in stock if all its components are in stock,
(b) a sale of all its components, not a sale of a kit, and (c) a sale at the
kit price, not the sum of the component price. A kit item can never be
received into stock, so your stock receiving process has to break down the
kit into its components as well.