web

You’re offline. This is a read only version of the page.

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,130

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Nanook Software 2 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Alaa Ramadan 4,130 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans