Maintaining Inventory Color-wise and S.No.-wise

We are a manufacturing company and are facing an issue of maintaining
inventory of Semi-finished goods color-wise and S.No.-wise.

Brief: We mix Raw Materials in batches and manufacture the product ABC
in quantity lets say 2500 kg(or 5000 mtrs) in which 5 colors are
produced in a set of 50 rolls. The rolls are segregated by Item
Name(ABC, here), Color, S.No.( these are the variable attributes) and
then there are fixed attributes which are common to the whole quantity
of 2500 kgs(or 5000 mtrs).

Example:

The item ABC manufactured is stored as under:

Item Name Color Roll No. Qty.(kgs) Qty.(Mtrs)
Dimension Issue to(Workstation)
ABC Black 45 38
76 ----(fixed) P
ABC Black 46 50
102 P




ABC White 58 42
86 P
ABC White 59 56
110 P



ABC Red 72 60
124 G
ABC Red 73 45
88 G

and so on…

P & G are the name of two workstations to which the Item is sent for
further processing.

So, the issue here is to store the inventory of semi-finished good
manufactured in S.No. and color-wise in the erp framework.

Looking forward to your valuable inputs.

Hello Ravish,

Sorry did not understand your requirement well.

But based on what I understood, here is what I can suggest

1. You will have to create a unique item code for each item, based on your example, you will have items

ABC-Black-72
ABC-Black-102
ABC-White-86

and so on ... If you are not doing it that way, you will have to take the effort of doing this exercise. The whole inventory runs on the concept that each item is unique. The stock or valuation or price of this item will be attached to the item code.

There is no - work around this. It might be tough at first, but trust me in the long run, it will be very useful

2. For each batch, you will have to create a stock entry that will consume your raw material (say in rolls or kgs or mtrs - you will have to fix ONE stock unit) and produce the semi-finished items.

3. You can serialize your roles so that each role has a specific serial number (set Serialized to Yes in item master)

Your entry will be:

Warehouse  ---  Item --- Qty --- Serial NUmber
--------------------------------------------------------------
Store --- Roll --- (-1) --- 45
P --- ABC-Black-72 --- +38
P --- ABC-Black-102 --- +50

If you do this entry at the end of our work session, you will have the accurate inventory. If you have more complex processes, you can also try using Bill of Materials (but I would not try it the first time)

Hope this helps!

best,
Rushabh



---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com
T: @rushabh_mehta

On 25-Jan-2012, at 2:58 PM, Ravish Chawla wrote:

We are a manufacturing company and are facing an issue of maintaining
inventory of Semi-finished goods color-wise and S.No.-wise.

Brief: We mix Raw Materials in batches and manufacture the product ABC
in quantity lets say 2500 kg(or 5000 mtrs) in which 5 colors are
produced in a set of 50 rolls. The rolls are segregated by Item
Name(ABC, here), Color, S.No.( these are the variable attributes) and
then there are fixed attributes which are common to the whole quantity
of 2500 kgs(or 5000 mtrs).

Example:

The item ABC manufactured is stored as under:

Item Name    Color       Roll No.      Qty.(kgs)    Qty.(Mtrs)
Dimension    Issue to(Workstation)
ABC             Black        45               38
76                ----(fixed)               P
ABC             Black        46               50
102                                           P
..........
..........
..........
..........
ABC           White          58               42
86                                          P
ABC           White          59               56
110                                         P
..........
..........
..........
..........

ABC           Red          72               60
124                                         G
ABC           Red          73               45
88                                          G

and so on...


P & G are the name of two workstations to which the Item is sent for
further processing.

So, the issue here is to store the inventory of semi-finished good
manufactured in S.No. and color-wise in the erp framework.

Looking forward to your valuable inputs.


Hi Rushabh,

Appreciate the promptness in reply.

I don’t think the issue is followed here since the example is unclear there. I am sending an excel sheet for the example. And for storing the inventory color-wise a drop-down may be provided against each Item & S.No. for the convenience in entry and reporting.


The S.No. is a unique number which is associated with every roll manufactured in a fiscal, just like the feature of Primary Key that is there in MS Access.

Hope this clears the requirement.

Best Regards,


Ravish Chawla.

On Wed, Jan 25, 2012 at 3:39 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Hello Ravish,

Sorry did not understand your requirement well.

But based on what I understood, here is what I can suggest

1. You will have to create a unique item code for each item, based on your example, you will have items

ABC-Black-72
ABC-Black-102
ABC-White-86

and so on ... If you are not doing it that way, you will have to take the effort of doing this exercise. The whole inventory runs on the concept that each item is unique. The stock or valuation or price of this item will be attached to the item code.

There is no - work around this. It might be tough at first, but trust me in the long run, it will be very useful

2. For each batch, you will have to create a stock entry that will consume your raw material (say in rolls or kgs or mtrs - you will have to fix ONE stock unit) and produce the semi-finished items.

3. You can serialize your roles so that each role has a specific serial number (set Serialized to Yes in item master)

Your entry will be:

Warehouse --- Item --- Qty --- Serial NUmber
--------------------------------------------------------------
Store --- Roll --- (-1) --- 45
P --- ABC-Black-72 --- +38
P --- ABC-Black-102 --- +50

If you do this entry at the end of our work session, you will have the accurate inventory. If you have more complex processes, you can also try using Bill of Materials (but I would not try it the first time)

Hope this helps!

best,
Rushabh



---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com
T: @rushabh_mehta

On 25-Jan-2012, at 2:58 PM, Ravish Chawla wrote:

We are a manufacturing company and are facing an issue of maintaining
inventory of Semi-finished goods color-wise and S.No.-wise.

Brief: We mix Raw Materials in batches and manufacture the product ABC
in quantity lets say 2500 kg(or 5000 mtrs) in which 5 colors are
produced in a set of 50 rolls. The rolls are segregated by Item
Name(ABC, here), Color, S.No.( these are the variable attributes) and
then there are fixed attributes which are common to the whole quantity
of 2500 kgs(or 5000 mtrs).

Example:

The item ABC manufactured is stored as under:

Item Name Color Roll No. Qty.(kgs) Qty.(Mtrs)
Dimension Issue to(Workstation)
ABC Black 45 38
76 ----(fixed) P
ABC Black 46 50
102 P
..........
..........
..........
..........
ABC White 58 42
86 P
ABC White 59 56
110 P
..........
..........
..........
..........

ABC Red 72 60
124 G
ABC Red 73 45
88 G

and so on...


P & G are the name of two workstations to which the Item is sent for
further processing.

So, the issue here is to store the inventory of semi-finished good
manufactured in S.No. and color-wise in the erp framework.

Looking forward to your valuable inputs.



Umair,

Pls setup a session at your convenience

- Rushabh


---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com
T: @rushabh_mehta

Begin forwarded message:

From: SUNTOP <su...@gmail.com>
Subject: Re: [erpnext-user-forum] Maintaining Inventory Color-wise and S.No.-wise
Date: 26 January 2012 12:38:32 PM GMT+05:30
To: Rushabh Mehta <rm...@gmail.com>

Thanks.

Regards,

Ravish Chawla.

On Thu, Jan 26, 2012 at 12:05 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Hi Ravish,

I will ask Umair to setup a session with your tomorrow (or at your convenience) and understand better. We should be able to find some solution

best,
Rushabh


---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com
T: @rushabh_mehta

On 26-Jan-2012, at 11:39 AM, SUNTOP wrote:

Dear Rushabh,

May I ask you to define the good way of doing things !
I am open to paying for the customization.

Regards,

Ravish Chawla.



On Thu, Jan 26, 2012 at 10:52 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Thanks Ravish,

Our goal is to make ERPs affordable to small businesses. The current ERPs are just too overpriced.

But what you are asking for is not a good way of doing things, but its up to you. I won't hard-sell. You can also do it by custom fields (few of our customer do it), but won't guarantee you will get inventory reports if you add custom fields. Its a one time effort to make the item codes.

For maintaining serial numbers, you can do that via the Serial Number master. You must mark the item has Serialized. See the item help.


You can also create your serial numbers in an excel sheet and upload


best,
Rushabh





---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com
T: @rushabh_mehta

On 25-Jan-2012, at 9:47 PM, SUNTOP wrote:

Hi Rushabh,

The primary objective here is to give a Unique S.No. to each roll manufactured, its like a unique identification no. for every roll as you can see under the S.No. in that excel sheet.(A feature that is there in MS Access as 'Primary Key').


About the drop down, its not about the feature but the convenience that is derived in maintaining and reporting inventory. Convenience, ease of use and brisk reporting are the reasons why people moved from book-keeping to accounting software to erp and now for that convenience we are considering cloud based erp. 


Here I must appreciate you guys to have put up a such a sound erp system online at this highly reasonable price point.

Regards,

Ravish Chawla.


On Wed, Jan 25, 2012 at 5:24 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Hi Ravish,

If you don't make separate item codes, you cannot keep separate inventory of those items. I know it is convenient to have attributes as drop-downs and I have had this discussion many times :).. But in the long run, a unique item code is the key to inventory management and also profitability analysis.

You are giving me a data structure but I am not able to get what is your objective?

1. If your objective is to maintain correct inventory levels, using stock entry as I detailed below will be useful.
2. If you want material planning, use Bill of Materials and Production Plans and Product Orders
3. If you want drop down for attributes, I am sorry but our design does not allow it (and you will find that no good inventory software will allow it). I would strongly suggest you evaluate unique item codes.

best regards,
Rushabh


---------------------------------------------------------

ERPNext - World’s most affordable ERP.

W: https://erpnext.com

T: @rushabh_mehta


On 25-Jan-2012, at 4:18 PM, SUNTOP wrote:

Hi Rushabh,

Appreciate the promptness in reply.

I don't think the issue is followed here since the example is unclear there. I am sending an excel sheet for the example. And for storing the inventory color-wise a drop-down may be provided against each Item & S.No. for the convenience in entry and reporting.


The S.No. is a unique number which is associated with every roll manufactured in a fiscal, just like the feature of Primary Key that is there in MS Access.

Hope this clears the requirement.

Best Regards,


Ravish Chawla.

On Wed, Jan 25, 2012 at 3:39 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Hello Ravish,

Sorry did not understand your requirement well.

But based on what I understood, here is what I can suggest

  1. You will have to create a unique item code for each item, based on your example, you will have items

ABC-Black-72
ABC-Black-102
ABC-White-86

and so on … If you are not doing it that way, you will have to take the effort of doing this exercise. The whole inventory runs on the concept that each item is unique. The stock or valuation or price of this item will be attached to the item code.

There is no - work around this. It might be tough at first, but trust me in the long run, it will be very useful

2. For each batch, you will have to create a stock entry that will consume your raw material (say in rolls or kgs or mtrs - you will have to fix ONE stock unit) and produce the semi-finished items.

3. You can serialize your roles so that each role has a specific serial number (set Serialized to Yes in item master)

Your entry will be:

Warehouse  ---  Item --- Qty --- Serial NUmber
--------------------------------------------------------------
Store --- Roll --- (-1) --- 45
P --- ABC-Black-72 --- +38
P --- ABC-Black-102 --- +50

If you do this entry at the end of our work session, you will have the accurate inventory. If you have more complex processes, you can also try using Bill of Materials (but I would not try it the first time)

Hope this helps!

best,
Rushabh



---------------------------------------------------------

ERPNext - World’s most affordable ERP.

W: https://erpnext.com

T: @rushabh_mehta


On 25-Jan-2012, at 2:58 PM, Ravish Chawla wrote:

We are a manufacturing company and are facing an issue of maintaining
inventory of Semi-finished goods color-wise and S.No.-wise.


Brief: We mix Raw Materials in batches and manufacture the product ABC
in quantity lets say 2500 kg(or 5000 mtrs) in which 5 colors are
produced in a set of 50 rolls. The rolls are segregated by Item
Name(ABC, here), Color, S.No.( these are the variable attributes) and

then there are fixed attributes which are common to the whole quantity
of 2500 kgs(or 5000 mtrs).

Example:

The item ABC manufactured is stored as under:

Item Name    Color       Roll No.      Qty.(kgs)    Qty.(Mtrs)

Dimension    Issue to(Workstation)
ABC             Black        45               38
76                ----(fixed)               P
ABC             Black        46               50
102                                           P





ABC           White          58               42
86                                          P
ABC           White          59               56
110                                         P






ABC           Red          72               60
124                                         G
ABC           Red          73               45
88                                          G


and so on…


P & G are the name of two workstations to which the Item is sent for
further processing.

So, the issue here is to store the inventory of semi-finished good
manufactured in S.No. and color-wise in the erp framework.


Looking forward to your valuable inputs.



<Example.xlsx>







Hi Rushabh,

I conducted session on Wednesday and discussed possibilities.

- No work around for maintaining color wise and size wise inventory, but to create separate item code. He don’t want to do it.


- He maintains stock in Kg but issue the same item in rolls. And wants to assign serial no. / batch no. to each role. I think functionality suggested by Aditya, where user will enter both consumable and output at in same table can be helpful at once. Then, we can suggest him using that.


Regards,
Umair Sayyed

On Thu, Jan 26, 2012 at 2:03 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Umair,

Pls setup a session at your convenience

- Rushabh


---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com
T: @rushabh_mehta

Begin forwarded message:

From: SUNTOP <su...@gmail.com>
Subject: Re: [erpnext-user-forum] Maintaining Inventory Color-wise and S.No.-wise
Date: 26 January 2012 12:38:32 PM GMT+05:30
To: Rushabh Mehta <rm...@gmail.com>

Thanks.

Regards,

Ravish Chawla.

On Thu, Jan 26, 2012 at 12:05 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Hi Ravish,

I will ask Umair to setup a session with your tomorrow (or at your convenience) and understand better. We should be able to find some solution

best,
Rushabh


---------------------------------------------------------

ERPNext - World’s most affordable ERP.

W: https://erpnext.com

T: @rushabh_mehta


On 26-Jan-2012, at 11:39 AM, SUNTOP wrote:

Dear Rushabh,

May I ask you to define the good way of doing things !
I am open to paying for the customization.

Regards,

Ravish Chawla.



On Thu, Jan 26, 2012 at 10:52 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Thanks Ravish,

Our goal is to make ERPs affordable to small businesses. The current ERPs are just too overpriced.

But what you are asking for is not a good way of doing things, but its up to you. I won't hard-sell. You can also do it by custom fields (few of our customer do it), but won't guarantee you will get inventory reports if you add custom fields. Its a one time effort to make the item codes.

For maintaining serial numbers, you can do that via the Serial Number master. You must mark the item has Serialized. See the item help.


You can also create your serial numbers in an excel sheet and upload


best,
Rushabh





---------------------------------------------------------
ERPNext - World's most affordable ERP.

W: https://erpnext.com

T: @rushabh_mehta


On 25-Jan-2012, at 9:47 PM, SUNTOP wrote:

Hi Rushabh,

The primary objective here is to give a Unique S.No. to each roll manufactured, its like a unique identification no. for every roll as you can see under the S.No. in that excel sheet.(A feature that is there in MS Access as 'Primary Key').


About the drop down, its not about the feature but the convenience that is derived in maintaining and reporting inventory. Convenience, ease of use and brisk reporting are the reasons why people moved from book-keeping to accounting software to erp and now for that convenience we are considering cloud based erp.


Here I must appreciate you guys to have put up a such a sound erp system online at this highly reasonable price point.

Regards,

Ravish Chawla.


On Wed, Jan 25, 2012 at 5:24 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Hi Ravish,

If you don't make separate item codes, you cannot keep separate inventory of those items. I know it is convenient to have attributes as drop-downs and I have had this discussion many times :).. But in the long run, a unique item code is the key to inventory management and also profitability analysis.

You are giving me a data structure but I am not able to get what is your objective?

1. If your objective is to maintain correct inventory levels, using stock entry as I detailed below will be useful.
2. If you want material planning, use Bill of Materials and Production Plans and Product Orders
3. If you want drop down for attributes, I am sorry but our design does not allow it (and you will find that no good inventory software will allow it). I would strongly suggest you evaluate unique item codes.

best regards,
Rushabh


---------------------------------------------------------

ERPNext - World’s most affordable ERP.

W: https://erpnext.com

T: @rushabh_mehta


On 25-Jan-2012, at 4:18 PM, SUNTOP wrote:

Hi Rushabh,

Appreciate the promptness in reply.

I don't think the issue is followed here since the example is unclear there. I am sending an excel sheet for the example. And for storing the inventory color-wise a drop-down may be provided against each Item & S.No. for the convenience in entry and reporting.


The S.No. is a unique number which is associated with every roll manufactured in a fiscal, just like the feature of Primary Key that is there in MS Access.

Hope this clears the requirement.

Best Regards,


Ravish Chawla.

On Wed, Jan 25, 2012 at 3:39 PM, Rushabh Mehta <rm…@gmail.com> wrote:
Hello Ravish,

Sorry did not understand your requirement well.

But based on what I understood, here is what I can suggest

  1. You will have to create a unique item code for each item, based on your example, you will have items

ABC-Black-72
ABC-Black-102
ABC-White-86

and so on … If you are not doing it that way, you will have to take the effort of doing this exercise. The whole inventory runs on the concept that each item is unique. The stock or valuation or price of this item will be attached to the item code.

There is no - work around this. It might be tough at first, but trust me in the long run, it will be very useful

2. For each batch, you will have to create a stock entry that will consume your raw material (say in rolls or kgs or mtrs - you will have to fix ONE stock unit) and produce the semi-finished items.

3. You can serialize your roles so that each role has a specific serial number (set Serialized to Yes in item master)

Your entry will be:

Warehouse --- Item --- Qty --- Serial NUmber
--------------------------------------------------------------
Store --- Roll --- (-1) --- 45
P --- ABC-Black-72 --- +38
P --- ABC-Black-102 --- +50

If you do this entry at the end of our work session, you will have the accurate inventory. If you have more complex processes, you can also try using Bill of Materials (but I would not try it the first time)

Hope this helps!

best,
Rushabh



---------------------------------------------------------

ERPNext - World’s most affordable ERP.

W: https://erpnext.com

T: @rushabh_mehta


On 25-Jan-2012, at 2:58 PM, Ravish Chawla wrote:

We are a manufacturing company and are facing an issue of maintaining
inventory of Semi-finished goods color-wise and S.No.-wise.


Brief: We mix Raw Materials in batches and manufacture the product ABC
in quantity lets say 2500 kg(or 5000 mtrs) in which 5 colors are
produced in a set of 50 rolls. The rolls are segregated by Item
Name(ABC, here), Color, S.No.( these are the variable attributes) and

then there are fixed attributes which are common to the whole quantity
of 2500 kgs(or 5000 mtrs).

Example:

The item ABC manufactured is stored as under:

Item Name Color Roll No. Qty.(kgs) Qty.(Mtrs)

Dimension Issue to(Workstation)
ABC Black 45 38
76 ----(fixed) P
ABC Black 46 50
102 P





ABC White 58 42
86 P
ABC White 59 56
110 P






ABC Red 72 60
124 G
ABC Red 73 45
88 G


and so on…


P & G are the name of two workstations to which the Item is sent for
further processing.

So, the issue here is to store the inventory of semi-finished good
manufactured in S.No. and color-wise in the erp framework.


Looking forward to your valuable inputs.



<Example.xlsx>










--
Thanks and Regards,
Umair Sayyed
www.erpnext.com

---- ERPNext - World's most affordable ERP ----