Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Canadian Payroll - Advance Reclaim

(1) ShareShare
ReportReport
Posted on by 12

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.

Categories:
  • Cheryl Waswick Profile Picture
    on at
    RE: Canadian Payroll - Advance Reclaim

    Bill, There is an 'import and export' utility, where you can import paycode data.  If you had the batch ready to go, you could just import in the same batch each time.  But that's about all I can think if you want a certain amount taken and don't want to hand-key it.

    Cheryl

    Microsoft support

  • Suggested answer
    Cheryl Waswick Profile Picture
    on at
    RE: Canadian Payroll - Advance Reclaim

    Hi Bill,

    I was able to get the Advance Reclaim code to automatically be included in the batch, but it took all that it could, not just the amount I have indicated on the employee paycode setup.

    -I created the batch as an hourly batch.   (The 'prevent reclaims' option is set to NO on the batch.)

    -I verified the employee had an hourly code assigned to them that was set to auto-select.  And also the Advances code, and the Advance Reclaim code assigned to him.  (You cannot mark the Advance Reclaim code to auto-select. )

    -I verified the employee had an Advances Outstanding amount on their Calculated tab.  $475 in my case.

    -I also have the advance reclaim code selected under Tools | Setup | Payroll Canada | control | paycodes.

    -Now I generated the batch and calculated the batch.

    -When I print the calculated report/detailed advice slip, the Advanced reclaim code is listed and it took all that it could (the full $475 ) to get the advance back.

    -I generated the poster file, and printed the posting journal and the amount of the reclaim did hit the GL account selected on the deduction setup for the advance reclaim code.  The GL batch was balanced.

    -I tested again and this time set the hourly code to not auto-select this time.

    -I keyed one hour to an hourly paycode in the quick trx entry window for $22 pay rate.

    -My advances reclaim is set to $10.   (Total reclaim for employee is $50)

    -I calculated and generated the batch.

    -The calculated report shows that the advance reclaim took $21.65, all that it could on this paycheck.  

    So even though you can't mark it to auto-select, if they have the advance reclaim code assigned to them and an amount in the ADVANCES OUTSTANDING, it will still auto-calculate, but will take the full amount of the advance, or whatever it can.   This is the only way I could find it to work.  (I assume the rate at the employee paycode level is not used, because you are not able to mark it to auto-select at that level.  )

    Cheryl

    Microsoft Support

  • Bill Campbell Profile Picture
    12 on at
    RE: Canadian Payroll - Advance Reclaim

    Cheryl, why is it that we create a Deduction Code - ADVR and attache to the employee - and have a dollar amount there if the system requires that the user 'manually' enters the amount in the building of the batch?

    I would expect as does my client, that if I create the Deduction Code and put a dollar amount in it, that the Deduction code will be used - dollar value and all - but NO

    When I do what you do it works - but that is a manual work around

    I need to get this resolved now as this is now the 4th payroll for the client and she is getting pretty frustrated ( not at you - but me )

    Thanks.

  • Bill Campbell Profile Picture
    12 on at
    RE: Canadian Payroll - Advance Reclaim

    Thanks Cheryl, I will connect with the client and see that we have the same settings - pretty sure we are only missing one thing.

    Will report back to the fourm and update all on what we learn.

  • Suggested answer
    Cheryl Waswick Profile Picture
    on at
    RE: Canadian Payroll - Advance Reclaim

    Hi Bill,

    I was able to test this and it worked fine for me.

    I have a deduction paycode set up named "ADVR" and the reference of "Advance Reclaim', and allow transaction entry set to YES.

    I also have this under the Control setup window under paycodes for the advance reclaim paycode to be ADVR.

    I assigned this paycode to the employee and set a rate of $50.00 and a start date.   Allow trx entry is set to yes.

    I keyed an advance of $500 so the employee's calculated field for Advances Outstanding shows $500 to reclaim.

    I keyed a quick transaction entry for $25.00 for ADVR and calculated and posted the batch.  The batch option for "prevent reclaims' was set to NO by default.

    The $25 was taken from the employee's pay, and posted to GL.  The employee's calculated window now shows Advances Outstanding as $475.

    It's difficult to speculate what you have different.  Perhaps you want to open a support case so an engineer can look at all your setups.  I won't be able to do that in a forum post.   Be sure the batch option is set to NO.  Be sure the deduction paycode has 'Advance reclaim' reference.  On the employee, be sure the start date is correct and no end date.  Be sure to enter the advance reclaim in the company setup window for paycodes.  Maybe start over brand new with a new batch, etc. and try again.  

    Hope that helps.  I encourage you to open a support case if you need more assistance.   This is really a 'break/fix' issue and not a general question.  Thank you in advance.

    Cheryl W.

    Microsoft Support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans