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
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
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...