Dev - POS sale error...(PaymentApplication invoice creation)

[Ray Barlow]

Hi,

Just wondering if I'm alone here or not but I'm getting an error, listed
below, whilst completing a sale through POS.

It's a very simple '12345' SKU purchase with quantity of 1 and paid in
cash @ 20.00 which should produce change as the product is only 15.99.

I would be interested in knowing why this appears as well:
997835[                Log.java:103:WARN ] Create Payment Application:
Amount to apply [20.0] is greater than the outstanding amount [0.0] of
the invoice [10013]. Creating Payment Application for outstanding amount
[0.0] instead.

Ray

--------------------------------------------------------------------------------------------------------------
996653[ContentManagementServices.java:1603:INFO ] In
updateSubscriptionByOrder service with orderId: RS10093
996683[   GenericDelegator.java:2302:WARN ] Tried to put a value of the
OrderHeader entity in the BY PRIMARY KEY cache but this entity has
never-cache set to true, not caching.
996703[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.06,since last(Begin):0.06]] - 'POSDispatcher /
updateSubscriptionByOrder'
996713[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.13,since last(Begin):0.13]] - 'POSDispatcher / changeOrderStatus'
996773[      EntityEcaRule.java:122:INFO ] Running Entity ECA Service:
checkCreateOrderRequirement, triggered by rule on Entity: OrderItem
996783[   PrimaryKeyFinder.java:132:INFO ] Returning null because found
incomplete primary key in find: [GenericEntity:Product]
996793[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.02,since last(Begin):0.02]] - 'entity-default /
checkCreateOrderRequirement'
996814[     ServiceEcaRule.java:118:INFO ] Got false for condition:
[null][][statusId][equals][null][ITEM_CANCELLED][true][String][]
996814[     ServiceEcaRule.java:118:INFO ] Got false for condition:
[null][][statusId][equals][null][ITEM_COMPLETED][true][String][]
996814[     ServiceEcaRule.java:134:INFO ] Running Service ECA Service:
checkOrderItemStatus, triggered by rule on Service: changeOrderItemStatus
996864[      OrderServices.java:1771:WARN ] Tried to setOrderStatus with
the same statusId [ ORDER_APPROVED ] for order with ID [ RS10093 ]
996864[     ServiceEcaRule.java:118:INFO ] Got false for condition:
[null][][statusId][equals][null][ORDER_CANCELLED][true][String][]
996864[     ServiceEcaRule.java:118:INFO ] Got false for condition:
[null][][statusId][equals][null][ORDER_COMPLETED][true][String][]
996874[ServiceEcaCondition.java:137:WARN ] From Field (orderTypeId) is
not found in context for changeOrderStatus, defaulting to null.
996874[     ServiceEcaRule.java:118:INFO ] Got false for condition:
[null][][orderTypeId][equals][null][SALES_ORDER][true][String][]
996874[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.02,since last(Begin):0.02]] - 'POSDispatcher / changeOrderStatus'
996874[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.05,since last(Begin):0.05]] - 'POSDispatcher /
checkOrderItemStatus'
996874[     ServiceEcaRule.java:134:INFO ] Running Service ECA Service:
checkDigitalItemFulfillment, triggered by rule on Service:
changeOrderItemStatus
996914[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.03,since last(Begin):0.03]] - 'POSDispatcher /
checkDigitalItemFulfillment'
996924[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.201,since last(Begin):0.201]] - 'POSDispatcher /
changeOrderItemStatus'
996944[     CheckOutHelper.java:988:INFO ] Face-To-Face Sale - RS10093
997174[            UtilXml.java:242:DEBUG] XML Read 0.08s:
file:/U:/Work/OFBiz/ofbiz/applications/accounting/script/org/ofbiz/accounting/payment/PaymentServices.xml

997194[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.1,since last(Begin):0.1]] - 'POSDispatcher / createPayment'
997204[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.14,since last(Begin):0.14]] - 'POSDispatcher /
createPaymentFromPreference'
997304[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.01,since last(Begin):0.01]] - 'POSDispatcher / createPayment'
997314[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.09,since last(Begin):0.09]] - 'POSDispatcher /
createPaymentFromPreference'
997545[            UtilXml.java:242:DEBUG] XML Read 0.111s:
file:/U:/Work/OFBiz/ofbiz/applications/accounting/script/org/ofbiz/accounting/invoice/InvoiceServices.xml

997565[FlexibleStringExpander.java:323:WARN ] Could not find value in
environment for the name [partyAcctgPreference], inserting nothing.
997565[                Log.java:103:INFO ] In getNextInvoiceId partyId
is [Company], partyAcctgPreference:
997565[                Log.java:103:INFO ] In createInvoice sequence
enum INVSQ_STANDARD
997575[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.02,since last(Begin):0.02]] - 'POSDispatcher / getNextInvoiceId'
997595[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.161,since last(Begin):0.161]] - 'POSDispatcher / createInvoice'
997635[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.03,since last(Begin):0.03]] - 'POSDispatcher / createInvoiceRole'
997645[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.01,since last(Begin):0.01]] - 'POSDispatcher / createInvoiceRole'
997665[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.02,since last(Begin):0.02]] - 'POSDispatcher / createInvoiceRole'
997685[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.02,since last(Begin):0.02]] - 'POSDispatcher / createInvoiceRole'
997695[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.01,since last(Begin):0.01]] - 'POSDispatcher / createInvoiceRole'
997725[  ServiceDispatcher.java:447:DEBUG] [[Sync service finished-
total:0.03,since last(Begin):0.03]] - 'POSDispatcher / createInvoiceRole'
997775[      GenericEntity.java:393:ERROR] In entity field set the value
passed in [java.math.BigDecimal] is not compatible with the Java type of
the field [Double]
997785[      GenericEntity.java:393:ERROR] In entity field set the value
passed in [java.math.BigDecimal] is not compatible with the Java type of
the field [Double]
997835[                Log.java:103:WARN ] Create Payment Application:
Amount to apply [20.0] is greater than the outstanding amount [0.0] of
the invoice [10013]. Creating Payment Application for outstanding amount
[0.0] instead.
997835[      GenericEntity.java:393:ERROR] In entity field set the value
passed in [java.lang.String] is not compatible with the Java type of the
field [Double]
997865[   GenericDelegator.java:588:ERROR]
---- exception report
----------------------------------------------------------
Failure in create operation for entity [PaymentApplication]:
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(while inserting:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
public.PAYMENT_APPLICATION (PAYMENT_APPLICATION_ID, PAYMENT_ID,
INVOICE_ID, INVOICE_ITEM_SEQ_ID, BILLING_ACCOUNT_ID, TO_PAYMENT_ID,
TAX_AUTH_GEO_ID, AMOUNT_APPLIED, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: column "amount_applied" is of type
numeric but expression is of type character varying))). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(while inserting:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
public.PAYMENT_APPLICATION (PAYMENT_APPLICATION_ID, PAYMENT_ID,
INVOICE_ID, INVOICE_ITEM_SEQ_ID, BILLING_ACCOUNT_ID, TO_PAYMENT_ID,
TAX_AUTH_GEO_ID, AMOUNT_APPLIED, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: column "amount_applied" is of type
numeric but expression is of type character varying)))
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(while inserting:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
public.PAYMENT_APPLICATION (PAYMENT_APPLICATION_ID, PAYMENT_ID,
INVOICE_ID, INVOICE_ITEM_SEQ_ID, BILLING_ACCOUNT_ID, TO_PAYMENT_ID,
TAX_AUTH_GEO_ID, AMOUNT_APPLIED, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: column "amount_applied" is of type
numeric but expression is of type character varying)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:140)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)

org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570)
org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928)
org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568)
org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115)
org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97)
org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86)

org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.accounting.invoice.InvoiceServices.createInvoiceForOrder(InvoiceServices.java:570)

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:324)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101)

org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63)

org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.order.order.OrderChangeHelper.createOrderInvoice(OrderChangeHelper.java:299)

org.ofbiz.order.order.OrderChangeHelper.completeOrder(OrderChangeHelper.java:130)

org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:990)

org.ofbiz.order.shoppingcart.CheckOutHelper.processPayment(CheckOutHelper.java:766)

org.ofbiz.pos.PosTransaction.processSale(PosTransaction.java:634)
org.ofbiz.pos.event.PaymentEvents.processSale(PaymentEvents.java:316)
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:324)
org.ofbiz.pos.config.ButtonEventConfig.invoke(ButtonEventConfig.java:220)
org.ofbiz.pos.config.ButtonEventConfig.invokeButtonEvent(ButtonEventConfig.java:117)

org.ofbiz.pos.component.PosButton$1.construct(PosButton.java:132)
net.xoetrope.xui.helper.SwingWorker$2.run(Unknown Source)
java.lang.Thread.run(Thread.java:534)
org.ofbiz.entity.GenericEntityException: while inserting:
[GenericEntity:PaymentApplication][amountApplied,0.0(java.lang.String)][billingAccountId,null()][createdStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][createdTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][invoiceId,10013(java.lang.String)][lastUpdatedStamp,2006-03-13
17:03:40.977(java.sql.Timestamp)][lastUpdatedTxStamp,2006-03-13
17:03:40.496(java.sql.Timestamp)][paymentApplicationId,10013(java.lang.String)][paymentId,10014(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
public.PAYMENT_APPLICATION (PAYMENT_APPLICATION_ID, PAYMENT_ID,
INVOICE_ID, INVOICE_ITEM_SEQ_ID, BILLING_ACCOUNT_ID, TO_PAYMENT_ID,
TAX_AUTH_GEO_ID, AMOUNT_APPLIED, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: column "amount_applied" is of type
numeric but expression is of type character varying))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:195)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:137)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)

org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570)
org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73)
org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928)
org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568)
org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115)
org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97)
org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86)

org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61)

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Jacques Le Roux]

Hi Ray,

I tried something like that but got no pb.

Jacques

----- Original Message -----
From: "Ray" <[hidden email]>
To: "OFBiz Project Development Discussion" <[hidden email]>
Sent: Monday, March 13, 2006 6:46 PM
Subject: [OFBiz] Dev - POS sale error...(PaymentApplication invoice creation)

> Hi,
>
> Just wondering if I'm alone here or not but I'm getting an error, listed
> below, whilst completing a sale through POS.
>
> It's a very simple '12345' SKU purchase with quantity of 1 and paid in
> cash @ 20.00 which should produce change as the product is only 15.99.
>
> I would be interested in knowing why this appears as well:
> 997835[                Log.java:103:WARN ] Create Payment Application:
> Amount to apply [20.0] is greater than the outstanding amount [0.0] of
> the invoice [10013]. Creating Payment Application for outstanding amount
> [0.0] instead.
>
> Ray
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Leon Torres-2]

Hm, I added that log message last week. The bug might be unrelated though, but I
could probably trace it since I'm recently familiar with the code.

Can we get steps to reproduce it, including database used? I'll look at it
tomorrow unless someone else wants to tackle it.

- Leon


Jacques Le Roux wrote:

> Hi Ray,
>
> I tried something like that but got no pb.
>
> Jacques
>
> ----- Original Message -----
> From: "Ray" <[hidden email]>
> To: "OFBiz Project Development Discussion" <[hidden email]>
> Sent: Monday, March 13, 2006 6:46 PM
> Subject: [OFBiz] Dev - POS sale error...(PaymentApplication invoice creation)
>
>
>
>>Hi,
>>
>>Just wondering if I'm alone here or not but I'm getting an error, listed
>>below, whilst completing a sale through POS.
>>
>>It's a very simple '12345' SKU purchase with quantity of 1 and paid in
>>cash @ 20.00 which should produce change as the product is only 15.99.
>>
>>I would be interested in knowing why this appears as well:
>>997835[                Log.java:103:WARN ] Create Payment Application:
>>Amount to apply [20.0] is greater than the outstanding amount [0.0] of
>>the invoice [10013]. Creating Payment Application for outstanding amount
>>[0.0] instead.
>>
>>Ray
>>
>
>  
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Andrew Sykes]

Ray,

I remember seeing this quite a while back.

How old is your version of OFBiz?

Andrew
--
Kind Regards
Andrew Sykes <[hidden email]>
Sykes Development Ltd
http://www.sykesdevelopment.com

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Ray Barlow]

Thanks for all the comments.

If it's working for others that's good to hear. I'm testing against SVN
as of yesterday, but not that fairly as there are some minor mods to the
source and the seed data could always be a little stale (it's hard to
tell). I'll go back through and double check against a completely clean
version and come back if it persists.

Ray


Andrew Sykes wrote:

>Ray,
>
>I remember seeing this quite a while back.
>
>How old is your version of OFBiz?
>
>Andrew
>  
>
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Hans Bakker]

Ray,

you may want to look at a newer version of this service with much more
extensive validation checking in the invoiceServices.java called
updatePaymentApplicationBd....

--
Regards,
Hans Bakker
ANT Websystems Co.,Ltd (http://www.antwebsystems.com)

If you want to verify that this message really originates from
from the above person, download the public key from:
http://www.antwebsystems.com/hbakkerAntwebsystems.asc



On Tuesday 14 March 2006 17:16, Ray wrote:

> Thanks for all the comments.
>
> If it's working for others that's good to hear. I'm testing against SVN
> as of yesterday, but not that fairly as there are some minor mods to the
> source and the seed data could always be a little stale (it's hard to
> tell). I'll go back through and double check against a completely clean
> version and come back if it persists.
>
> Ray
>
> Andrew Sykes wrote:
> >Ray,
> >
> >I remember seeing this quite a while back.
> >
> >How old is your version of OFBiz?
> >
> >Andrew
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev

--
Regards,
Hans Bakker
ANT Websystems Co.,Ltd (http://www.antwebsystems.com)

If you want to verify that this message really originates from
from the above person, download the public key from:
http://www.antwebsystems.com/hbakkerAntwebsystems.asc

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev