Is there a table we could use to build a report for all Unexplained Differences?
Summary:
Is there a table we could use to build a report for all Unexplained Differences?
Content (please ensure you mask any confidential information):
After reviewing all of the table definitions here I think I already know the answer and it's 'no', but I figure I'd ask here anyway to cover all my bases. Is there a table we could use in ARCS to build a custom report which would pull Unexplained Differences by Reconciliation by Period by Organizational Unit?
I'm newer to writing custom reports, but from reading over the documentation I'm imagining that I would be able to just write a query against the tables in the document with some sort of join to piece together what I need (let me know if that assumption is incorrect). However, I don't see a column for Unexplained Difference so I'm thinking maybe this requirement is dead in the water anyway. Any insight would be greatly appreciated, or if there is a better approach out there for this requirement I'd love to hear suggestions.