Managing Inventory is important to save time and prevent losses. Inventory management system is a complex software.

We have been tinkering with our Inventory Management system for a while now. However I a still not satisfied with what we achieved. Probably the task is quite complicated.
This is what we need to take care of:
Pricebook:
1. This is where we keep the list of products that we sell.
There is also a challenge here:
Example:
Product description: T-Shirt Selangor 2017
Variant1: Colour - red, blue, green
Variant2: Size - Small, medium, large, XL
Variant3: Style  - Cotton,
You can see that for one product item, we have to handle three variants.

We we should do is to register every variant as a separate SKU and separate barcode.
This is the method of inventory management and SKU management.
So you will have every product and variants have different barcode and SKU number.

After this you need to handle the packages:
1. Individual unit
2. Package 1 - 1 dozen
3. Package 2- 4 units
How do we handle this?

First we need to know what is the content of the package:
So we need to register the package:
For example the  package 1: 1 dozen
We register the Package 1 as another SKU with own barcode.
We go to package setting:
Now we register the items in this package:
The system will list all the items,
and we need to select the items and variants and the quantity for this variant.
For example:
Package 1 - 1 dozen
Selangor T-Shirt 2017 - Color: Blue   Size: S   Style: Cottton  Qty: 2
Selangor T-Shirt 2017 - Color: Blue   Size: M   Style: Cottton  Qty: 2
Selangor T-Shirt 2017 - Color: Blue   Size: L  Style: Cottton  Qty: 2
Selangor T-Shirt 2017 - Color: Red    Size: S   Style: Cottton  Qty: 2
Selangor T-Shirt 2017 - Color: Red   Size: M   Style: Cottton  Qty: 2
Selangor T-Shirt 2017 - Color: Red   Size: L  Style: Cottton  Qty: 2

From this we would be able to know what is the content of the package.
You notice that all individual content of the package is also registered in Pricebook as a unique SKU.

When we run the inventory report we can dig deeper:
For example:
We have:
 Package 1   Qty: 3

But we can also get detailed quantity based on individual content,
Which is:
Selangor T-Shirt 2017 - Color: Blue   Size: S   Style: Cottton  Qty:6
Selangor T-Shirt 2017 - Color: Blue   Size: M   Style: Cottton  Qty:6
Selangor T-Shirt 2017 - Color: Blue   Size: L  Style: Cottton  Qty:6
Selangor T-Shirt 2017 - Color: Red    Size: S   Style: Cottton  Qty:6
Selangor T-Shirt 2017 - Color: Red   Size: M   Style: Cottton  Qty:6
Selangor T-Shirt 2017 - Color: Red   Size: L  Style: Cottton  Qty:6
Once your Pricebook design is able to handle variant and packages,
then we can start looking into Inventory Tracking:

For example in Point of Sales:
We can display product item
 Example: T-Shirt Selangor 2017
Then select the variant:
Colour:
Size:
Style:
Then select quantity:

By doing this the POS display will show only one image called T-Shirt Selangor 2017
You select the variant to fix the actual order.

We can also sell package:
Package 1:
Which contains 1 dozen items,
which we can give the list from pricebook.

We can see the inventory transactions and inventory balance:
 For example:
Package 1 - Inventory Out - Qty 1, Balance: Package 1 - 6

The SKU is the unique code for every package or item.
Go to the SKU and deduct or add as required.
For package, the SKU contanins other SKUs as defined in pricebook.
You can have the report for individual SKU from this method.

We will let you know when this version is launched.
 This will improve the way we show things in our POS.