• Replies 5 replies
  • Subscribers 217 subscribers
  • Views 144 views
  • Users 0 members are here
Related

Reporting transactions by Performance, Batch No and post No

Matt Beckler
$organization

Hello,

I tried modifying Transactions by Posting report. But the Transaction table does not appear to populate perf_no for fees even if the fees are at the performance level. There is no way to map a transaction line back to the individual fees in T_SLI_FEE as far as I can tell. I thought I could do it by order number and fee type but this does not necessarily identify the fees for that transaction because of return consideration. (It actually works pretty good until your run into returns and re-buys in the same order_no in a different batch)

Any ideas of where to start would be good. 

Part of the problem I'm seeing is that the T_SUB_LINEITEM batch_no gets updated to new batch_no if it is opened and exchanged in new batch. So I can't see a way to tie that SLI to the batch it was originally purchased in.

(Maybe I'm missing  table that could tell me this)

 

Thanks for any ideas. Let me know if you need some clarification on what exactly I'm trying to do.

 

Thanks

Matt

  • $organization

    I don't have an answer for you off hand. But have you looked at the procedure behind the 'Fees by Performance' report? It may be useful.

  • $organization in reply to Beth Hawryluk

    I did see that procedure. Unfortunately while that does break down fees by performance there is no way to tie those fees to the post or batch they were in.

     

     I think we will change our business practice and do exchanges in a new order. This seems to fix the issue. Because I can then break out the per perf fees per order. The problem was if the exchange happens in the same order I can't reliably say all the fee lines in T_SLI_FEE with that order number belong to that batch/transaction line.

    Thanks 

     

    Matt

  • $organization

    Matt

    I have been working and working on this issue as we need to tie fees back to the transaction.  I reckon that since you posted this some time ago that you guys have changed your process.  That can't happen here.  Like you I looked at the fee by performance report and that doesn't help with what we need.  We need to import into Financial Edge and each ticket base price, price layer and performance level fee needs to have a project id - we are using the performance code as the project id.  Have you heard anything else on this or know of anyone who has found a way to tie perf to perf level fees?

    Thank you

  • $organization in reply to Roberta Harrill

    Yes we have changed our process and at this time do all returns in new order.

    I could not find a way to reliably tie fees to a specific performance or production season when the exchange happened in the same in the order because the transaction level for fees does not label fees with a perf_no.

    I will admit I was fairly new to Tessitura when first looking at this problem so I have not revisited it...

     

    Matt

  • $organization

    Thank you

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Matt Beckler
    Sent: Wednesday, September 09, 2015 2:50 PM
    To: Roberta Harrill <rharrill@austintheatre.org>
    Subject: Re: [Tessitura Finance Forum] Reporting transactions by Performance, Batch No and post No

     

    Yes we have changed our process and at this time do all returns in new order.

    I could not find a way to reliably tie fees to a specific performance or production season when the exchange happened in the same in the order because the transaction level for fees does not label fees with a perf_no.

    I will admit I was fairly new to Tessitura when first looking at this problem so I have not revisited it...

     

    Matt

    From: Roberta Harrill <bounce-robertaharrill9583@tessituranetwork.com>
    Sent: 9/9/2015 3:27:16 PM

    Matt

    I have been working and working on this issue as we need to tie fees back to the transaction.  I reckon that since you posted this some time ago that you guys have changed your process.  That can't happen here.  Like you I looked at the fee by performance report and that doesn't help with what we need.  We need to import into Financial Edge and each ticket base price, price layer and performance level fee needs to have a project id - we are using the performance code as the project id.  Have you heard anything else on this or know of anyone who has found a way to tie perf to perf level fees?

    Thank you




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Finance Forum. You may reply to this message to post to the Finance 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!