How to put this in inventory system

  • Thread starter Thread starter Jay
  • Start date Start date
J

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.
 
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
 
Jay said:
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! |
************************************************
 
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.
 
Back
Top