Users - Decimal quantity on orders
Locked
Users - Decimal quantity on orders
 
|
Hi,
For the moment, we can't make an order item entry with decimal quantity. Is there a reason of that ? and is there another solution to manage decmal quantity on orders ? Thanks for your answers. Jean-Luc. _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
What happens when you try to do this? The field is a decimal, so it
should be OK. Si mjeanluc wrote: > Hi, > > For the moment, we can't make an order item entry with decimal quantity. > Is there a reason of that ? and is there another solution to manage > decmal quantity on orders ? > > Thanks for your answers. > > Jean-Luc. > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
Si, Jean-Luc, The original intent of the quantity in the ShoppingCart and the OrderItem was to use a decimal number and allow for non-integral quantities. Over time we ran into a few issues and found this to not be the best idea. Some of the code has been updated to only allow for integer values for the quantity field, but it is still a decimal value in the database. For things that need an amount like this specified we are using the "amount" field. There is a flag on the Product entity to specify whether or not the product should ask for an amount in addition to the quantity (for example: 8 2x4s, 8.5ft each, quantity=8, amount=8.5). The field on the OrderItem where the amount goes is called "selectedAmount". -David Si Chen wrote: > What happens when you try to do this? The field is a decimal, so it > should be OK. Si > > mjeanluc wrote: >> Hi, >> >> For the moment, we can't make an order item entry with decimal quantity. >> Is there a reason of that ? and is there another solution to manage >> decmal quantity on orders ? >> >> Thanks for your answers. >> >> Jean-Luc. >> >> _______________________________________________ >> Users mailing list >> [hidden email] >> http://lists.ofbiz.org/mailman/listinfo/users >> >> >> > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
Hi David
I assume this is also the case for BOM quantities? We manufacture apparel and i can't see how we could do without decimal quantities (ie Elastic Pant requires 1.3 metres of fabric) Regards Scott On 4/15/06, David E. Jones <[hidden email]> wrote:
_______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
Hi Scott,
BOM quantities are of course numbers with decimals. Jacopo Scott Gray wrote: > Hi David > > I assume this is also the case for BOM quantities? We manufacture > apparel and i can't see how we could do without decimal quantities (ie > Elastic Pant requires 1.3 metres of fabric) > > Regards > Scott > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
In reply to this post by Scott Gray
Scott, Good question... I'll defer to Jacopo on the specific fields, etc used for a BOM. I'm not sure if it has a dual-field setup like the OrderItem does. -David Scott Gray wrote: > Hi David > > I assume this is also the case for BOM quantities? We manufacture > apparel and i can't see how we could do without decimal quantities (ie > Elastic Pant requires 1.3 metres of fabric) > > Regards > Scott > > On 4/15/06, *David E. Jones* <[hidden email] > <mailto:[hidden email]>> wrote: > > > Si, Jean-Luc, > > The original intent of the quantity in the ShoppingCart and the > OrderItem was to use a decimal number and allow for non-integral > quantities. Over time we ran into a few issues and found this to not > be the best idea. Some of the code has been updated to only allow > for integer values for the quantity field, but it is still a decimal > value in the database. > > For things that need an amount like this specified we are using the > "amount" field. There is a flag on the Product entity to specify > whether or not the product should ask for an amount in addition to > the quantity (for example: 8 2x4s, 8.5ft each, quantity=8, > amount=8.5). The field on the OrderItem where the amount goes is > called "selectedAmount". > > -David > > > Si Chen wrote: > > What happens when you try to do this? The field is a decimal, so it > > should be OK. Si > > > > mjeanluc wrote: > >> Hi, > >> > >> For the moment, we can't make an order item entry with decimal > quantity. > >> Is there a reason of that ? and is there another solution to manage > >> decmal quantity on orders ? > >> > >> Thanks for your answers. > >> > >> Jean-Luc. > >> > >> _______________________________________________ > >> Users mailing list > >> [hidden email] <mailto:[hidden email]> > >> http://lists.ofbiz.org/mailman/listinfo/users > >> > >> > >> > > > > > > _______________________________________________ > > Users mailing list > > [hidden email] <mailto:[hidden email]> > > http://lists.ofbiz.org/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [hidden email] <mailto:[hidden email]> > http://lists.ofbiz.org/mailman/listinfo/users > > > > ------------------------------------------------------------------------ > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
The information is stored in the ProductAssoc.quantity field that is of
type floating-point. Jacopo David E. Jones wrote: > Scott, > > Good question... I'll defer to Jacopo on the specific fields, etc used for a BOM. I'm not sure if it has a dual-field setup like the OrderItem does. > > -David > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
In reply to this post by Jacopo Cappellato
Thanks Jacopo
I only ask because I tried doing a Bom simulation for 1 pant and the result showed I would need 13 metres of fabric, I haven't looked at it too closely yet however. Regards Scott -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of Jacopo Cappellato Sent: Sunday, 16 April 2006 6:35 p.m. To: OFBiz Users / Usage Discussion Subject: Re: [OFBiz] Users - Decimal quantity on orders Hi Scott, BOM quantities are of course numbers with decimals. Jacopo Scott Gray wrote: > Hi David > > I assume this is also the case for BOM quantities? We manufacture > apparel and i can't see how we could do without decimal quantities (ie > Elastic Pant requires 1.3 metres of fabric) > > Regards > Scott > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
Scott,
please verify the user locale you are using; it seems that the value that you've entered in the BOM, "1.3", has been stored as "13" because the system thinks that "," is the decimal separator and "." the thousand separator. So you could try to store it as "1,3" and see what happens... and let me know if you see something wrong here! Jacopo Scott Gray wrote: > Thanks Jacopo > > I only ask because I tried doing a Bom simulation for 1 pant and the result > showed I would need 13 metres of fabric, I haven't looked at it too closely > yet however. > > Regards > Scott > > -----Original Message----- > From: [hidden email] [mailto:[hidden email]] > On Behalf Of Jacopo Cappellato > Sent: Sunday, 16 April 2006 6:35 p.m. > To: OFBiz Users / Usage Discussion > Subject: Re: [OFBiz] Users - Decimal quantity on orders > > Hi Scott, > > BOM quantities are of course numbers with decimals. > > Jacopo > > Scott Gray wrote: >> Hi David >> >> I assume this is also the case for BOM quantities? We manufacture >> apparel and i can't see how we could do without decimal quantities (ie >> Elastic Pant requires 1.3 metres of fabric) >> >> Regards >> Scott >> > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
My fault, I had selected "Example bom formula (qty * k)" when I set the bom
up. Sorry I must start looking at things more closely before I bother you guys. Regards Scott -----Original Message----- From: [hidden email] [mailto:[hidden email]] On Behalf Of Jacopo Cappellato Sent: Sunday, 16 April 2006 6:55 p.m. To: OFBiz Users / Usage Discussion Subject: Re: [OFBiz] Users - Decimal quantity on orders Scott, please verify the user locale you are using; it seems that the value that you've entered in the BOM, "1.3", has been stored as "13" because the system thinks that "," is the decimal separator and "." the thousand separator. So you could try to store it as "1,3" and see what happens... and let me know if you see something wrong here! Jacopo Scott Gray wrote: > Thanks Jacopo > > I only ask because I tried doing a Bom simulation for 1 pant and the result > showed I would need 13 metres of fabric, I haven't looked at it too closely > yet however. > > Regards > Scott > > -----Original Message----- > From: [hidden email] [mailto:[hidden email]] > On Behalf Of Jacopo Cappellato > Sent: Sunday, 16 April 2006 6:35 p.m. > To: OFBiz Users / Usage Discussion > Subject: Re: [OFBiz] Users - Decimal quantity on orders > > Hi Scott, > > BOM quantities are of course numbers with decimals. > > Jacopo > > Scott Gray wrote: >> Hi David >> >> I assume this is also the case for BOM quantities? We manufacture >> apparel and i can't see how we could do without decimal quantities (ie >> Elastic Pant requires 1.3 metres of fabric) >> >> Regards >> Scott >> > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: Users - Decimal quantity on orders
|
|
In reply to this post by David E. Jones
David, Si,
Thanks for your answers and sorry for my late response. I'm on holidays next week and I will test what you told me when I come back. Have a nice week. Jean-Luc. David E. Jones wrote: >Si, Jean-Luc, > >The original intent of the quantity in the ShoppingCart and the OrderItem was to use a decimal number and allow for non-integral quantities. Over time we ran into a few issues and found this to not be the best idea. Some of the code has been updated to only allow for integer values for the quantity field, but it is still a decimal value in the database. > >For things that need an amount like this specified we are using the "amount" field. There is a flag on the Product entity to specify whether or not the product should ask for an amount in addition to the quantity (for example: 8 2x4s, 8.5ft each, quantity=8, amount=8.5). The field on the OrderItem where the amount goes is called "selectedAmount". > >-David > > >Si Chen wrote: > > >>What happens when you try to do this? The field is a decimal, so it >>should be OK. Si >> >>mjeanluc wrote: >> >> >>>Hi, >>> >>>For the moment, we can't make an order item entry with decimal quantity. >>>Is there a reason of that ? and is there another solution to manage >>>decmal quantity on orders ? >>> >>>Thanks for your answers. >>> >>>Jean-Luc. >>> >>>_______________________________________________ >>>Users mailing list >>>[hidden email] >>>http://lists.ofbiz.org/mailman/listinfo/users >>> >>> >>> >>> >>> >> >>_______________________________________________ >>Users mailing list >>[hidden email] >>http://lists.ofbiz.org/mailman/listinfo/users >> >> > >_______________________________________________ >Users mailing list >[hidden email] >http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |