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

Journal entry listing

edited Jan 30, 2019 4:30PM in General Ledger & Intercompany 4 comments

Summary

Trying to figure out how to pull a listing of all journal entries posted to a specific GL account across multiple companies and multiple ledgers.

Content

Hello, we have just recently implemented the Oracle Cloud Fusion GL.  We would like to be able to query a listing of all journal entries posted to a specific GL account.  We want the option, but not the requirement, to narrow down the entries by the following attributes:

-Ledger(s)

-Company

-Month(s) or Date Range

-Currency

-Responsibility Unit

We have been using a custom BI Publisher report that has all of these fields as optional, but the report takes 10-15 minutes to run and another 5-10 minutes to download to Excel, so we are looking for a more efficient online solution, preferably one where the activity displayed can be exported to Excel.  I've also tried the Account Analysis report and the various Balance Inquiries available in the Period Close screen, but these were either too restrictive or timed out even for accounts with minimal activity.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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