Discrepancy between otb reports

Hello all,

Firstly, its a pleasure to be here on the new website. 

And . . . we have been using Tess for, coming up to a year and a half and we labour under the disadvantage of not having a database manager, or anyone who can write sql reports for us.   We use two out-of-the-box reports to reconcile concerts and for the first of our 2009 Master series there is a small discrepancy between money received (Payments by Performance (New)) and the total value of ticket sales (Performance Sales Summary by PT Category).   Short of searching through every sub-line item in every ticketing order in the performance can any suggest another approach??

Cheers, Darrell

Parents
  • Hi all

     This is what i normally do when im looking for a partial paid order or a paid order not seated , that i cant find thru reports . I usually search thru Order Search  and key in information as Perf. Date , MOS , Delivery, Date of shows, paid/unpaid  , Seated/not Seated  , printed/not printed  and then search this usually narrows  it down . You will in most cases find a reservation/ order that wasn't paid in full or that wasn't seated but paid.

Reply
  • Hi all

     This is what i normally do when im looking for a partial paid order or a paid order not seated , that i cant find thru reports . I usually search thru Order Search  and key in information as Perf. Date , MOS , Delivery, Date of shows, paid/unpaid  , Seated/not Seated  , printed/not printed  and then search this usually narrows  it down . You will in most cases find a reservation/ order that wasn't paid in full or that wasn't seated but paid.

Children
No Data