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!
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!
:)