GL Voucher Analysis

Question

In Apps8 environment trying to run a report for an annual audit to show all financial transactions from Oct to Dec 2020. The report path is Operational Reporting > Order Report > General Ledger Report With Counter Account. Running the report is very slow, and November could not be run successfully even after waiting 3 hours with the process running in the backgrounds.

There is another way to run an excel based download of all journals through the “GL Voucher Analysis” function. This returned 102,237 records which took about 4 hours to extract to excel, but that excel file only has 100,000 rows of data implying some are missing due to output channels maximum no of row limitation.

Can you advise the best , most efficient way to get these reports run for auditing?

Nick A · Accepted Answer

Hello,Have you considered using a quick report or SQL query to extract the data? These will work quicker, and although they still go into excel and there is still the limitation of 100k lines, you should also consider breaking these down into at least periods, as the use of Excel will still limit the 100k lines irrespective if you can get them all out quickly or not.May I also ask, is the 100k lines for 1 single financial year, or everything that exists in the history of the application since implementation?If it’s for a single year and the voucher analysis is taking a long time, check if you have run Archive GL Voucher process as this will SIGNIFICANTLY improve the performance of the GL Voucher Analysis if it only has current data in it.RegardsNick

Thakshila · Answer

Hello,Have you considered using a quick report or SQL query to extract the data? These will work quicker, and although they still go into excel and there is still the limitation of 100k lines, you should also consider breaking these down into at least periods, as the use of Excel will still limit the 100k lines irrespective if you can get them all out quickly or not.May I also ask, is the 100k lines for 1 single financial year, or everything that exists in the history of the application since implementation?If it’s for a single year and the voucher analysis is taking a long time, check if you have run Archive GL Voucher process as this will SIGNIFICANTLY improve the performance of the GL Voucher Analysis if it only has current data in it.RegardsNickHello Nick,Thank you so much for your quick help. Actually 100k lines applicable for a single period. So I willrun Archive GL Voucher process and see the performance.RegardsThakshila

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded