3.1 Valid CCard transaction show as Dupe on CCard Report - How to change?
Problem
PNP was having issues again last night, and we have one transaction that went through in PNP> However, it shows as a duplicate on the Credit Card report and so is not included in the total of the CC report. I need to change the status from Duplicate to Sale.
Solution
This can be done via DBEdit > SACreditCardHistory table.
1. Query for transaction number or receipt number.
2. You will need to change the mask, brand, order id, and auth code to match what PnP shows.
3. Save changes and exit.
4. Re-run the credit card report, and you should get a 'Settled' status rather than 'Declined.'