Hey all,
We are beginning the process of adding hosted payments to TNEW. We've noticed that in standard reporting for payments, it only shows the generic payment method for hosted payments. It does not tell us what type of card was used (even though the card type is selected when the card is saved to the account - like Visa for example). Has anyone made any reporting for settlements that will show the actual type of card used versus the generic card type? We really need this for Broadway tours so anyone who is Broadway tour house who has this reporting would be awesome. We are WorldPay clients.
- Chris
Funny enough we're in beginning this process too and running into the same issue.
We reconcile by performance and require a breakdown of dollars by payment method to accurately calculate the card rates for each type of card (the rates vary by card type) on our settlements. Its critical that we're able to generate this reporting within Tessitura by performance.
We use Windcave.
wes
Christopher Cuhel said:It does not tell us what type of card was used (even though the card type is selected when the card is saved to the account - like Visa for example).
Is the card number masked as usual in T_PAYMENT_GATEWAY_ACTIVITY, e.g. "411111XXXXX1111"? If yes, that first digit is a possible source for card type.
Hi everyone! We have a feature on the TNEW roadmap for this. It says: Reporting by Credit Card Type for third-party hosted payments: This feature will pass in credit card type from hosted payment provider to Tessitura for more refined reporting." We are targeting the TNEW 7.35.2 release in late June for this feature. I hope this helps when you get the feature! In the meantime, there is not a report that separates them, but Chris Jensen's custom reporting suggestion might be workable depending on your configuration and needs.
After switching to hosted payments in Test...we no longer see the beginning part of the credit card mask. We only see the last four digits. Are we supposed to be able to see the credit card masking that was pre-hosted payment setup?
Christopher Cuhel said:After switching to hosted payments in Test...we no longer see the beginning part of the credit card
Not sure where you're seeing that. Do you or someone else at your org have SSMS access to your database? If yes, have a look at the database table I mentioned above.
If no, as per Michael below, sounds like a standard report and/or other code is in the queue to be updated to resolve this, perhaps by reading that first character as mentioned above.
Hi Chris and Wes,
We are currently targeting this feature to be released to TEST sites this week and more documentation about the feature will be released at that time. What I can provide briefly if that you will enable this feature and the Hosted Payment Processor (Windcave, Worldpay, or Mastercard) will report back on the card type used by the customer. TNEW will then switch to a TNEW-specific Credit Card type much in the same way that EMV transactions currently work.
There will be some setup, testing, and brief downtime involved when you are ready to go live with the feature, let me know if I can answer any other questions.
Thanks
Paul
Another option is using V_PAYMENT_GATEWAY_ACTIVITY. It is a more readable view and shows you the payment method. Hopefully, you've named the payment methods by card type (e.g. W:Visa).