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