News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Regenerating payslip C...

Microsoft Dynamics GP (Archived)

Regenerating payslip Canadian payroll

(0) Share

Report

Report

Posted on by Alaa Ramadan

4,084

I'm trying to regenerate the payslip from CPY30260 table - Canadian payroll.

In many cases an employee could have a zero OT in the current payslip but the YTD has value from pervious batches.

I still want to show the YTD in current payslip.

In that particular case the OT pay code with zero value for that particular employee/batch is not showing in CP30260

I thought it might be in CPY10160 which YTD paycode but for some reason this table does not even include all batches which are showing in CPY30260

Appreciate any hint.

Thanks

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Alaa Ramadan 4,084 on at

Like (0)

Report

RE: Regenerating payslip Canadian payroll

Thanks, I can simply do that but I'm not sure what other tables that contain the YTD pay code
Suggested answer

Nanook Software 587 on at

Like (1)

Report

RE: Regenerating payslip Canadian payroll

Out of the box from the reports this can't be completed. The data in CPY30260 only shows data that has entries from that individual payruns.

I understand you want to show all of it, you need to develop your own report that has this information. SQL views / temp tables or SSRS or some other report form.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans