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
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.
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??
Aga> Had a problem settling a credit card batch due to duplicate batch number.
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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.