Dear Guru,
I got a design question to ask/consult. Really appreciate if you could share and enlighten my analysis.
Currently, my env has daily posting of 500k line item capture in BSEG. Yearly, we have estimated 110 millions line items. Daily, when I need to extract and run the GL balance Report, it takes 7 hours to complete the run. The way the customised program coded is Opening Balance + Movement day + Adj entry.
Any idea how to improve the performance when processing such a huge records.
Hope to hear from you with many thanks.
Regards
Andrew