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

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans