Solved

GL Voucher Analysis

  • 8 February 2021
  • 2 replies
  • 646 views

Userlevel 5
Badge +8

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?

icon

Best answer by Nick A 8 February 2021, 21:34

View original

2 replies

Userlevel 4
Badge +6

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.

 

Regards

 

Nick

Userlevel 5
Badge +8

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.

 

Regards

 

Nick

Hello Nick,

 

Thank you so much for your quick help. Actually 100k lines applicable for a single period. So I will run Archive GL Voucher process and see the performance. 

 

Regards

Thakshila

Reply