Applies to Product - Dynamics 365 Finance
What’s happening?
The customer is experiencing delays and errors when attempting to download the Voucher Transactions Report for a specific main account within the General Ledger module. The report takes an extended period (up to 30-40 minutes) to download and sometimes results in an error, particularly when run for periods longer than a month.
The customer is experiencing delays and errors when attempting to download the Voucher Transactions Report for a specific main account within the General Ledger module. The report takes an extended period (up to 30-40 minutes) to download and sometimes results in an error, particularly when run for periods longer than a month.
Reason:
This is specific to one main account with a high volume of transactions, while reports for other main accounts process without issues. The problem occurs in both UAT and production environments, and no customizations are involved; this arises with standard processes.
This is specific to one main account with a high volume of transactions, while reports for other main accounts process without issues. The problem occurs in both UAT and production environments, and no customizations are involved; this arises with standard processes.
Resolution:
To resolve this, the customer was advised to navigate to System Administration > Setup > Client Performance Options and change the Maximum Number of Rows setting to ‘Zero’. After making this change, the customer was able to download the report without encountering errors. However, it was noted that running reports for half-yearly or yearly data still takes considerable time, and further investigation into performance optimization may be required.
To resolve this, the customer was advised to navigate to System Administration > Setup > Client Performance Options and change the Maximum Number of Rows setting to ‘Zero’. After making this change, the customer was able to download the report without encountering errors. However, it was noted that running reports for half-yearly or yearly data still takes considerable time, and further investigation into performance optimization may be required.