If someone forgot to backdate a handful of posts, would it be safe to just update the post_dts in t_gl_posting_history for the posts in question, or should I unpost and repost?
----- Original Message ----- From: Amanda Freeman To: rosaa2@u.washington.edu Sent: Tuesday, January 05, 2010 12:22 PM Subject: [Tessitura Technical Forum] Backdating post If someone forgot to backdate a handful of posts, would it be safe to just update the post_dts in t_gl_posting_history for the posts in question, or should I unpost and repost? 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!
We unpost and repost as well.
What you suggest might do the trick. If you are using some kind of integration with your finance software that would get trickier. post_dt also appears in t_gl_posting_ftp.
My general stance is to do what I can to let Tess generate the data rather than me doing some kinds of manual update to the database. The unpost process is pretty straightforward so unless its a long list of postings, I'd go that route.
From: Rosa Alvarez <bounce-rosaalvarez7844@tessituranetwork.com>Sent: 1/5/2010 2:33:34 PM
----- Original Message ----- From: Amanda Freeman To: rosaa2@u.washington.edu Sent: Tuesday, January 05, 2010 12:22 PM Subject: [Tessitura Technical Forum] Backdating post If someone forgot to backdate a handful of posts, would it be safe to just update the post_dts in t_gl_posting_history for the posts in question, or should I unpost and repost? 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! 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!