RMS GURU NEEDED ASAP

Jun 11, 2008 2 Replies
B

Here's the situation. We are doing some testing (with our own credit cards) Credit Card Transactions happened, we realized that they were not settling in the batch when we run a SQL report, we see that in the VisaNetAuthorizationID, that they are all listed as 0. After we fixed the problem, there were some additional transactions run, and those all have an authorizationID listed.



When I export the tables into CSV, i can see all of them, and theoretically i need to be able to change the VisanetauthorizationID to show 5, so that it will que the file again, and rebatch with the encrypted card (obviously we can't decrypt the card)



Could someone give me some guidance here?


##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software Forums Web and RSS access to your favorite newsgroup - microsoft.public.pos - 33207 messages and counting! ##-----------------------------------------------##


Vote
Twitter Facebook LinkedIn
A

I dont recall what all of the columns are in the visanetbatch tables. However.... there is a column that is the settlement status for each entry. If you change that column to the status value that represents 'OPEN'; then you will see these transactions displayed in your settle edc batch utility. press the settle button and it should settle all of these transactions. be sure not to settle a transaction more than once or else you will end up charging that credit card more than once.

Vote
Twitter Facebook LinkedIn
E

VisaNetAuthorization.Status

0 = Open 1 = Voided 2 = Settled

"Andy Miller - Boise, Idaho" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required