1. Home
  2. Point-Of-Sale Software
  3. RMS GURU NEEDED ASAP

RMS GURU NEEDED ASAP

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! ##-----------------------------------------------##

Reply to
bmwsteve
Loading thread data ...

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.

Reply to
Andy Miller - Boise, Idaho

VisaNetAuthorization.Status

0 = Open 1 = Voided 2 = Settled

"Andy Miller - Boise, Idaho" wrote:

Reply to
Ed Balda

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.