You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Dave Tenerowicz <dt...@salmonllc.com> on 2007/09/05 23:57:10 UTC
Cannot capture payments against invoices
It appears that the (new) capture link on Billing Account | Invoices
does not work.
I have created Orders, with paymentMethod of EXT_BILLACT. The Order has
been packed and shipped. I see that the Customer Billing Account balance
has been properly decremented, and on the Invoices tab under Billing
Account I see the invoice record, with a capture button on the same
line. An OrderPaymentPreference record exists - created properly with
PaymethType=EXT_BILLACT, and no PaymentMethodId
When I click the Capture button no payment is applied.
Anyone have any idea what is wrong here??
Using rev# 571273
Thanks!
-Dave
I see the following in the log:
--snip--
007-09-05 17:53:06,108 (default-invoker-Thread-588731)
[PaymentGatewayServices.java:1692:ERROR] ---- exception report
---------------------------------------------------------- Exception:
org.ofbiz.entity.GenericEntityException Message: Could not refresh
value, new value not found for:
[GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Could not refresh value, new
value not found for:
[GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
org.ofbiz.entity.GenericEntity.refreshFromValue(GenericEntity.java:202)
org.ofbiz.entity.GenericDelegator.refresh(GenericDelegator.java:901)
org.ofbiz.entity.GenericDelegator.refresh(GenericDelegator.java:887)
org.ofbiz.entity.GenericValue.refresh(GenericValue.java:124)
org.ofbiz.accounting.payment.PaymentGatewayServices.processAuthResult(PaymentGatewayServices.java:1690)
sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:335)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:210)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
2007-09-05 17:53:06,108 (default-invoker-Thread-588731) [
ServiceDispatcher.java:410:ERROR] Service Error [processAuthResult]:
Could not refresh value, new value not found for:
[GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
2007-09-05 17:53:06,108 (default-invoker-Thread-588731) [
TransactionUtil.java:255:ERROR] ---- exception report
----------------------------------------------------------
[TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack
Trace ---- stack trace
---------------------------------------------------------------
java.lang.Exception: Stack Trace
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:254)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:236)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:414)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:210)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------
-- end--
--
Dave Tenerowicz
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: Cannot capture payments against invoices
Posted by Dave Tenerowicz <dt...@salmonllc.com>.
Thanks Jacopo.
What service should we use to apply the payment to the billing account?
I assume we need to do an authorization on the payment record? Or will
the capture button initiate both a auth and a capture?
Dave
Jacopo Cappellato wrote:
> Hi Dave,
>
> you have to manually create a payment and associate ('apply') it to
> the billing account; after this is done you'll see the newly created
> payment under the billing account->payments tab and the "capture" link
> will work.
>
> Jacopo
>
> Dave Tenerowicz wrote:
>> It appears that the (new) capture link on Billing Account | Invoices
>> does not work.
>> I have created Orders, with paymentMethod of EXT_BILLACT. The Order
>> has been packed and shipped. I see that the Customer Billing Account
>> balance has been properly decremented, and on the Invoices tab under
>> Billing Account I see the invoice record, with a capture button on
>> the same line. An OrderPaymentPreference record exists - created
>> properly with PaymethType=EXT_BILLACT, and no PaymentMethodId
>>
>> When I click the Capture button no payment is applied.
>> Anyone have any idea what is wrong here??
>> Using rev# 571273
>>
>> Thanks!
>> -Dave
>>
>> I see the following in the log:
>> --snip--
>> 007-09-05 17:53:06,108 (default-invoker-Thread-588731)
>> [PaymentGatewayServices.java:1692:ERROR] ---- exception report
>> ---------------------------------------------------------- Exception:
>> org.ofbiz.entity.GenericEntityException Message: Could not refresh
>> value, new value not found for:
>> [GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
>> 03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
>> 03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
>> 03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
>> 03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
>> 03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
>> ---- stack trace
>> ---------------------------------------------------------------
>> org.ofbiz.entity.GenericEntityException: Could not refresh value, new
>> value not found for:
>> [GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
>> 03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
>> 03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
>> 03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
>> 03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
>> 03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
>> org.ofbiz.entity.GenericEntity.refreshFromValue(GenericEntity.java:202)
>> org.ofbiz.entity.GenericDelegator.refresh(GenericDelegator.java:901)
>> org.ofbiz.entity.GenericDelegator.refresh(GenericDelegator.java:887)
>> org.ofbiz.entity.GenericValue.refresh(GenericValue.java:124)
>> org.ofbiz.accounting.payment.PaymentGatewayServices.processAuthResult(PaymentGatewayServices.java:1690)
>> sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> java.lang.reflect.Method.invoke(Method.java:597)
>> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91)
>> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:335)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:210)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
>> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
>> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
>> java.lang.Thread.run(Thread.java:619)
>> --------------------------------------------------------------------------------
>>
>> 2007-09-05 17:53:06,108 (default-invoker-Thread-588731) [
>> ServiceDispatcher.java:410:ERROR] Service Error [processAuthResult]:
>> Could not refresh value, new value not found for:
>> [GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
>> 03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
>> 03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
>> 03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
>> 03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
>> 03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
>>
>> 2007-09-05 17:53:06,108 (default-invoker-Thread-588731) [
>> TransactionUtil.java:255:ERROR] ---- exception report
>> ----------------------------------------------------------
>> [TransactionUtil.rollback] Exception: java.lang.Exception Message:
>> Stack Trace ---- stack trace
>> ---------------------------------------------------------------
>> java.lang.Exception: Stack Trace
>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:254)
>> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:236)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:414)
>> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:210)
>> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
>> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
>> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
>> java.lang.Thread.run(Thread.java:619)
>> --------------------------------------------------------------------------------
>>
>>
>> -- end--
>>
>
>
>
--
Dave Tenerowicz
dtenerowicz@salmonllc.com
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
Re: Cannot capture payments against invoices
Posted by Jacopo Cappellato <ti...@sastau.it>.
Hi Dave,
you have to manually create a payment and associate ('apply') it to the
billing account; after this is done you'll see the newly created payment
under the billing account->payments tab and the "capture" link will work.
Jacopo
Dave Tenerowicz wrote:
> It appears that the (new) capture link on Billing Account | Invoices
> does not work.
> I have created Orders, with paymentMethod of EXT_BILLACT. The Order has
> been packed and shipped. I see that the Customer Billing Account balance
> has been properly decremented, and on the Invoices tab under Billing
> Account I see the invoice record, with a capture button on the same
> line. An OrderPaymentPreference record exists - created properly with
> PaymethType=EXT_BILLACT, and no PaymentMethodId
>
> When I click the Capture button no payment is applied.
> Anyone have any idea what is wrong here??
> Using rev# 571273
>
> Thanks!
> -Dave
>
> I see the following in the log:
> --snip--
> 007-09-05 17:53:06,108 (default-invoker-Thread-588731)
> [PaymentGatewayServices.java:1692:ERROR] ---- exception report
> ---------------------------------------------------------- Exception:
> org.ofbiz.entity.GenericEntityException Message: Could not refresh
> value, new value not found for:
> [GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
> 03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
> 03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
> 03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
> 03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
> 03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.entity.GenericEntityException: Could not refresh value, new
> value not found for:
> [GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
> 03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
> 03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
> 03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
> 03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
> 03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
> org.ofbiz.entity.GenericEntity.refreshFromValue(GenericEntity.java:202)
> org.ofbiz.entity.GenericDelegator.refresh(GenericDelegator.java:901)
> org.ofbiz.entity.GenericDelegator.refresh(GenericDelegator.java:887)
> org.ofbiz.entity.GenericValue.refresh(GenericValue.java:124)
> org.ofbiz.accounting.payment.PaymentGatewayServices.processAuthResult(PaymentGatewayServices.java:1690)
> sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:597)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:91)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:53)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:335)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:210)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
> 2007-09-05 17:53:06,108 (default-invoker-Thread-588731) [
> ServiceDispatcher.java:410:ERROR] Service Error [processAuthResult]:
> Could not refresh value, new value not found for:
> [GenericEntity:OrderPaymentPreference][createdByUserLogin,system(java.lang.String)][createdDate,2007-09-03
> 03:00:49.871(java.sql.Timestamp)][createdStamp,2007-09-03
> 03:00:50.027(java.sql.Timestamp)][createdTxStamp,2007-09-03
> 03:00:02.324(java.sql.Timestamp)][lastUpdatedStamp,2007-09-03
> 03:01:48.699(java.sql.Timestamp)][lastUpdatedTxStamp,2007-09-03
> 03:00:02.324(java.sql.Timestamp)][maxAmount,69.9(java.lang.Double)][needsNsfRetry,N(java.lang.String)][orderId,WSCO10204(java.lang.String)][orderPaymentPreferenceId,10224(java.lang.String)][overflowFlag,N(java.lang.String)][paymentMethodId,10071(java.lang.String)][paymentMethodTypeId,CREDIT_CARD(java.lang.String)][presentFlag,N(java.lang.String)][processAttempt,1(java.lang.Long)][statusId,PAYMENT_AUTHORIZED(java.lang.String)]
>
> 2007-09-05 17:53:06,108 (default-invoker-Thread-588731) [
> TransactionUtil.java:255:ERROR] ---- exception report
> ----------------------------------------------------------
> [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack
> Trace ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Stack Trace
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:254)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:236)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:414)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:210)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:136)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:70)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
> java.lang.Thread.run(Thread.java:619)
> --------------------------------------------------------------------------------
>
>
> -- end--
>