Hello all,
I'm wondering if anyone has some SQL or some other method that helps them identify batches where the create, closing, and posting dates are different from one another. To be clear, I want to get a count of any batches where at least one of the three dates is not the same in a given time frame (i.e., 6/1/23-6/30/23). We're using Tessitura Merchant Services, and we've been noticing a lot of the reports from Adyen and Tessitura are at odds with one another. My suspicion is that this is because of batches opened on one date, and closed and/or posted on another date. Or if there is some easy, out-of-the-box way to get this, let me know what that is.
Thanks in advance,
Michael Dorsey
CRM Systems Manager
Spoleto Festival USA
Wanted to give a quick shoutout here to everyone who responded with ideas and solutions to this issue (Gawain Lavers, Chris Wallingford, Neil Cole)--I appreciate the effort you put into helping me with this! I haven't had a chance to dive into all of it yet--it's the last day of our FY so I find myself busy with that stuff--but it all looks very promising. You're all amazing for the knowledge you possess and share with the community.
Thank you!
Michael,
I think I like Chris's option the best. Another idea is to bring Chris's idea into SQL.I'm assuming you'll need to factor in batch type. In our case, most controlled batches don't have matching dates (we want the closed date to match the posting date).