Selling and Buying In Differnt Units of Measurements

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Rishi Solanki]

Please look for the Product.quantityIncluded and related code. An example
product setup with id WG-9943, on purchase you can select the quantity UOM.
On selecting the quantity UOM it will add more than one quantity into the
cart.

HTH!

Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: [phone]
http://www.hotwaxsystems.com
www.hotwax.co

On Wed, Feb 28, 2018 at 10:07 PM, <[hidden email]> wrote:

>
> Can ofbiz buy in one unit of measure and sell in another unit of
> measure.  For example:
>
> 1 Buy product GZ-1000 in case quantity in which each case includes 12
> eaches
>
> So I buy quantity of 1
>
> However when I receive it since I sell it in eaches ...I receive
> quantity of 12
>
> Is there a way of doing this without having to have to different
> products?
>
> Thanks,
>
> James
>

[Vaibhav Jain]

Hello James,

OFBiz does not have support to buy or sell the product in multiple quantity
UOM.

This topic is already discussed before in the community. In OFBiz there is
a support of marketing package in which we can assemble and decompose the
product to trade the product in multiple UOM.

While using marketing package we need to maintain same product multiple
times for different UOM.

There is a drawback of using marketing package that we need to maintain
same product multiple times for different UOM.

You need to do the custom changes to achieve the support of multiple UOM.

Here are some links to some of the reference previous discussions.
http://ofbiz.markmail.org/message/wnvkuyfubn6dewzc
<http://ofbiz.markmail.org/message/wnvkuyfubn6dewzc?q=selling+uom>
http://ofbiz.markmail.org/message/l25duvbuuhspohyv
http://ofbiz.markmail.org/message/7vala7xcgcs5nb4n

The high-level design proposed for multiple quantity UOM

   1. We can use SupplierProduct entity to manage products in various UOM
   for the same supplier.
   2. Inventory of the product is maintained in the lowest quantity UOM.
   3. At the time of sales, quantity UOM is managed for tagging and sales
   will happen by UOM conversion.

Hope this will help ☺

Vaibhav Jain
Sr. Enterprise Software Engineer
HotWax Systems
m: 782-834-1900 e: [hidden email]
<[hidden email]>

On Thu, Mar 1, 2018 at 3:45 PM, Rishi Solanki <[hidden email]>
wrote:

> Please look for the Product.quantityIncluded and related code. An example
> product setup with id WG-9943, on purchase you can select the quantity UOM.
> On selecting the quantity UOM it will add more than one quantity into the
> cart.
>
> HTH!
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: [phone]
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Feb 28, 2018 at 10:07 PM, <[hidden email]> wrote:
>
> >
> > Can ofbiz buy in one unit of measure and sell in another unit of
> > measure.  For example:
> >
> > 1 Buy product GZ-1000 in case quantity in which each case includes 12
> > eaches
> >
> > So I buy quantity of 1
> >
> > However when I receive it since I sell it in eaches ...I receive
> > quantity of 12
> >
> > Is there a way of doing this without having to have to different
> > products?
> >
> > Thanks,
> >
> > James
> >
>

[aayush jain]

Thanks Vaibhav for detailed information and high-level design proposal for
multiple UOM support.

On Thu, Mar 1, 2018 at 4:45 PM, Vaibhav Jain <[hidden email]
> wrote:

> Hello James,
>
> OFBiz does not have support to buy or sell the product in multiple quantity
> UOM.
>
> This topic is already discussed before in the community. In OFBiz there is
> a support of marketing package in which we can assemble and decompose the
> product to trade the product in multiple UOM.
>
> While using marketing package we need to maintain same product multiple
> times for different UOM.
>
> There is a drawback of using marketing package that we need to maintain
> same product multiple times for different UOM.
>
> You need to do the custom changes to achieve the support of multiple UOM.
>
> Here are some links to some of the reference previous discussions.
> http://ofbiz.markmail.org/message/wnvkuyfubn6dewzc
> <http://ofbiz.markmail.org/message/wnvkuyfubn6dewzc?q=selling+uom>
> http://ofbiz.markmail.org/message/l25duvbuuhspohyv
> http://ofbiz.markmail.org/message/7vala7xcgcs5nb4n
>
> The high-level design proposed for multiple quantity UOM
>
>    1. We can use SupplierProduct entity to manage products in various UOM
>    for the same supplier.
>    2. Inventory of the product is maintained in the lowest quantity UOM.
>    3. At the time of sales, quantity UOM is managed for tagging and sales
>    will happen by UOM conversion.
>
> Hope this will help ☺
>
> Vaibhav Jain
> Sr. Enterprise Software Engineer
> HotWax Systems
> m: 782-834-1900 e: [hidden email]
> <[hidden email]>
>
> On Thu, Mar 1, 2018 at 3:45 PM, Rishi Solanki <[hidden email]>
> wrote:
>
> > Please look for the Product.quantityIncluded and related code. An example
> > product setup with id WG-9943, on purchase you can select the quantity
> UOM.
> > On selecting the quantity UOM it will add more than one quantity into the
> > cart.
> >
> > HTH!
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: [phone]
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Wed, Feb 28, 2018 at 10:07 PM, <[hidden email]> wrote:
> >
> > >
> > > Can ofbiz buy in one unit of measure and sell in another unit of
> > > measure.  For example:
> > >
> > > 1 Buy product GZ-1000 in case quantity in which each case includes 12
> > > eaches
> > >
> > > So I buy quantity of 1
> > >
> > > However when I receive it since I sell it in eaches ...I receive
> > > quantity of 12
> > >
> > > Is there a way of doing this without having to have to different
> > > products?
> > >
> > > Thanks,
> > >
> > > James
> > >
> >
>

[James Yong-2]

Hi James,

You are doing a debulk of the inventory item. I have used the following approach for one closed-sourced project.

You will need to implement a batch quantity attribute that is tied to a particular Bill of Material (BOM).
So when we have a BOM A for Product B with batch quantity 12, this means a production run with BOM A will produce 12 items of Product B.

Using your example, we have 2 different products. One is 'GZ-1000 x 1', another is 'GZ-1000 x 12'.
You set up a BOM for 'GX-1000 x 1' with a batch quantity of 12, and requiring 'GZ-1000 x 12' as material.
Then do a production run to debulk.

Regards,
James Yong

On 2018/02/28 16:37:35, <[hidden email]> wrote:

>
> Can ofbiz buy in one unit of measure and sell in another unit of
> measure.  For example:
>
> 1 Buy product GZ-1000 in case quantity in which each case includes 12
> eaches
>
> So I buy quantity of 1
>
> However when I receive it since I sell it in eaches ...I receive
> quantity of 12
>
> Is there a way of doing this without having to have to different
> products?
>
> Thanks,
>
> James
>

[Sharan Foga]

On 2018/03/01 12:33:42, James Yong <[hidden email]> wrote:

> Hi James,
>
> You are doing a debulk of the inventory item. I have used the following approach for one closed-sourced project.
>
> You will need to implement a batch quantity attribute that is tied to a particular Bill of Material (BOM).
> So when we have a BOM A for Product B with batch quantity 12, this means a production run with BOM A will produce 12 items of Product B.
>
> Using your example, we have 2 different products. One is 'GZ-1000 x 1', another is 'GZ-1000 x 12'.
> You set up a BOM for 'GX-1000 x 1' with a batch quantity of 12, and requiring 'GZ-1000 x 12' as material.
> Then do a production run to debulk.

Nice tip James and something that can be done without any code changes.  I think it would be good to capture creative solutions like this!

Thanks
Sharan

>
> Regards,
> James Yong
>
> On 2018/02/28 16:37:35, <[hidden email]> wrote:
> >
> > Can ofbiz buy in one unit of measure and sell in another unit of
> > measure.  For example:
> >
> > 1 Buy product GZ-1000 in case quantity in which each case includes 12
> > eaches
> >
> > So I buy quantity of 1
> >
> > However when I receive it since I sell it in eaches ...I receive
> > quantity of 12
> >
> > Is there a way of doing this without having to have to different
> > products?
> >
> > Thanks,
> >
> > James
> >
>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[James Yong-2]

Hi James,

A significant code change is required to support the missing feature of batch quantity.
Please also see my answer at
https://lists.apache.org/thread.html/58a468d9629d92829aa0276c4644edad453a2017e9f281491e2edd6d@%3Cuser.ofbiz.apache.org%3E

You will also need to support multiple BOM for the ssme product.

Regards

On 2018/03/02 19:39:54, <[hidden email]> wrote:

> James - Where do I find the batch quantity?
> -------- Original Message --------
> Subject: Re: Selling and Buying In Differnt Units of Measurements
> From: James Yong <[hidden email]>
> Date: Thu, March 01, 2018 5:33 am
> To: <[hidden email]>
>
> Hi James,
>
> You are doing a debulk of the inventory item. I have used the following
> approach for one closed-sourced project.
>
> You will need to implement a batch quantity attribute that is tied to a
> particular Bill of Material (BOM).
> So when we have a BOM A for Product B with batch quantity 12, this means
> a production run with BOM A will produce 12 items of Product B.
>
> Using your example, we have 2 different products. One is 'GZ-1000 x 1',
> another is 'GZ-1000 x 12'.
> You set up a BOM for 'GX-1000 x 1' with a batch quantity of 12, and
> requiring 'GZ-1000 x 12' as material.
> Then do a production run to debulk.
>
> Regards,
> James Yong
>
> On 2018/02/28 16:37:35, <[hidden email]> wrote:
> >
> > Can ofbiz buy in one unit of measure and sell in another unit of
> > measure. For example:
> >
> > 1 Buy product GZ-1000 in case quantity in which each case includes 12
> > eaches
> >
> > So I buy quantity of 1
> >
> > However when I receive it since I sell it in eaches ...I receive
> > quantity of 12
> >
> > Is there a way of doing this without having to have to different
> > products?
> >
> > Thanks,
> >
> > James
> >
>