Skip to Content
0
Former Member
Dec 09, 2011 at 02:32 AM

Capturing GL balances snapshot with very large movement transaction

53 Views

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