The situation is this:
We have an asset account that we use for tracking deposits in transit in Tessitura. Probably non standard and evil and wrong but it was setup to help us with reconciling all the disparate income streams(we have a restaurant and other income that doesnt go through Tessi ) with the actual bank deposit. Unfortunately this year it is negative and while it should bounce up and down a lot it should always hover around zero. We have reviewed our payment methods to make sure that they are posting to the correct GL but cant seem to figure out how to audit all the tickets to see it they are directed correctly.
Is there a way to list all the tickets for this season and their associated GL? There isnt a standard report that does this. I assume there is a table somewhere that lists the thousands of things we sold this year and where the money was directed. I would love to be able to look at this and even export it to Excel to hopefully find the errors.
Joe,
Could T_GL_POSTING_HISTORY help? It has fields for post_no, gl_act_no, fyear, batch_type_group, type, post_amt, and post_dt.
How about the "Performance Transaction Detail" report? The excel version of it has all orders by payment method by GL by ticket price layer, and a whole lot of other fields.
WAY better answer!
Thanks for this. That particular report isnt available to us, but I will see if we can get it turned on