Summary

Problems with report balancing can most often be attributed to filtering that has been applied to exclude a required field.

Reports do not balance

Is there a query applied to either the database or to the report?
For example, if you are running Financial Year End reports, a query may be applied for current employees which excludes employees terminated within the last financial year.

Does the report have tabs, which give you the option to tag a department or location?
Ensure that no departments or locations have been tagged.

Does the filtering you have applied balance?
For example, you can apply a query to report on selected allowances, but ensure you tag the Transaction Type as 'Allowances' or 'Both' and not just 'Deductions'.

Does the report have the option to select standard, manual or both?
Ensure you have selected both.

Are you opening the report from the Inbox?
There may be more than one instance of the same report, so confirm that you are opening the report with the expected date/time modified.

Do you have Internal Companies?
Check if Internal Company Filtering has been applied.

Reports are blank

Has the PayGlobal database been upgraded?
Ensure that you Import the report catalogue.  If you are unsure if the report catalogue has been imported, there is no adverse effect if you Import Reports again.

Do you have Designer reports?
Check the troubleshooting for Designer reports.

Report descriptions have not updated

Report descriptions do not automatically update. Report descriptions will only be populated with the title of the report definitions when a new report is added to a report group. Where a report already exists users must manually edit the Report Description field on the Report Group Reports form.

To do this:

1. Navigate to Reports | Report Groups.
2. Open the required report group by double clicking the code or description.
3. Click the Edit button of the Report Group.
4. Double click the report with the incorrect description.
5. Click into the Description field.
6. Edit the description.
7. Click the Save+Close button.

Terminated employees on reports

Ensure you have set the terminated employees flag to Exclude Terminated on the report.

Error: Incorrect syntax near '.'

If this error occurs when you try to run a report, then you need to check the following.

Check Database Compatibility Level

PayGlobal no longer supports Microsoft SQL Server 2000 so the script that allowed you to run reports on a SQL Server 2000 database was removed.

To change your database properties:

1. In Microsoft SQL Server Management Studio, right-click the database and click Properties.
2. Click Options.
3. Change the Compatibility level from SQL Server 2000 (80) to SQL Server 2005 (90) or higher.
4. Click OK.

Check SQL.dat file | TIMEOUT

Open the database Perm folder | SQL.dat file and ensure that TIMEOUT = 3000 or higher, especially if you have a large database.