Description of Issue:
We are trying to print AP Checks and are receiving a message “No checks found".
How can we correct this error?
Resolution:
We have seen this error from printing checks, and it may also show up in other forms or reports that use the SedonaReports user for database access.
The application is trying to retrieve data from the database and cannot open the database connection using the SedonaReports User.
To correct this be sure that the SedonaReports user has the correct rights to the SedonaOffice database where they are seeing the problem.
Use the steps below to correct the issue.
Open SQL Management Studio
Log into the server where the company databases are located.
Under the Serve select the Security Tab.
Double Click on the SedonaReports to see the properties.
You can also Right Click and then select Properties on the menu.
You can also Right Click and then Select Properties on the menu.
In the SQL User Properties, select User Mapping
We have seen this error when the SedonaReports SQL user does not have rights to the database where the checks are being printed.
You will need to select the database where they are having the issue and give the user the Database Role of dbo.datareader.
Save the SQL User changes and then try printing the checks again.
