I don't think the code in webpos is complete for a lookup on good_identification. The form invokes additem in shoppingcartevents and that method requires the passing of a product_id - it doesn't appear to do any kind of lookup. It seems reasonable to do the lookup first and then call the additem method with the correct product_id parameter.
Rick --- On Thu, 12/4/08, Vince M. Clark <[EMAIL PROTECTED]> wrote: > From: Vince M. Clark <[EMAIL PROTECTED]> > Subject: Re: webpos - how to over ride price? > To: user@ofbiz.apache.org > Date: Thursday, December 4, 2008, 3:37 PM > I saw that. The value is for the SKU. I verified that value > in the Product ID tab. There is definitely a line for SKU > with that value. So not sure why it isn't finding it. > > ----- Original Message ----- > From: "Scott Gray" <[EMAIL PROTECTED]> > To: user@ofbiz.apache.org > Sent: Thursday, December 4, 2008 2:50:35 PM (GMT-0700) > America/Denver > Subject: Re: webpos - how to over ride price? > > If I were you I would focus on the log line directly above > it:2008-12-04 > 15:12:25,096 (TP-Processor13) [ > WebPosTransaction.java:180:INFO ] Item not > found 67890 > That means that for whatever reason the item isn't > being found in the cart > hence no price modify. > > Regards > Scott > > 2008/12/5 Vince M. Clark <[EMAIL PROTECTED]> > > > I realized after I posted this that it was just a > warning. The process > > seems to complete, but the price is definitely not > modified. I'll keep > > digging. > > > > ----- Original Message ----- > > From: "David E Jones" > <[EMAIL PROTECTED]> > > To: user@ofbiz.apache.org > > Sent: Thursday, December 4, 2008 2:30:30 PM (GMT-0700) > America/Denver > > Subject: Re: webpos - how to over ride price? > > > > > > Are you sure that's causing this problem? > That's just a warning > > message that doesn't stop the code from running > (part of the effort to > > move from Double to BigDecimal, for which there is a > branch going > > right now). > > > > -David > > > > > > On Dec 4, 2008, at 2:14 PM, Vince M. Clark wrote: > > > > > I found the error causing the Modify Price > process to fail in webpos. > > > > > > > > > 2008-12-04 15:12:25,096 (TP-Processor13) [ > WebPosTransaction.java: > > > 175:INFO ] Modify item price 67890/22.0 > > > 2008-12-04 15:12:25,096 (TP-Processor13) [ > WebPosTransaction.java: > > > 180:INFO ] Item not found 67890 2008-12-04 > 15:12:25,105 (TP- > > > Processor13) [ EntityExpr.java:267:WARN ] ---- > exception report > > > > ---------------------------------------------------------- > =-=-=-=-=- > > > =-=-=-= DATABASE TYPE ERROR in EntityExpr > =-=-=-=-=-=-=-=-= In > > > entity field > [TaxAuthorityRateProduct.minItemPrice] set the value > > > passed in [java.math.BigDecimal] is not > compatible with the Java > > > type of the field [Double] Exception: > java.lang.Exception Message: > > > Location of database type error ---- stack trace > > > > ------------------------------------------------/-------------- > > > > java.lang.Exception: Location of database type > error > > > > org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java: > > > > 267) > > > org > > > > .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java: > > > > 167) > > > org > > > .ofbiz > > > .entity > > > > .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java: > > > > 54) > > > org > > > > .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java: > > > > 170) > > > org > > > .ofbiz > > > .entity > > > > .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java: > > > > 67) > > > org > > > .ofbiz > > > .entity > > > .condition > > > .EntityConditionListBase > > > .makeWhereString(EntityConditionListBase.java:89) > > > > org > > > .ofbiz > > > .entity > > > > .datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java: > > > > 676) > > > org > > > .ofbiz > > > .entity > > > .datasource > > > > .GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java: > > > > 140) > org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java: > > > > 2273) > > > > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java: > > > > 2314) > > > org > > > .ofbiz > > > .accounting > > > .tax > > > > .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java: > > > > 309) > > > org > > > .ofbiz > > > .accounting > > > .tax > > > > .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java: > > > > 182) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > sun > > > .reflect > > > > .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > > > sun > > > .reflect > > > .DelegatingMethodAccessorImpl > > > .invoke(DelegatingMethodAccessorImpl.java:25) > > > java.lang.reflect.Method.invoke(Method.java:585) > > > org > > > .ofbiz > > > .service > > > > .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java: > > > > 96) > > > org > > > .ofbiz > > > > .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java: > > > > 54) > > > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: > > > > 384) > > > > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: > > > > 213) > > > > org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java: > > > > 149) > > > org > > > .ofbiz > > > .order > > > > .shoppingcart.CheckOutHelper.getTaxAdjustments(CheckOutHelper.java: > > > > 859) > > > org > > > .ofbiz > > > > .order.shoppingcart.CheckOutHelper.calcAndAddTax(CheckOutHelper.java: > > > > 764) > > > > > > ----- Original Message ----- > > > From: "Scott Gray" > <[EMAIL PROTECTED]> > > > To: user@ofbiz.apache.org > > > Sent: Wednesday, December 3, 2008 7:23:13 PM > (GMT-0700) America/Denver > > > Subject: Re: webpos - how to over ride price? > > > > > > oops, I missed the web part and thought we were > talking about the > > > standard > > > pos. > > > Sorry, I don't know much about webpos > > > > > > Regards > > > Scott > > > > > > 2008/12/4 Vince M. Clark > <[EMAIL PROTECTED]> > > > > > >> Nope. The price field on an item is not > editable. If I go to > > >> Manager, then > > >> click on Modify Price I am presented with two > fields, SKU and New > > >> Price. > > >> Selecting an item on the order makes no > difference. If I enter the > > >> product > > >> code, for example GZ-1001, and a new price, > then click Confirm, > > >> nothing > > >> happens. > > >> > > >> Note that I am trying this on > demo.hotwaxmedia.com/webpos. > > >> > > >> ----- Original Message ----- > > >> From: "Scott Gray" > <[EMAIL PROTECTED]> > > >> To: user@ofbiz.apache.org > > >> Sent: Wednesday, December 3, 2008 6:37:30 PM > (GMT-0700) America/ > > >> Denver > > >> Subject: Re: webpos - how to over ride price? > > > >> > > >> It should work, a quick look at the code says > that an item needs to > > >> be > > >> selected, a new price entered and then modify > price pressed. > > >> Regards > > >> Scott > > >> > > >> 2008/12/4 Vince M. Clark > <[EMAIL PROTECTED]> > > >> > > >>> I tried going to manager screen and using > "Modify Price". Doesn't > > >>> seem to > > >>> do anything. Is there any way to over > ride prices on the fly? > > >>> > > >> > > > >