Happy new year!
Has anyone directly updated table above? And if so does anyone know whether this will cause some difficult to foresee problems?
I am specifically hoping to combine post_amt among a few rows with the same post_no, gl_act_no, and fyear, but different batch_type_groups. We started using a new batch type that wasn’t assigned to a batch type group, and this messed up some of our custom reports. We’ve fixed the error for all future batches, but it would be nice to fix the already posted batches as well.
Thanks,
Rey
--
A. Rey Pamatmat
Tessitura Manager
The Public Theater
425 Lafayette Street
New York, NY 10003
(212) 539-8739
rpamatmat@publictheater.org
The only thing I've done with it in the past is to alter some GL numbers (by adding a segment). I don't think you will run into too much trouble. If the new batch type already exists you shouldn't bump into any constraint problems.
Always best to unpost using UP_UNPOST, and not directly alter rows in T_GL_POSTING_HISTORY directly. If you have changed existing batch types to point to new batch type groups, the reposting should take care of the consolidation.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of A. Rey PamatmatSent: Tuesday, January 04, 2011 10:20 AMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY
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!
Thanks, Ryan. But if I unpost the batches and repost them, it will change the posting date to today, right? Which also messes up our reporting.
In your eyes, would it be better to unpost, repost, and then update the posting date on the T_GL_POSTING_HISTORY (to reflect the actual, past post date)? Or to just combine the rows as I originally planned?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps Sent: Tuesday, January 04, 2011 10:35 AM To: Rey Pamatmat Subject: RE: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of A. Rey Pamatmat Sent: Tuesday, January 04, 2011 10:20 AM To: Ryan Creps Subject: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY
When you repost it you can backdate the posting date. You can change it in the upper right corner of the Posting Details window.
When posting, you can always backdate the posting to a particular posting date by changing the posting date in the post window. A lot of organizations have a policy to post batches in the same day they were opened/closed. You may have to adjust the T_DEFAULTS setting POSTING MAX BACKDATE DAYS if the posting occurred some time ago.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of A. Rey PamatmatSent: Tuesday, January 04, 2011 4:30 PMTo: Ryan CrepsSubject: RE: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan CrepsSent: Tuesday, January 04, 2011 10:35 AMTo: Rey PamatmatSubject: RE: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY
AWESOME.
That is all.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps Sent: Tuesday, January 04, 2011 4:40 PM To: Rey Pamatmat Subject: RE: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of A. Rey Pamatmat Sent: Tuesday, January 04, 2011 4:30 PM To: Ryan Creps Subject: RE: [Tessitura Technical Forum] Making Changes in T_GL_POSTING_HISTORY