• Replies 6 replies
  • Subscribers 219 subscribers
  • Views 229 views
  • Users 0 members are here
Related

Revenue tranacted in wrong GL

Kareen Lalicon
$organization

Hi there;

 

Wondering if there is an easy way to change a GL code for past shows? Currently we had the worng GL code attached to a price map, which is throwing off our balance sheet. Should I unpost then repost for these shows?

Please help!

Thanks!

Parents
  • $organization

    Just a quick clarification here.  There’s a slight nuance to this issue that I’d like to make sure we have clarified on the forums for posterity!

     

    If a ticket was sold a price type that has incorrect Price Maps then the remedy is as follows:

    1.       Correct the Price Type mappings in the performance(s).

    2.       Return the incorrect sublineitems, which releases and credits the incorrect transactions (mapped to the incorrect price maps).

    3.       Resell the sublineitems, which picks up the correct pricemaps in a new transaction.

     

    If the Price Map was mapped correctly, but the GL Account on the Price Map was set incorrectly, the remedy is as follows:

    1.       Correct the GL Account mapping in the offending price map(s).

    2.       Unpost any batch containing a transaction using the problem price maps.

    3.       Repost the batches.

     

    Hope that lets everyone see to the bottom of the Price Mapping lagoon. <snark>

    -Ryan

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Kareen Lalicon
    Sent: Tuesday, July 26, 2011 6:12 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Finance Forum] Revenue tranacted in wrong GL

     

    Thanks! I thought I was on the right track, but just wanted to make sure. Will run this stored procedure and save the day!

    :)

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 7/26/2011 4:32:19 PM

    Lee, unposting and reposting the batches affected should correct the GL postings.  I’m not sure why you may have experienced different results, but you shouldn’t have to refund and reseat orders to get the transactions to change.  The posting process takes into account the GL associated to the price map at the time of the posting, not the historically associated price map.  Sorry if you found this to work differently but I can assure you that I experienced this myself in past life and reposting was the fortunate resolution!

     

    I do have ONE caveat here to mention which is that the Transactions by Posting report DOES look at the GL account assigned historically, as some sites change the GL on a settled show so that adjustments made later do not affect the general ledger on a settled amount.

     

    Kareen, un-posting and reposting affected batches should do the trick here.

     

    -Ryan

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Lee Schlosser
    Sent: Tuesday, July 26, 2011 5:11 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Finance Forum] Revenue tranacted in wrong GL

     

    Unposting will not change the resulting GL.  What you need to do, and we learned the hard way here, you need to return all seats on the wrong GL, put the money on account or some other holding payment method.  Then change the GL on your price map and go back in and resell the seats to the correct GL using the funds put on account.   Then when you post you will return all the incorrect GL funds and put those funds to the correct GL.

     

    Lee Schlosser

    IT/Business Manager

    Florida Studio Theatre, Inc.

    1241 North Palm Avenue

    Sarasota, FL  34236

    Phone: 941-366-9017 ext 328

    Fax: 941-955-4137

    email: lschlosser@floridastudiotheatre.org

    website: www.floridastudiotheatre.org

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Kareen Lalicon
    Sent: Tuesday, July 26, 2011 4:41 PM
    To: Lee Schlosser
    Subject: [Tessitura Finance Forum] Revenue tranacted in wrong GL

    Hi there;

     

    Wondering if there is an easy way to change a GL code for past shows? Currently we had the worng GL code attached to a price map, which is throwing off our balance sheet. Should I unpost then repost for these shows?

    Please help!

    Thanks!




    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!




    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!

Reply
  • $organization

    Just a quick clarification here.  There’s a slight nuance to this issue that I’d like to make sure we have clarified on the forums for posterity!

     

    If a ticket was sold a price type that has incorrect Price Maps then the remedy is as follows:

    1.       Correct the Price Type mappings in the performance(s).

    2.       Return the incorrect sublineitems, which releases and credits the incorrect transactions (mapped to the incorrect price maps).

    3.       Resell the sublineitems, which picks up the correct pricemaps in a new transaction.

     

    If the Price Map was mapped correctly, but the GL Account on the Price Map was set incorrectly, the remedy is as follows:

    1.       Correct the GL Account mapping in the offending price map(s).

    2.       Unpost any batch containing a transaction using the problem price maps.

    3.       Repost the batches.

     

    Hope that lets everyone see to the bottom of the Price Mapping lagoon. <snark>

    -Ryan

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Kareen Lalicon
    Sent: Tuesday, July 26, 2011 6:12 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Finance Forum] Revenue tranacted in wrong GL

     

    Thanks! I thought I was on the right track, but just wanted to make sure. Will run this stored procedure and save the day!

    :)

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 7/26/2011 4:32:19 PM

    Lee, unposting and reposting the batches affected should correct the GL postings.  I’m not sure why you may have experienced different results, but you shouldn’t have to refund and reseat orders to get the transactions to change.  The posting process takes into account the GL associated to the price map at the time of the posting, not the historically associated price map.  Sorry if you found this to work differently but I can assure you that I experienced this myself in past life and reposting was the fortunate resolution!

     

    I do have ONE caveat here to mention which is that the Transactions by Posting report DOES look at the GL account assigned historically, as some sites change the GL on a settled show so that adjustments made later do not affect the general ledger on a settled amount.

     

    Kareen, un-posting and reposting affected batches should do the trick here.

     

    -Ryan

     

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Lee Schlosser
    Sent: Tuesday, July 26, 2011 5:11 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Finance Forum] Revenue tranacted in wrong GL

     

    Unposting will not change the resulting GL.  What you need to do, and we learned the hard way here, you need to return all seats on the wrong GL, put the money on account or some other holding payment method.  Then change the GL on your price map and go back in and resell the seats to the correct GL using the funds put on account.   Then when you post you will return all the incorrect GL funds and put those funds to the correct GL.

     

    Lee Schlosser

    IT/Business Manager

    Florida Studio Theatre, Inc.

    1241 North Palm Avenue

    Sarasota, FL  34236

    Phone: 941-366-9017 ext 328

    Fax: 941-955-4137

    email: lschlosser@floridastudiotheatre.org

    website: www.floridastudiotheatre.org

    From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Kareen Lalicon
    Sent: Tuesday, July 26, 2011 4:41 PM
    To: Lee Schlosser
    Subject: [Tessitura Finance Forum] Revenue tranacted in wrong GL

    Hi there;

     

    Wondering if there is an easy way to change a GL code for past shows? Currently we had the worng GL code attached to a price map, which is throwing off our balance sheet. Should I unpost then repost for these shows?

    Please help!

    Thanks!




    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!




    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!

Children