How to track data from Posting Report to Transaction

Hi - we've seen a few rows in our most recent posting report with a previous fyear on them. I'm hoping to take a look at the orders involved, or at least the transactions. Wondering if anyone has any advice about working backwards from a posting report to t_transaction?

I found this very interesting thread http://www.tessituranetwork.com/Community/forums/t/1523.aspx about the various ways a fiscal year might be assigned for the posting report, but everyone seems to have no problem identifying the orders/transactions involved. Any advice?

thanks,

Brian

Parents
  • Brian,

     

    The Transactions by Posting report takes a Posting Number as a parameter, and will show all of the transactions included in the posting.  In Tessitura v11, FYear has been added as a column to the output and in the grouping on the report display.  FYear is not present in the v10 version of the report.

     

    You can export this to Excel and filter pretty easily.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Thursday, September 06, 2012 2:29 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] How to track data from Posting Report to Transaction

     

    Hi - we've seen a few rows in our most recent posting report with a previous fyear on them. I'm hoping to take a look at the orders involved, or at least the transactions. Wondering if anyone has any advice about working backwards from a posting report to t_transaction?

    I found this very interesting thread http://www.tessituranetwork.com/Community/forums/t/1523.aspx about the various ways a fiscal year might be assigned for the posting report, but everyone seems to have no problem identifying the orders/transactions involved. Any advice?

    thanks,

    Brian




    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!

Reply
  • Brian,

     

    The Transactions by Posting report takes a Posting Number as a parameter, and will show all of the transactions included in the posting.  In Tessitura v11, FYear has been added as a column to the output and in the grouping on the report display.  FYear is not present in the v10 version of the report.

     

    You can export this to Excel and filter pretty easily.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Thursday, September 06, 2012 2:29 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] How to track data from Posting Report to Transaction

     

    Hi - we've seen a few rows in our most recent posting report with a previous fyear on them. I'm hoping to take a look at the orders involved, or at least the transactions. Wondering if anyone has any advice about working backwards from a posting report to t_transaction?

    I found this very interesting thread http://www.tessituranetwork.com/Community/forums/t/1523.aspx about the various ways a fiscal year might be assigned for the posting report, but everyone seems to have no problem identifying the orders/transactions involved. Any advice?

    thanks,

    Brian




    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!

Children