• Replies 2 replies
  • Subscribers 415 subscribers
  • Views 72 views
  • Users 0 members are here
Related

Ticket Order Billing Report

Lou Ann Mendoza
$organization

Hello,

We use the Ticket Order Billing report for our subscriber split-payments, and I am seeing a msg in the results whcih I haven't seen before: "Could not find billing information for order_no...". There are a larger number than normal that failed because of this message. We are on version 12.5.1. Before we follow-up with the patrons, I want to check that it is not a set-up error.

Thank you,

Lou Ann

Parents
  • $organization

    Hi Lou Ann,

    Piggybacking off what Beth said, it could be that something happened to those credit card account records after they were assigned to those payment schedules. I'd recommend checking each schedule to see if it's assigned to an active cc account. If you use SSMS, you can plug an order_no into this query:

    select distinct b.* from t_order_bill_detail a join t_account_data b on a.act_id = b.id where a.order_no = XXXXXX

    If no rows are returned, the cc account entry was probably deleted after the schedule was set up.

    Cheers,

    Rachel

Reply
  • $organization

    Hi Lou Ann,

    Piggybacking off what Beth said, it could be that something happened to those credit card account records after they were assigned to those payment schedules. I'd recommend checking each schedule to see if it's assigned to an active cc account. If you use SSMS, you can plug an order_no into this query:

    select distinct b.* from t_order_bill_detail a join t_account_data b on a.act_id = b.id where a.order_no = XXXXXX

    If no rows are returned, the cc account entry was probably deleted after the schedule was set up.

    Cheers,

    Rachel

Children
No Data