Is There Way to Join Subledger to Payables Invoices via Query?
Is there a way to join Payables Invoices - Transactions Real Time to Subledger Accounting - Journals Real Time via a SQL query?
Content (please ensure you mask any confidential information):
We need to report the most recent coding for an invoice line and since our Accounting team is using the override function, there isn't a way to see what the most recent coding is when they override the same line multiple times in one day. In the Subledger - Journals Real Time subject area, there is an accounting date with a time stamp. But joining the two subject areas in OTBI results in an error.