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

Reply via email to