• Replies 8 replies
  • Subscribers 216 subscribers
  • Views 71 views
  • Users 0 members are here
Related

Rogue GL Code

Former Member
Former Member $organization

I'm wondering if anyone can help.

One of our finance team has a mismatch between the figures showing on reports and it is suspected that we may have attributed, at set up, a GL code to one or more price maps used for a different show than the one finance is reporting on.

Is there a quick and simple way of taking a look at all the price maps to which a GL Code is attributed.

Advice appreciated.

  • Former Member
    Former Member $organization
    If you can identify a single Tessitura post or date range where you feel there may be a rogue g/l, run the transaction by post report (filtered on that specific post/date) and comb through the transactions. That should hopefully point you in the right direction. 

    On Wednesday, December 11, 2013, Paul Roberts wrote:

    I'm wondering if anyone can help.

    One of our finance team has a mismatch between the figures showing on reports and it is suspected that we may have attributed, at set up, a GL code to one or more price maps used for a different show than the one finance is reporting on.

    Is there a quick and simple way of taking a look at all the price maps to which a GL Code is attributed.

    Advice appreciated.



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/10661/33022.aspx#33022 or reply to this message


     

  • $organization

    Hi – we use one of two reports to confirm that GLs have been assigned correctly: Performance Setup Audit Report, which allows you to select the performance(s) you’d like to review based on season, or the Price Map Listing report which allows you to select a zone map by facility and shows you every price map built within that zone map.  Our finance team prefers the second option.

     

    Good luck!

    Cheers,
    Tal

     

     

    Tal Hebdon Manager of Patron & Operations Services
    Young Centre for the Performing Arts

     

    T 416.866.8666 x402
    F 416.504.5222
    W youngcentre.ca

     

    Young Centre for the Performing Arts
    Distillery Historic District

    50 Tank House Lane,
    Toronto, ON, M5A 3C4

     

    Box Office: 416.866.8666

     

    Follow Us: 
    Description: cid:image002.gif@01CD1318.BEE00E30Description: cid:image003.gif@01CD1318.BEE00E30Description: cid:image004.gif@01CD1318.BEE00E30

     

    Description: Description: Description: Description: Description: Description: Description: untitled 

     

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Paul Roberts
    Sent: Wednesday, December 11, 2013 5:19 AM
    To: Tal Hebdon
    Subject: [Tessitura Finance Forum] Rogue GL Code

     

    I'm wondering if anyone can help.

    One of our finance team has a mismatch between the figures showing on reports and it is suspected that we may have attributed, at set up, a GL code to one or more price maps used for a different show than the one finance is reporting on.

    Is there a quick and simple way of taking a look at all the price maps to which a GL Code is attributed.

    Advice appreciated.




    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!

  • Former Member
    Former Member $organization

    If you don’t know what date the differences started on I do believe there’s a price map listings report that you can choose. I just ran it as a test and it list all price maps in a facility/zone and shows the GL attached to it.

     

     

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Paul Roberts
    Sent: Wednesday, December 11, 2013 4:17 AM
    To: Jon-Paul Eddings
    Subject: [Tessitura Finance Forum] Rogue GL Code

     

    I'm wondering if anyone can help.

    One of our finance team has a mismatch between the figures showing on reports and it is suspected that we may have attributed, at set up, a GL code to one or more price maps used for a different show than the one finance is reporting on.

    Is there a quick and simple way of taking a look at all the price maps to which a GL Code is attributed.

    Advice appreciated.




    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!

  • Former Member
    Former Member $organization in reply to Former Member

    Thanks for the replies. Considering we use different GL codes for every production and the fact we have  a lot of productions programmed & on sale, many with multiple price types, I was worried it might be a bit like looking for a needle in a haystack.

    Fortunately we have found the error and rectified. I do wonder whether it would be possible to have a report which identifies all the instances in which a GL Code is utilised. i.e. you enter the GL Code and the report lists the performances and the prices the GL is attached to.

  • $organization

    Paul,

     

    We have a custom report that shows GL Audit History.  It displays the activity of the GL (New, Changed, Deleted), what the old GL was and the new GL if changed….and it shows what the record type is (price map, fund, etc) and it looks like the description of the price map or fund.

     

    If you like a sample output, let me know and I’m happy to send and if it’s helpful, we can send you the files for the report.  I don’t believe there is anything hardcoded, so it should be pretty quick and easy to put into your environment.

     

    Teresa L Dean | Tessitura Systems Director | AT&T Performing Arts Center

  • Former Member
    Former Member $organization
    We used to have a custom report that that was called GL usage. You would enter the GL and it would reflect everywhere in the system that GL was used. I don't know if it still exist. Would need to contact our Tess. Admin. 

    Sent from my iPhone

    On Dec 12, 2013, at 8:40 AM, "Paul Roberts" <bounce-paulroberts7629@tessituranetwork.com> wrote:

    Thanks for the replies. Considering we use different GL codes for every production and the fact we have  a lot of productions programmed & on sale, many with multiple price types, I was worried it might be a bit like looking for a needle in a haystack.

    Fortunately we have found the error and rectified. I do wonder whether it would be possible to have a report which identifies all the instances in which a GL Code is utilised. i.e. you enter the GL Code and the report lists the performances and the prices the GL is attached to.

    From: J.P. Eddings <bounce-jpeddings4266@tessituranetwork.com>
    Sent: 12/11/2013 9:57:04 AM

    If you don’t know what date the differences started on I do believe there’s a price map listings report that you can choose. I just ran it as a test and it list all price maps in a facility/zone and shows the GL attached to it.

     

     

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Paul Roberts
    Sent: Wednesday, December 11, 2013 4:17 AM
    To: Jon-Paul Eddings
    Subject: [Tessitura Finance Forum] Rogue GL Code

     

    I'm wondering if anyone can help.

    One of our finance team has a mismatch between the figures showing on reports and it is suspected that we may have attributed, at set up, a GL code to one or more price maps used for a different show than the one finance is reporting on.

    Is there a quick and simple way of taking a look at all the price maps to which a GL Code is attributed.

    Advice appreciated.




    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!




    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!
  • $organization
    Teresa,

    Would you also send me the sample output and files?

    Thank you.

    Caren K. Rager
    Santa Barbara Center for the Performing Arts

    On Dec 12, 2013, at 6:59 AM, "Teresa Dean" > wrote:

    Paul,

    We have a custom report that shows GL Audit History. It displays the activity of the GL (New, Changed, Deleted), what the old GL was and the new GL if changed….and it shows what the record type is (price map, fund, etc) and it looks like the description of the price map or fund.

    If you like a sample output, let me know and I’m happy to send and if it’s helpful, we can send you the files for the report. I don’t believe there is anything hardcoded, so it should be pretty quick and easy to put into your environment.

    Teresa L Dean | Tessitura Systems Director | AT&T Performing Arts Center



    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!
  • $organization in reply to Teresa Dean

    Hi Teresa. 

    Can we get the same output and files for this custom GL Audit report?

    Thanks. 

     

    Adria