Is there a way that we can query a specific group type for group sales?

I'm trying to get information about payments not received for a specific group type. For example, if the group type was birthday party, I'd want to see reservations for birthday parties where the patron has not made any payment yet.

Tagged:

Comments

  • You can create an ad-hoc query using the Reservation record type and Group Sales Reservations. The criteria you want are

    • Itineraries\\Group Type (choosing your group type)
    • Sales order status not cancelled or blank

    For results fields to display I used

    • Arrival date
    • Name
    • Arrival time
    • Raye scale\\prices\\amount (for total cost)
    • Order/sales order payment/amount tendered (for amount paid already)
    • Order\\sales order payment\\date added (for date paid)

Categories