Is anyone doing this? We are clearly getting having more issues than those picked up by the Incomplete Credit Card Transaction Report, and we're working towards frequent reconciliation with Windcave for card purchases, so I am investigating importing their reports into a local table to do some of the reconciliation automatically. I don't really understand all of the columns, for instance there are several columns that look like they might be a transaction id column, but none are unique, even with just a month's transactions.
Also, is it just me or is the time field mangled, with month encoded as day and vice-versa?
My first SSRS report was for finance looking into Windcave errors. I used auth code - is that going to be helpful for you?
We've also had 2 years of issues with Windcave after hosted payments kicked in and we were made to use void rather than refund for transactions. A lot of the issue is that first data sits between our bank and Windcave and bounces void transactions. Getting an understanding of that took a long time.
Auth code isn't unique, you wantto use the transaction locator which in most cases will match the reference number column in T_Payment_gateway
It was originally for the Accountant to reconcile single orders but for large scale matchups in Windcave it's best to match up using DpsTxnRef from the Windcave: Full Transaction Report and ccref_no in T_PAYMENTS.