Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Advanced Labor Reporti...
Microsoft Dynamics GP (Archived)

Advanced Labor Reporting Codes - Possible to modify the Productive / Non-Productive label on Pay Code and what table is the value stored ?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We don't use the productive / non-productive terminology for the pay code options, we classify by maintenance and non-maintenance pay codes for our insurance workers comp. I'm wondering what table the setting is as i'd like to bulk update all the pay codes to reflect 'non-productive' (Assuming i can't modify the term non-productive to non-maintenance). I figured it was in the UPR40600 table but it's not obvious if it is.

Over all I want to use the advanced labor reporting to generate a report showing quarterly maintenance  / non-maintenance gross wages. In addiiton I'd like to be able to split these by regular wages and over time wages for the quarter.

Similar to 

regular wages

                 maintenance                                  non-maintenance
Qt1                100,000                                        150,000

Qt2                125,000                                        110,000

overtime wages 

Qt1                  56,000                                          63,000

Qt2                  45,000                                          55,000

*This post is locked for comments

  • Suggested answer
    Thomas Franz Profile Picture
    Thomas Franz 1,105 on at
    RE: Advanced Labor Reporting Codes - Possible to modify the Productive / Non-Productive label on Pay Code and what table is the value stored ?

    You are correct in that you cannot change the terminology per se. You could modify the labels on the report.

    As background, "Productive"/"Non-Productive" status is tied to a GL Unit Account. This information is stored in the APR_GL00100 table. If you want to split up this report, you will have to have separate unit accounts tied to the various pay codes in Payroll Posting Account Setup and have them assigned accordingly in the Labor Reporting Accounts window (Tools > Setup > Payroll > Advanced Labor Reporting > Reporting Accounts).

    Hope this helps.

  • Chris.Hadden Profile Picture
    Chris.Hadden 726 on at
    RE: Advanced Labor Reporting Codes - Possible to modify the Productive / Non-Productive label on Pay Code and what table is the value stored ?

    I'm not sure of the exact table, however I do believe the Advanced Labor Reporting Codes are managed through the Advanced Payroll module, so the table would begin with "APR_".

    Hopefully that will help you get pointed in the right direction.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans