Skip to Content
0
Jan 26, 2023 at 01:19 AM

General Ledger Accounting Report slow

197 Views

Hi All

Any idea how to solve if customer complain generating General Ledger Accounting Detail Report is too slow and not complete even after 2 hours running in the SAP Server?

I found SAP Note 2353620 but it is still show using SBO version 9.3?

2353620 - It takes a long while to display all General Ledger Report results

Version 1 from 11.08.2016 in EnglishDescriptionProductThis document is referenced byAttributesLanguagesActivate item to go to section in page

Symptom

When you try to display all the General Ledger Report results, it takes longer than expected.

Reproducing the issue

Prerequisites:

You have at least 30,000 transactions on General Ledger Accounts in the database.

Scenario:

  1. Go to ReportsFinancials → Accounting → General Ledger.
  2. Set the Selection Criteria that will return around 30,000 results.
  3. Run the report.
  4. Hit End key on the keyboard to load all of the results.
  5. Click Continue on the system message: This operation may take a very long time. Do you want to continue?

SystemMessage.PNG

  1. Wait until the results are loaded, do not click the mouse or use the keyboard until the process has finished.

Expected behavior:

It takes around 2 minutes to display all results.

Actual behavior:

It takes over 30 minutes to display all results.

Solution

SAP intends to provide a patch or patches in order to solve the problem described. The section Reference to Related Notes below will list the specific patches once they become available. The corresponding Info file of the patches in SAP Service Marketplace will also show the SAP Note number. Be aware that these references can only be set at patch release date. SAP will deliver patches only for selected releases at its own discretion, based on the business impact and the complexity of the implementation.

Workaround:

Click the General Ledger window during the process. The application stops responding and the results are loaded much faster. Once all results are displayed, the application starts responding again.

Other terms

slow, performance, hangs up, not responding, freeze, GL, G/L

ProductProduct or Product VersionSAP B1 9.1 FOR SAP HANASAP B1 9.2 FOR SAP HANASAP BUSINESS ONE 9.1SAP BUSINESS ONE 9.2This document is referenced byNumberComponentTitle2345631SBO-BC Overview Note for SAP Business One 9.2 PL05, version for SAP HANAAttributes