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.

via Blogger http://ift.tt/2mrzW51

Facebooktwittergoogle_plusredditpinterestlinkedinmail
Facebooktwittergoogle_pluslinkedinrssyoutubeinstagram
About Ir. Aziz Ismail 66 Articles
Ir.Aziz Ismail is very active member of ICT economic cluster in Malaysia. As the (Past) President of TeAM ( Technopreneur Association of Malaysia) and Vice President II NEF ( Bumiputera ICT Entrepreneur Association) he is deeply involved in many strategies, activities and issues related to the industry. He is also a Director of Majlis Tindakan Ekonomi Melayu, an umbrella organisation of 47 national NGOs with 500,000 entrepreneur members.

Be the first to comment

Leave a Reply

Your email address will not be published.


*