Modeling volume manufacturing

Hi all,

I have a scenario where my company manufactures some drinks. They do either drink mixing or repacking of a variety of flavors. I'm wondering what is the best way to model this with respect to the manufacturing and stock modules.

Essentially, the way this works is they order large containers of basic drinks and water (say 500 liters of A, 500 liters of B, 300 liters of water, etc.). They have different containers sizes for each basic drink, which they then mix in larger containers to produce more complex drinks or which they directly repack into 33cl, 50cl or 1l bottles.

The way I've modeled this so far is as follows:

- For each basic drink and water, I have different containers, i.e. A-500, A-300, A-100, etc. (which then corresponds to what they order from suppliers). I therefore have items A-500, A-300, A-100, etc. I also have an item A, but that's used for manufacturing (when I convert into volumes -- see below). I can't model this directly as A, B, C and have the quantities be liters, because they need to keep track of the *drinks in the containers* in their stock until they actually use the contents to produce something else (i.e. they don't order 500 liters of A, they order 1 container of 500 liters of A, each of which has a batch and serial number).
- A-500 comes in, is weighted and the corresponding volume is determined in a custom field during the purchase receipt (there is a 2% margin of error allowed on the volume).
- When A-500 is used for manufacturing, it goes into a Work in Progress warehouse where it no longer exists as a container, but becomes a volume of A (I pull the volume from the purchase receipt and I convert it in a custom script).
- What comes out of manufacturing is something like 100x ABC-33cl which are then assigned a batch and serial number. I have pre-computed BOMs for every possible combination. (Side question: I'd like to have the option to do 50x ABC-50cl and 50x ABC-33cl in one production order -- is that possible ATM?).

Am I going about this the right way or am I shooting myself in the foot? This seems like a lot of different items and lots of BOMs to maintain.

Thanks in advance,

Billy



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/91daaefd-f796-467a-aab8-6f0049222938%40googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Dear Billy,

Thanks for the detailed explanation of your scenario.

Considering item A for further elaboration, you should create two items for Item A, having different UoM.

Item A- Container
Item A- Litre

Item A - Container will be serialized item. Each container in-stock will have a unique serial no. You will use this item for Purchase and stock entries.

When you need to use Item A for production, you will need to make repack entry. With this entry, Item A - Container will be repacked to Item A - Litre. Check following link to learn more about it.

http://erpnext.org/how-to-repack-products

The repack entry will give you Item A - Litre in stock which you can use as raw-material in BOM and Production Entry.

Also ABC-50cl and ABC-33cl will be two different item. Currently Production Order can be created only for one item.


On Fri, Feb 28, 2014 at 3:44 AM, <bi...@gmail.com> wrote:
Hi all,

I have a scenario where my company manufactures some drinks. They do either drink mixing or repacking of a variety of flavors. I'm wondering what is the best way to model this with respect to the manufacturing and stock modules.

Essentially, the way this works is they order large containers of basic drinks and water (say 500 liters of A, 500 liters of B, 300 liters of water, etc.). They have different containers sizes for each basic drink, which they then mix in larger containers to produce more complex drinks or which they directly repack into 33cl, 50cl or 1l bottles.

The way I've modeled this so far is as follows:

- For each basic drink and water, I have different containers, i.e. A-500, A-300, A-100, etc. (which then corresponds to what they order from suppliers). I therefore have items A-500, A-300, A-100, etc. I also have an item A, but that's used for manufacturing (when I convert into volumes -- see below). I can't model this directly as A, B, C and have the quantities be liters, because they need to keep track of the *drinks in the containers* in their stock until they actually use the contents to produce something else (i.e. they don't order 500 liters of A, they order 1 container of 500 liters of A, each of which has a batch and serial number).
- A-500 comes in, is weighted and the corresponding volume is determined in a custom field during the purchase receipt (there is a 2% margin of error allowed on the volume).
- When A-500 is used for manufacturing, it goes into a Work in Progress warehouse where it no longer exists as a container, but becomes a volume of A (I pull the volume from the purchase receipt and I convert it in a custom script).
- What comes out of manufacturing is something like 100x ABC-33cl which are then assigned a batch and serial number. I have pre-computed BOMs for every possible combination. (Side question: I'd like to have the option to do 50x ABC-50cl and 50x ABC-33cl in one production order -- is that possible ATM?).

Am I going about this the right way or am I shooting myself in the foot? This seems like a lot of different items and lots of BOMs to maintain.

Thanks in advance,

Billy



Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/91daaefd-f796-467a-aab8-6f0049222938%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




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



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAJ33fAuF4cmeNd2PncJCw4g_6NibJcyvV40Ps1c6%2Bb2Cb%2Bv4gg%40mail.gmail.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Seems fine to me - you can directly create a stock entry instead of the production order, via your script.

You can create a special screen (tip, use Single DocType) to update production that will create he Stock Entries in the background.


On Friday, February 28, 2014 3:44:41 AM UTC+5:30, bi...@gmail.com wrote:
Hi all,

I have a scenario where my company manufactures some drinks. They do either drink mixing or repacking of a variety of flavors. I'm wondering what is the best way to model this with respect to the manufacturing and stock modules.

Essentially, the way this works is they order large containers of basic drinks and water (say 500 liters of A, 500 liters of B, 300 liters of water, etc.). They have different containers sizes for each basic drink, which they then mix in larger containers to produce more complex drinks or which they directly repack into 33cl, 50cl or 1l bottles.

The way I've modeled this so far is as follows:

- For each basic drink and water, I have different containers, i.e. A-500, A-300, A-100, etc. (which then corresponds to what they order from suppliers). I therefore have items A-500, A-300, A-100, etc. I also have an item A, but that's used for manufacturing (when I convert into volumes -- see below). I can't model this directly as A, B, C and have the quantities be liters, because they need to keep track of the *drinks in the containers* in their stock until they actually use the contents to produce something else (i.e. they don't order 500 liters of A, they order 1 container of 500 liters of A, each of which has a batch and serial number).
- A-500 comes in, is weighted and the corresponding volume is determined in a custom field during the purchase receipt (there is a 2% margin of error allowed on the volume).
- When A-500 is used for manufacturing, it goes into a Work in Progress warehouse where it no longer exists as a container, but becomes a volume of A (I pull the volume from the purchase receipt and I convert it in a custom script).
- What comes out of manufacturing is something like 100x ABC-33cl which are then assigned a batch and serial number. I have pre-computed BOMs for every possible combination. (Side question: I'd like to have the option to do 50x ABC-50cl and 50x ABC-33cl in one production order -- is that possible ATM?).

Am I going about this the right way or am I shooting myself in the foot? This seems like a lot of different items and lots of BOMs to maintain.

Thanks in advance,

Billy



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/7e282848-5937-4c09-a349-14d60d28166e%40googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.