When you select all PRNs (Payment Reference Numbers) in Creditor EFT Export for the Beam_SCH creditor, it will pick up all outstanding payments, even those relating to the previous tax year. The PRNs for the previous tax year won't appear in the Transaction Lodgement reference unless you tick Previous Year.
So that the Creditor EFT Export only extracts payments for the PRNs processed in the current year, you need to clear the previous year. Before you start, check whether the payments relating to the previous year have been paid. If you have:
made the payment, you need to generate the file and discard it.
not made the payment, create the EFT file with the correct Date to be processed by the Bank and submit it to your bank.
made the payment for some of the listed PRNs, you will need to generate two files. One for the payments that have been made and discard this file. And the second with the correct Date to be processed by the Bank and submit to your bank.
To clear the PRNs for the previous year:
Go to Payroll, Transactions, Import and Export, Creditor EFT Export.
The Process Date defaults to the latest completed period end date. When you select Beam_SCH as the creditor, the field will be greyed out and can't be changed. To select a period end date that the batch relates to, change the Process Date before selecting the creditor.
From the Creditor drop-down list, select Beam_SCH.
Select the Payroll Company or leave as <All>.
Tick Previous Year.
Select the PRNs to be included at Transaction Lodgement Reference.
In Date to be Processed by Bank, enter the date on which the payments are to be made.
Tick Overwrite File if Exists to overwrite any existing file in the destination path. If this is not selected, the transactions will be appended to the existing file.
To check the amounts to be paid, click Print or Preview to generate the Creditor EFT Report. The values can be checked against the Super Clearing Batch totals.
To create the file, click EFT File.
Move or rename the EFT file.
Once you have cleared the previous year's payments, you can produce the Creditor EFT for this year's payments.