Re: RE: Selling and Buying In Differnt Units of Measurements

2018-03-02 Thread James Yong 
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,  wrote: 
> James - Where do I find the batch quantity?
>  Original Message 
> Subject: Re: Selling and Buying In Differnt Units of Measurements
> From: James Yong 
> Date: Thu, March 01, 2018 5:33 am
> To: 
> 
> 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,  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
> >
>

RE: Selling and Buying In Differnt Units of Measurements

2018-03-02 Thread james 
James - Where do I find the batch quantity?
 Original Message 
Subject: Re: Selling and Buying In Differnt Units of Measurements
From: James Yong 
Date: Thu, March 01, 2018 5:33 am
To: 

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,  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
>

Re: Selling and Buying In Differnt Units of Measurements

2018-03-02 Thread Sharan Foga 


On 2018/03/01 12:33:42, James Yong  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,  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
> > 
>

RE: Selling and Buying In Differnt Units of Measurements

2018-03-01 Thread james 
Yes.  It seems those fields will be extremely useful.  If the Supplier
record has UOM as cases and quantity included as 6 then on my Purchase
Order to that supplier I order 1 Case.  When I receive that purchase
order in Ofbiz it actually receives a quantity of 6.

 Original Message 
Subject: Re: Selling and Buying In Differnt Units of Measurements
From: Vaibhav Jain 
Date: Thu, March 01, 2018 4:15 am
To: user@ofbiz.apache.org

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: vaibhav.j...@hotwaxsystems.com


On Thu, Mar 1, 2018 at 3:45 PM, Rishi Solanki 
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: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Feb 28, 2018 at 10:07 PM,  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
> >
>

Re: Selling and Buying In Differnt Units of Measurements

2018-03-01 Thread James Yong 
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,  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
>

Re: Selling and Buying In Differnt Units of Measurements

2018-03-01 Thread 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  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/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: vaibhav.j...@hotwaxsystems.com
> 
>
> On Thu, Mar 1, 2018 at 3:45 PM, Rishi Solanki 
> 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: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Wed, Feb 28, 2018 at 10:07 PM,  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
> > >
> >
>

Re: Selling and Buying In Differnt Units of Measurements

2018-03-01 Thread 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/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: vaibhav.j...@hotwaxsystems.com


On Thu, Mar 1, 2018 at 3:45 PM, Rishi Solanki 
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: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Wed, Feb 28, 2018 at 10:07 PM,  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
> >
>

Re: Selling and Buying In Differnt Units of Measurements

2018-03-01 Thread 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: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Wed, Feb 28, 2018 at 10:07 PM,  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
>

Selling and Buying In Differnt Units of Measurements

2018-02-28 Thread james 

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