What's new in Customer Journeys?

Connect and learn more! ×
Is There Way to Join Subledger to Payables Invoices via Query? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is There Way to Join Subledger to Payables Invoices via Query?

Question
40
Views
0
Comments

Summary:

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!