• Replies 10 replies
  • Subscribers 341 subscribers
  • Views 127 views
  • Users 0 members are here
Related

Sales reports not matching

Siobhan Parker (Past Member)
$organization

Hi - I believe there is a list or a document somewhere explaining why certain sales reports don't match up - can someone either point me in the direction of this, or just let me know why the Performance Sales Analysis and the Performance Sales Summary might differ?

Thanks

Siobhan

Parents
  • $organization

    Just a quick clarification here:

     

    The seat_status and sli_status should be in sync for orders and the seat map.  What you are saying is a disconnect in the order/seat map, but should not be a problem with the report.  If so, I would recommend running TP_CHECK_SEAT_STATUS to verify the status of these.  There is more information about this procedure in the SQL Server Scheduled Jobs documentation found here:

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/SQL%20Server%20Scheduled%20Jobs.aspx

     

    TP_CHECK_SEAT_STATUS with @fix_problems = ‘Y’ should find and/or correct any inconsistencies.  If you have further issues, please open a support ticket.

     

    The Performance Sales Summary does not inherently report voided sublineitems.  However, it does rely on seat_status (as you note) for categorizing sales.

    -Ryan

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Thursday, May 06, 2010 10:22 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Sales reports not matching

     

    Siobhan Parker:

    or just let me know why the Performance Sales Analysis and the Performance Sales Summary might differ?

    I don't know if code has changed, but in late '08 we stopped using the "Performance Sales Summary" report because we found that it overstated income by adding the due_amt from voided sli order lines to its "$" columns because it was considering seat_status but not sli_status for those rows. YMMV.

     

    From: Siobhan Parker <bounce-siobhanbennetts3867@tessituranetwork.com>
    Sent: 5/4/2010 4:27:32 AM

    Hi - I believe there is a list or a document somewhere explaining why certain sales reports don't match up - can someone either point me in the direction of this, or just let me know why the Performance Sales Analysis and the Performance Sales Summary might differ?

    Thanks

    Siobhan




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Ryan Creps (Past Staff Member)

    Unknown said:
    If so, I would recommend running TP_CHECK_SEAT_STATUS to verify the status of these.  

    We've always run that nightly, but the report still gave us incorrect numbers as described. That was a while back, though, and I have no idea if its code has changed since then or what. Not an issue for us, we don't use it, but since the topic of that report and its numbers came up, I thought I'd mention our experience.

Reply
  • $organization in reply to Ryan Creps (Past Staff Member)

    Unknown said:
    If so, I would recommend running TP_CHECK_SEAT_STATUS to verify the status of these.  

    We've always run that nightly, but the report still gave us incorrect numbers as described. That was a while back, though, and I have no idea if its code has changed since then or what. Not an issue for us, we don't use it, but since the topic of that report and its numbers came up, I thought I'd mention our experience.

Children
No Data