Need BIP report SQL query to get GL Balances by Posting Date
Maybe these will help you what you're looking for
https://www.enginatics.com/reports/gl-trial-balance-detail/
https://erp-integrations.com/2017/01/23/query-to-check-gl-period-begining-balances-with-previous-period-ending-balancecompare-period1_end_balance-with-period2_begin_balance/
https://rpforacle.blogspot.com/2020/07/ytd-balance-query-in-oracle-apps.html
Brendan gave a number of options to explore.
It would be nice if you could write a proper question, with some context, and at least what product you are using.
I imagine you aren't using FDI, but building a report on Fusion. In that case, this is not the right forum: Fusion data questions should be posted in https://community.oracle.com/customerconnect
@Kalyani-Oracle , please use this specific forum General Ledger & Intercompany — Cloud Customer Connect to ask your question. You can search also for already answered questions, and it might help you get the answer for your question.
Hope it helps!
