"Offline" CC transactions

[Iain Fogg]

It's going to take me some time to get to the point where I can get
OFBiz to talk directly to Australian CC companies for authorisation, so...

How do I configure/use OFBiz in the following scenario:

1. Customer buys item(s) in store and wants to pay with CC
2. I process the CC transaction on the (independent CC terminal provided
by my CC company - old school, I know :-)
3. I tell the POS application that the customer paid by CC

If I'm not doing any credit card processing with OFBiz (at this stage)
can I configure it to not bother with card details, yet still update the
GL accounts to track credit card sales (and refunds). Maybe this is not
practical?

If this is not an option, then I think I need to run out and buy an MSR,
'cause my staff will revolt if they've gotta type in credit card numbers
and expiry dates just to complete a POS sale.

I had a look at the manual CC tx service but I'm not sure that is the
one I should be using - can someone advise?

Help appreciated.

Cheers, Iain


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/536 - Release Date: 16/11/2006

[Iain Fogg]

I'm getting a tad frustrated with this since I suspect it is some basic
bit of config I've forgotten/messed up, but my progress to date....

I managed to work out that I need to set my store's payment type for
credit cards to PRDS_PAY_EXTERNAL. This now allows me to process the
credit card transaction using my independent merchant terminal, and then
I get prompted for the authorisation reference number in POS. However,
an exception is generated when I finish the transaction.

It is generating a null pointer exception in processAuthResult
(org.ofbiz.accounting.payment/PaymentGateway/Service.java - line 2820).
The reason is pretty simple. The OrderPaymentPreference record created
for the transaction has a paymentMethodTypeId = 'CREDIT_CARD' but the
paymentMethodId = NULL.

Consequently, no PaymentMethod would be retrieved and the string
comparison against "CREDIT_CARD" fails.

Any pointers? I'm finding it hard to believe that I'm the first person
who wanted to use OFBiz without online credit card processing features
turned on :-)

Cheers, Iain

Iain Fogg wrote:

> It's going to take me some time to get to the point where I can get
> OFBiz to talk directly to Australian CC companies for authorisation,
> so...
>
> How do I configure/use OFBiz in the following scenario:
>
> 1. Customer buys item(s) in store and wants to pay with CC
> 2. I process the CC transaction on the (independent CC terminal
> provided by my CC company - old school, I know :-)
> 3. I tell the POS application that the customer paid by CC
>
> If I'm not doing any credit card processing with OFBiz (at this stage)
> can I configure it to not bother with card details, yet still update
> the GL accounts to track credit card sales (and refunds). Maybe this
> is not practical?
>
> If this is not an option, then I think I need to run out and buy an
> MSR, 'cause my staff will revolt if they've gotta type in credit card
> numbers and expiry dates just to complete a POS sale.
>
> I had a look at the manual CC tx service but I'm not sure that is the
> one I should be using - can someone advise?
>
> Help appreciated.
>
> Cheers, Iain
>
>

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/536 - Release Date: 16/11/2006

[Iain Fogg]

I think I fixed it. I protected the extraction of the
paymentMethodTypeId with a test for null (line 1554  in
PaymentGatewayServices.java). I'll test a bit more to see if this breaks
anything (it shouldn't), but I'm still concerned that I needed to do
this at all.

One logical conclusion is that I'm the first person to ever want to
process my credit cards externally in a POS environment, and I'm
struggling with that idea. The other possible conclusion (see below) is
that I've screwed up my config somewhere else, and I'd love someone to
tell me what I did wrong...

Cheers, Iain

Iain Fogg wrote:

> I'm getting a tad frustrated with this since I suspect it is some
> basic bit of config I've forgotten/messed up, but my progress to date....
>
> I managed to work out that I need to set my store's payment type for
> credit cards to PRDS_PAY_EXTERNAL. This now allows me to process the
> credit card transaction using my independent merchant terminal, and
> then I get prompted for the authorisation reference number in POS.
> However, an exception is generated when I finish the transaction.
>
> It is generating a null pointer exception in processAuthResult
> (org.ofbiz.accounting.payment/PaymentGateway/Service.java - line
> 2820). The reason is pretty simple. The OrderPaymentPreference record
> created for the transaction has a paymentMethodTypeId = 'CREDIT_CARD'
> but the paymentMethodId = NULL.
>
> Consequently, no PaymentMethod would be retrieved and the string
> comparison against "CREDIT_CARD" fails.
>
> Any pointers? I'm finding it hard to believe that I'm the first person
> who wanted to use OFBiz without online credit card processing features
> turned on :-)
>
> Cheers, Iain
>
> Iain Fogg wrote:
>> It's going to take me some time to get to the point where I can get
>> OFBiz to talk directly to Australian CC companies for authorisation,
>> so...
>>
>> How do I configure/use OFBiz in the following scenario:
>>
>> 1. Customer buys item(s) in store and wants to pay with CC
>> 2. I process the CC transaction on the (independent CC terminal
>> provided by my CC company - old school, I know :-)
>> 3. I tell the POS application that the customer paid by CC
>>
>> If I'm not doing any credit card processing with OFBiz (at this
>> stage) can I configure it to not bother with card details, yet still
>> update the GL accounts to track credit card sales (and refunds).
>> Maybe this is not practical?
>>
>> If this is not an option, then I think I need to run out and buy an
>> MSR, 'cause my staff will revolt if they've gotta type in credit card
>> numbers and expiry dates just to complete a POS sale.
>>
>> I had a look at the manual CC tx service but I'm not sure that is the
>> one I should be using - can someone advise?
>>
>> Help appreciated.
>>
>> Cheers, Iain
>>
>>
>
>
>

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/536 - Release Date: 16/11/2006

[David E Jones-2]

On Nov 17, 2006, at 10:37 PM, Iain Fogg wrote:

> Any pointers? I'm finding it hard to believe that I'm the first  
> person who wanted to use OFBiz without online credit card  
> processing features turned on :-)

Don't be too surprised... chances are this is the case. The POS  
application is still pretty young and it was written for companies  
with larger deployments that always have this sort of thing streamlined.

So, you'd probably have to make code and UI changes in order to  
support this.

-David

[Iain Fogg]

David,

Thanks. I think it turned out to be a bug in the accounting code (see
previous message). At the very least, the accounting code didn't account
for a null pointer, so even if there is still a problem with the POS
code at least accounting is a little bit more robust.

Cheers, Iain

David E Jones wrote:

>
> On Nov 17, 2006, at 10:37 PM, Iain Fogg wrote:
>
>> Any pointers? I'm finding it hard to believe that I'm the first
>> person who wanted to use OFBiz without online credit card processing
>> features turned on :-)
>
> Don't be too surprised... chances are this is the case. The POS
> application is still pretty young and it was written for companies
> with larger deployments that always have this sort of thing streamlined.
>
> So, you'd probably have to make code and UI changes in order to
> support this.
>
> -David
>
>
>
> --No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.409 / Virus Database: 268.14.6/536 - Release Date:
> 16/11/2006
>
>

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/536 - Release Date: 16/11/2006

[Jacques Le Roux]

Hi Iain,

Can you provide a patch for this please or is it only this fix

>I think I fixed it. I protected the extraction of the
>paymentMethodTypeId with a test for null (line 1554  in
>PaymentGatewayServices.java). I'll test a bit more to see if this breaks
>anything (it shouldn't), but I'm still concerned that I needed to do
>this at all.

to be applied  ?

Thanks

Jacques
From: "Iain Fogg" <[hidden email]>

> David,
>
> Thanks. I think it turned out to be a bug in the accounting code (see
> previous message). At the very least, the accounting code didn't account
> for a null pointer, so even if there is still a problem with the POS
> code at least accounting is a little bit more robust.
>
> Cheers, Iain
>
> David E Jones wrote:
> >
> > On Nov 17, 2006, at 10:37 PM, Iain Fogg wrote:
> >
> >> Any pointers? I'm finding it hard to believe that I'm the first
> >> person who wanted to use OFBiz without online credit card processing
> >> features turned on :-)
> >
> > Don't be too surprised... chances are this is the case. The POS
> > application is still pretty young and it was written for companies
> > with larger deployments that always have this sort of thing streamlined.
> >
> > So, you'd probably have to make code and UI changes in order to
> > support this.
> >
> > -David