We have a situation in which we have an employee who received an Advance in 2019. The terms of the repayment were to start on the February pay period.
Looking at the Employee Card we not that in the Calculated window the amount of the Advance is showing correctly at 500.00
Prior to processing the payroll, administrator edits the Advance Reclaim paycode and enters the amount of 83.00 - amount agreed to repay per pay period
Builds the payroll batch as done for the past 10 years - no errors and prints the Detailed Advice Slip from Cheque Reports.
The 83 dollar deduction is not there.
Admin goes to the Payroll Batch create, selects OPTIONS and changes the Advance Reclaim to YES
Re-generates and re-runs report - now the 500 is there as a deduction
Admin goes back to the Quick Transaction and adds the line for Advance reclaim deduction code and enters the 83 deduction, changes the OPTION to NO for Reclaim in the batch
Re-generate and re-runs report - now the 83 is there as a deduction ( sort of )
Admin is satisfied that this is good - generates the DIRECT DEPOSIT file - sends to the bank - no errors
Admin now proceeds to Create Posting file and the system coughs out an error that the Journal Entry is not balanced - guess what - it is out of balance by 83
***
For the solution we
- edited the Employee Card and changed the Advance to 83
- removed the quick entry line for the Advance Reclaim
- changed the batch option for the reclaim to YES
- re-generated the batch, printed reports and the 83 was in fact deducted from the employee cheque.
HOWEVER we then determined that the amount that was processed earlier ( sent to the bank ) for this employee did not in fact have the deduction of 83 removed from the NET pay. ( as example only ) Should have been paid 2500 and was paid 2583
Employee has agreed to pay back the 83 so all is well, however, the admin has to go through this process until the entire Advance has been recovered.
The Employee Card - shows that the advance has been repaid - not true - it is only down by 83. Solution is for the admin to edit this field each time and enter the amount of 83 - but errors can happen and then what.
***
So in the end we need to know what to change to make this work correctly. This is not a new client, this is not a new admin user, this is not a new employee. Running GP2018 with the latest Payroll Year end patch in place - thinking not a code error - but a functional issue with Canadian Payroll.
Thanks for taking the time to read this - hoping someone will have a solution for me.