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!
I think the gl on the pmap is the GL at time of posting. So if you unpost, then change the GL on all the pmaps used for that show, and then repost, it should reflect the change.
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 SchlosserSent: Tuesday, July 26, 2011 5:11 PMTo: Ryan CrepsSubject: 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 LaliconSent: Tuesday, July 26, 2011 4:41 PMTo: Lee SchlosserSubject: [Tessitura Finance Forum] Revenue tranacted in wrong GL
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!
Thanks! I thought I was on the right track, but just wanted to make sure. Will run this stored procedure and save the day!
:)
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>
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Kareen LaliconSent: Tuesday, July 26, 2011 6:12 PMTo: Ryan CrepsSubject: RE: [Tessitura Finance Forum] Revenue tranacted in wrong GL
From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>Sent: 7/26/2011 4:32:19 PM
Ryan,
For the scenario where the Price Map was mapped correctly but the GL associated was incorrect:If I unpost the batches, and then repost, what will the Transactions by Posting report look like. Will it have the debits and credits for the incorrect GL, or will there be no results for that GL?
Thanks,
Steve