Gl_Posting History

I think you should be ok changing the FYear in T_GL_POSTING_HIST as long as it doesn’t create a duplicate row for the GL Account in the posting (if you have “2010 Account A” and “10 Account A”, changing “10” to “2010” would create two rows for “2010 Account A”).

It’s always better to unpost and repost.

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

Easy one,

Had a campaign that had the fyear as '10' instead of '2010'. already changed it to the proper one but we do have posting to the '10'. does it hurt anything to just update the posting history table to the proper value? Any other things I am not thinking of?

Thanks,

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!

Checked by AVG - www.avg.com
Version: 8.5.386 / Virus Database: 270.13.2/2214 - Release Date: 07/06/09 17:54:00

I think you should be ok changing the FYear in T_GL_POSTING_HIST as long as it doesn’t create a duplicate row for the GL Account in the posting (if you have “2010 Account A” and “10 Account A”, changing “10” to “2010” would create two rows for “2010 Account A”).

It’s always better to unpost and repost.

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

Easy one,

Had a campaign that had the fyear as '10' instead of '2010'. already changed it to the proper one but we do have posting to the '10'. does it hurt anything to just update the posting history table to the proper value? Any other things I am not thinking of?

Thanks,

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!

Checked by AVG - www.avg.com
Version: 8.5.386 / Virus Database: 270.13.2/2214 - Release Date: 07/06/09 17:54:00

Actually it would create duplicate rows, I will unpost and repost.

Do I need to change the campaign back to 10 prior to unposting?

I think you should be ok changing the FYear in T_GL_POSTING_HIST as long as it doesn’t create a duplicate row for the GL Account in the posting (if you have “2010 Account A” and “10 Account A”, changing “10” to “2010” would create two rows for “2010 Account A”).

It’s always better to unpost and repost.

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

Easy one,

Had a campaign that had the fyear as '10' instead of '2010'. already changed it to the proper one but we do have posting to the '10'. does it hurt anything to just update the posting history table to the proper value? Any other things I am not thinking of?

Thanks,

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!

Checked by AVG - www.avg.com
Version: 8.5.386 / Virus Database: 270.13.2/2214 - Release Date: 07/06/09 17:54:00

Thanks for the help.

No, all UP_UNPOST does is delete the rows from T_GL_POSTING_HIST and reset the transactions and batches.  Keep the campaign as 2010 and when you post the new FYear will be used.