In Canada Payroll how can I remove old Paycodes from Detail Advice Slips

(1) Share

Report

Posted on by Judy Abbott

We have a number of old paycodes that still show on employee detail advice slips, even though they have been removed from their card.

Does anyone know how to clear these or is this something that only gets cleared out if removed from the cards prior to completing the YE procedure ?

Thanks !

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (1)

Bill Campbell 12 on at

Like (1)

Report
Copy link

Link copied!

Do you know if the Detail Advice slip is a custom report? If so, you might find out that the Paycode IDs were hard coded to the report. Have seen this in the past. Just a consideration.

Let me know if you want to discuss off line.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Judy,

If Bill's suggestion doesn't return a positive status due to a customization, you may want to look into the CPY10xxx or CPY30xxx tables, but they are numerous, so some research might be required.

CPY10100, CPY10140 & CPY10160 are you best bet for the current YTD data.

Table CPY50140 & CPY50160 will hold historical data with pay codes transactions.

Was this reply helpful? Yes No
Verified answer

Judy Abbott 35 on at

Like (1)

Report
Copy link

Link copied!

Hi Bill , I sincerely apologize, I never got any notification of a response to my question & when I checked it wasn't showing me any responses. I just happen to be looking up something else & saw this.

To answer your question , our detailed advice slip is a "modified report" called P_CPY_AdviceSlips_Detailed. Its the Canada Payroll version

If you happen to have time here is the 'Modified Report' Layout ( was done by one of our past controllers ) & I attached a sample paystub of what they look like .

The ones circled are the ones that dont exist in the on the Employee 's Paycode . No one has complained about this, but I had some time and thought I'd try to clean it up .

.

[View:/cfs-file/__key/communityserver-discussions-components-files/32/Sample-Paystub.docx]

Was this reply helpful? Yes No
Judy Abbott 35 on at

Like (0)

Report
Copy link

Link copied!

Thank you Beat , I just responded to Bill and I apologize to you as well. Not sure why I didn't get notification of responses even though I had it selected to receive them.

Was this reply helpful? Yes No