Troubleshooting Guide: Transaction Report Not Returning Data

Modified on Tue, 15 Oct at 11:03 AM

If your transaction report isn’t returning any data, there are a few common issues that might be causing this problem. Here’s a step-by-step guide to help you identify and resolve the issue.

1. No Data Posted to the Nominal Code

One of the most frequent reasons for an empty transaction report is that there are no transactions posted to the selected nominal code. To verify this:

  • Check the nominal code you're reporting on to ensure it has entries within the specified date range.

2. Incorrect Date Range

Another possible issue could be the date range you’ve selected for the report. If the date range doesn’t cover any transactions, the report will return no data. Ensure that:

  • The dates entered are correct and cover the period for which you expect to see transactions.

3. Configuration Issue in the Transaction Report Setup

If the nominal code has transactions and the date range is correct, the issue may lie in the setup of the transaction report itself. A common problem is when the same column is mistakenly added twice in the report configuration, which can prevent the report from displaying correctly.

Here’s how to check and correct this:

  1. Navigate to: Accounts > Nominal Ledger > Utilities > Setup > Transaction Reports.

  2. Select the Standard Nominal Transaction Report from the list.

  3. Review the displayed columns in the report configuration.

  4. If you see any duplicated columns, double-click the duplicate to remove it.

  5. Once you’ve made your adjustments, press Save to apply the changes.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article