Order Qty Increments

[Midhat]

I want that a product may be ordered from a supplier in quantities that are
multiple of 100. like 100,200,300 etc, i set the Order Qty Increment field
to 100 while adding supplier to product, but still i am able to order 150
items. Am i misinterpreting the Order Qty Increment field?

[Si Chen-2]

Yes, you are.  That field means the break point for getting that  
price--ie, you order 100 or more, you get that price.  To do what you  
want, you'd have to set up some kind of Uom scheme, although I'm not  
sure where we are with the implementation of that.

Si


On Jul 21, 2006, at 1:15 AM, Midhat Ali wrote:

> I want that a product may be ordered from a supplier in quantities  
> that are
> multiple of 100. like 100,200,300 etc, i set the Order Qty  
> Increment field
> to 100 while adding supplier to product, but still i am able to  
> order 150
> items. Am i misinterpreting the Order Qty Increment field?

[Alexandre Vaillancourt]

[XML Export from DataSource From SQL server -- error]

Hi!

I'm trying to export data from our MS SQL Server database (2000). With the
export webtool.

On many tables, I get an error like this one:
[13] [xxx] Error when writing AgreementItem:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT DISTINCT AGREEMENT_ID, AGREEMENT_ITEM_SEQ_ID,
AGREEMENT_ITEM_TYPE_ID, CURRENCY_UOM_ID, AGREEMENT_TEXT, AGREEMENT_IMAGE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP
FROM dbo.AGREEMENT_ITEM ORDER BY AGREEMENT_ID ASC, AGREEMENT_ITEM_SEQ_ID ASC
(The text, ntext, or image data type cannot be selected as DISTINCT.)

I've searched the mailing lists about that and the only thing I found is
http://lists.ofbiz.org/pipermail/jira/2006-January/002573.html.

Anyone know if there's a workaround for that? I think you can understand
that I wouldn't want to have to re-enter all my parties, products, etc...

Thanks a lot!

Alexandre Vaillancourt