Many times when generating a report that deals with a large volume of data, say, a GL report for the entire year, you may end up getting the following error message: Request Timed Out. This occurs as there is a lot of data to be processed and presented on the report page, but not enough server resource hence resulting in a time out.

For better processing of such reports, ERPNext offers Prepared Reports (since v11). When a report is set as a Prepared Report, it is generated through a background job, and once ready, is available for users to view



How To Use A Prepared Report   

  1. Open said report (say General Ledger) and apply all filters needed.
  2. If the prepared report option is enabled for that report, you will see a Generate Report button. Click on the same. Generate Prepared Report
  3. You will see a notification on the bottom-right of the screen saying "Report initiated. You can track its status here" Prepared Report Initiated
  4. You can either wait on the said screen or click on here in the above message to open the page for the report. This will open a new page for the report: Prepared Report Queued As you see, the report page has status as "Queued". Once the report is ready, you will see a Show Report button which you can click to view the report: Prepared Report Initiated
  5. Since Prepared Report is also a doctype, to view the list of Prepared Reports, you can use the Role Permission Manager to grant access to the same.