Recapture old batch exceptions

The AmEx charges have likely resulted in a Technical Error. Did this issue happen on 1 location, or many?

If it is on 1 location, you will need to do the following:

1. Determine if the transactions resulted in a Technical Error/Detailed Error by running the following report from SO Manager:

Reports> Miscellaneous> Electronic Draft Capture - Detailed, set your applicable date range> Generate

1. If under the report status you find you have technical errors on a transaction(s), note the corresponding EDC No.(s)

1. Settle the EDC Batch, in the event that there are other trxs in there.

2. Open SO Admin> Backup

1. Run the following statement to gather your next EDC Batch number in sequence:

SELECT Max(RequestBatchNumber)+1 FROM VisaNetBatch

note the number that is returned. This is your next batch in queue.

1. Create the following statement to push your unsettled/technical error trxs back into the EDC Settlement Batch:

UPDATE VisaNetAuthorization SET Status = 0, VisaNetBatchId = 'x' WHERE RequestTransactionSequenceNumber = 'y'

Here are the factors: 0 = Open, 1 = Void, 2 = Settled, 3&4 not sure, 5 Technical Error. 'x' = the next batch in queue. 'y' = the EDC No. as gathered from the SO Manager report. You could get into more specifics too by including an approval code and whatnot.

Let me know if I am too vague here.

Ken,

Also, I forgot to mention that 'x' in the equation (your VisaNetBatchId) will change with every settlement. Every time you settle, that number will increase by 1.

Let me know if you have any questions about this, I know it can be very convoluted.