Downloading/exporting General Ledger Detail Reports - so slow

Posted By Stacy Knipper 1 month ago

It takes longer than I consider normal to run the GLDR, print to PDF, and export to .xls. Does everyone have a slow export? I miss my last job's accounting software that had instant GL downloads (smart lists in Great Plains). Is there a way to speed it up? Is this a server/cloud thing? I'm not tech-savvy, and I'm new the company, I'm not sure how we have Sage configured. Thank you for reading.

Top Replies

BigLouie 1 month ago +1

I would suggest going to General Ledger, Explorer, Account Transactions, Filter for Posting Date, Source Journal and Journal Register and then go to File, Export Options and export to Excel.

Parents

0 connex 26 days ago

With BOI scripting and a Excel VBA macro one can use the nSelectReportSetting and nProcessReport methods on the 'GL_DetailReport_rpt' object to load the desired fields of the 'GL_DetailReportWrk' table directly into an Excel worksheet table. It's much faster than querying the original tables. Then filter to your heart's desire. Especially helpful is the Excel SubTotal function that can sum/count fields and ignore rows hidden with table filters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 connex 26 days ago

With BOI scripting and a Excel VBA macro one can use the nSelectReportSetting and nProcessReport methods on the 'GL_DetailReport_rpt' object to load the desired fields of the 'GL_DetailReportWrk' table directly into an Excel worksheet table. It's much faster than querying the original tables. Then filter to your heart's desire. Especially helpful is the Excel SubTotal function that can sum/count fields and ignore rows hidden with table filters.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 100

Downloading/exporting General Ledger Detail Reports - so slow

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING