Re-number credit card batch for settling

Posted by Roxanne on December 5, 2005, 12:40 pm

Please log in for more thread options

Had a problem settling a credit card batch due to duplicate batch number.
Credit card company (paymentech) keeps saying we have to re-number our batch.
Batch is already gone as "settled" on my side. No error came back as
"duplicate". Didn't know till we called processor.

Also, would like duplicate receipt for debit card without a signature line
and without pressing reprint. How to?

Thanks

Posted by Jeff on December 5, 2005, 5:35 pm

Please log in for more thread options

Roxanne,

Make a backup first.

Do it again and store it somewhere else just to be safe.

Contact Paymentech and find out what batch number they are looking for.

*** CAUTION ***
This routine will probably add all transactions together and close as a
single batch SINCE that bad close.

Go into SO Administrator | File | Connect | enter your password.

Go to Query | New | type;

SELECT Max(RequestBatchNumber)+1 FROM VisaNetBatch

Press F5 to run it. Write that number down. That is what RMS assumes to be
your next batch number.

Go to Query | New | type;

UPDATE VisaNetAuthorization SET Status = 0, VisaNetBatchID = Y WHERE Status
= 5

Where Y is the number that Paymentech wants.

Press F5 to run it.

Exit SO Admin and do not save the queries.

Go into SO Manager and close the batch again.

Call Paymentech to see if batch closed properly, if not, restore your
databases and call MS support.
--
*
Had a problem settling a credit card batch due to duplicate batch number.
Credit card company (paymentech) keeps saying we have to re-number our
batch.
Batch is already gone as "settled" on my side. No error came back as
"duplicate". Didn't know till we called processor.

Also, would like duplicate receipt for debit card without a signature line
and without pressing reprint. How to?

Thanks

Posted by Roxanne on December 7, 2005, 7:21 am

Please log in for more thread options

Thanks Jeff...this is certainly helpful. How about the debit card receipt -
need a duplicate without reprinting or choosing signature line..probably
simple as pie.

Quick reference question, you said not to save the query. Does savng a query
cause some kind of problem with some queries? I just used an SQL statement to
delete journals and saved the query and hope this will not be a problem in
the end??

Again, mahalo.

"Roxanne" wrote:

> Had a problem settling a credit card batch due to duplicate batch number.

> Credit card company (paymentech) keeps saying we have to re-number our batch.

> Batch is already gone as "settled" on my side. No error came back as

> "duplicate". Didn't know till we called processor.

> Also, would like duplicate receipt for debit card without a signature line

> and without pressing reprint. How to?

> Thanks

Posted by Jeff on December 7, 2005, 10:08 pm

Please log in for more thread options

Roxanne,

I'd have to look again, but I don't think the signature line is on the Debit
receipt. There is no need for it, if using a pinpad. It is however, on a
credit card receipt.

No easy way of getting two strictly for a debit tender. Others have tried
without success that I'm aware of.

If you wish to save the query, no problem. Just be careful before using it.
Always do a backup first before using it.

--
*
Thanks Jeff...this is certainly helpful. How about the debit card receipt -
need a duplicate without reprinting or choosing signature line..probably
simple as pie.

Quick reference question, you said not to save the query. Does savng a query
cause some kind of problem with some queries? I just used an SQL statement
to
delete journals and saved the query and hope this will not be a problem in
the end??

Again, mahalo.

"Roxanne" wrote:

> Had a problem settling a credit card batch due to duplicate batch number.

> Credit card company (paymentech) keeps saying we have to re-number our

> batch.

> Batch is already gone as "settled" on my side. No error came back as

> "duplicate". Didn't know till we called processor.

> Also, would like duplicate receipt for debit card without a signature line

> and without pressing reprint. How to?

> Thanks