It seems like there should be a simple solution to this, but our finance team is struggling. Each batch from our box contains revenue from a number of different performances. We split revenue with our partners, and it's important to know at the end of the day how those funds should be split. The standard batch report doesn't include performance data or GL codes for each transaction. We've got a database query that we run to get this info, but requiring our DBA to get involved every day is cumbersome. Does anyone know of a standard report or a shared report that can provide this info easily?
Could you turn the query into a report, perhaps? It would take a little bit of work up front on the DBA end of things, but then they'd be free!
Hi Kathleen. That was our eventual goal. Need to do some learning about that process.
Hi Douglas. When you post the batch(es), the posting report shows the GL codes, and the Transactions by Posting report gives you more granular details. Would those work for you?
Thank you Michael. This is helpful. We're still hopeful that we can get this information for each batch (and your Shared Reports Skill Builder video has started us on that path). For now, this is sufficient.