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

Query to capture daily balances from gl_daily_balances_v / gl_daily_balances table

in General Ledger & Intercompany 1 comment

Summary:

We need to capture the daily opening balance, credit balance, debit balance, and closing balance for both functional and entered currencies. Although ADB is currently enabled and data is being populated in the gl_daily_balances table but the balances in the column END_OF_DAY1, END_OF_DAY2, END_OF_DAY3….. are not populated, the method of data maintenance within the table is not entirely clear. Has anyone encountered a similar requirement and developed a report to address it?

Any sample query same is highly appreciated

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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