Hi,
Finance user has posted few batches to the wrong date. I am wondering if there is any simple method or report to unpost those batches. Thanks for your time.
Cheers
Harpreet
You can use the stored procedure UP_UNPOST to unpost the applicable post_nos.
Thanks Amanda for your prompt reply. It really helped.
From: Tessitura Finance Forum [mailto:forums-finance@tessituranetwork.com] On Behalf Of Amanda Freeman Sent: Wednesday, 16 June 2010 12:02 To: Harpreet Gangyan Subject: Re: [Tessitura Finance Forum] Unpost the batches
From: Harpreet Gangyan <bounce-harpreetsinghgangyan5939@tessituranetwork.com> Sent: 6/15/2010 6:56:43 PM
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!
10 years later, and I just used your forum post. Thanks!
11 years later and I am now using this post.
So ... I ran the proc. How do I check to see if the batch is unposted?
Ashley
Haha,
select * from T_batch where batch_no in (12345, 6789)That should give you the posting (or lack-of) posting details for the batch(es). Or just look for them in batch administrator in the application.
Thank you!
Hi! How do you run a "stored procedure"?
This isn't something you can access via the client. You have to has SSMS installed on your machine. Do you have SSMS??
I am not sure if we have that! Is there a way to check?
If you had SSMS you would know. It is SQL Server Management Studio. You must be on RAMP. Self-hosted org all use SSMS to manage the back-end of the product.
You might need to put in a helpdesk ticket to resolve your situation.
Hi Andrea! Since you are hosted with our hosting service, you can submit a ticket or use the Live Chat inside Tessitura to request an unposting.
okay thanks! I know we are on RAMP but it looks like a help ticket is the only way for us to request an un-posting since we are hosted. Thanks for the clarification!