web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Regenerating payslip C...
Microsoft Dynamics GP (Archived)

Regenerating payslip Canadian payroll

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Nanook Software Profile Picture
    Nanook Software 2 on at

    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.

  • Alaa Ramadan Profile Picture
    Alaa Ramadan 4,130 on at

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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans