Locating Credit Card records where a Noval Profile was used.
RecTrac 3.1.10.21.00
Table of Contents
Problem
We are looking for a way to show No Validate Credit Card Profile Usage however, we are struggling to produce this information easily with existing reports. Is there a way we can easily see when the Noval Credit Card profile was used?
Solution
Using these queries separately in DB inquiry will show any instance where a Credit Card transaction used a NoValid CC profile.
Steps For Solution
- From the RecTrac main menu, go to DB Inquiry.
- Select Table to View to SAReceiptPayment.
- Copy and paste the desired query:
Note:
This query assumes that the database has several different Payment Codes for credit cards. Replace the codes in the query with your credit card Pay Codes and update the date for the range desired.
For payments using Noval use the full query below:
(paycode = "03" and speciallinkid = "0" and postingdate > 01/01/2023) or (paycode = "03M" and speciallinkid = "0" and postingdate > 01/01/2023) or (paycode = "03RF" and speciallinkid = "0" and postingdate > 01/01/2023)
Any results left are instances where purchases were made with the No Val credit card profile enabled. Do not be alarmed if there is a large stack of records, be mindful of the date as you may be viewing onboarding dates where bulk reservations may have been made during implementation.
For refunds using Noval use the full query below:(paycode = "03" OR paycode = "03RF" OR paycode = "03M") and (speciallinktable = "sacontrolaccounthistory" and postingdate > 01/01/2023 and miscinformation begins "payment")
Any results left are instances where refunds were made with Noval enabled.
- Change the dates and Pay Codes within the Query.
- Click View.
- Click the DataGrid Options.
- Click Export Comma Delimited.
You should now have a list of No Val transactions in a .CSV file for further review.