Can Tessitura have some sort of reminder to send to people when they forget to close the batch or maybe Tessitura has something like if you do not completely close the batch you cannot open a new one till you close the one that was opened before?
I made an Analytics widget that shows held and open batches for finance. I often use it for naming and shaming along with a handy meme like ... ... to soften the blow. That usually does the trick in a fun way (or at least they haven't thrown anything yet)
I have a SQL Agent job set to run every morning that does a combination of sending an email to each user with a list of their unclosed batches from days prior (using SQL Server Database Mail), and sending a message to a Slack channel.
Heath Wilder I am 1000% stealing that meme and adding it to my email notification. Perfect.
Here's my code if anyone wants to do this on their system. I don't know how much access to DatabaseMail you have on RAMP, but I'm sure it's possible to figure something out:
https://bitbucket.org/snippets/TN_WebShare/LrG4Eg
All yours mon homme - I think I got the better end of the deal I'm going to make "Will meme for code!" into a t-shirt
Thank you so much NIck. We will take a look at this SQL.