The Payday Filing Employment Information file contains employee transactional data related to the pay period. Data is only available in the file once you have performed Generate Payments. Once Payday Filing has been exported to IRD (the files created), the data will no longer appear on the screen.
If you regenerate the Payments file, the data will be excluded from Payday Filing. Regenerating the file can occur if, for example, the bank file has been deleted. In this situation, you would recreate the file by going to Payroll, Transactions, Import and Export, Generate Payments, and ticking Regenerate Processed Employees to recreate the file. To repopulate the data for the payday filing, you will need to restore your data. Restoring your data means that you will lose any changes made to the database since the backup was taken. You will need to make these changes again once the restore is complete.
If you are missing data from the Payday Filing screen:
Check that Payments were Generated:
Go to Payroll, Transactions, Import and Export, Generate Payment.
Select all for Payroll Company and Location.
Leave From Employee and To Employee blank.
Select the Pay Frequency and Period End Date (after selecting the Company Bank)
For Company Bank, select the first option. This may not be the normal bank account.
Click Preview.
Repeat these steps, selecting a different Company Bank each time to find any outstanding transactions associated with a Company Bank account.
If you find outstanding transactions, create the file. If the Company Bank is incorrect, you can delete the transaction, edit the Employee record to correct the Bank Details, re-enter the transaction and then generate the bank file.
Check if the Payday filing has already been run using one of the IQB-ESCT Reports:
Go to Common, IQ.
Select either IQB-ESCT01 - ESCT Details or IQB-ESCT02 - ESCT Totals.
Enter the Period End Date in Period End Date From and Period End Date To.
Click OK.
If data appears on the report, then Payday Filing has been exported.
If all transactions have been included in a bank file but the Payday filing has been created, then the bank file may have been regenerated. You can restore to before generating the bank file and repeat the Payroll processing steps to see if the correct data appears in Payday Filing. When restoring your database, you will take your data back to what it was current at the time the backup was taken. Meaning you will lose changes made after the backup was taken. It may not be feasible to restore if lots of changes have occurred.
Take a backup.
Restore the backup you took before Generate Payments. Refer to the article How do I Backup and Restore? for steps on restoring your database.
Once the data has been restored, go to Payroll, Transactions, Import and Export, Generate Payments.
Enter your parameters again and click File to generate the bank file again. Discard this file if you have already uploaded it to your Bank.
Then go to Payroll, Transactions, Import and Export, Payday Filing.
The employment information should be displayed.
If the Payday Filing has been exported or you can't restore, raise a case online. Include the title of this article in your description and details about your case.