Select employee time for a given cost category in Microsoft Dynamics / Great Plains

I'm trying to generate a report where each line is an employee and the columns represent fixed cost categories. In each cost category cell for each employee I need to be able to select (and sum) all of the time for the cost category.

Unfortunately my problem isn't related to syntax it's related instead to my ignorance of the Dynamics/GP databases. I don't actually know what database table that time is stored in at all and I haven't found a nice solution for looking up tables and their contents.

Does anyone know which tables/views that would contain the info that I need?

Thanks.
LVL 3
coandaAsked:
Who is Participating?
 
coandaAuthor Commented:
It's not for a payroll report, it's a time summary for certain types of time entries, eg. vacation, sick time, etc. I actually managed to find the tables that I needed by fuddling my way through GP and the database, the ones that I needed were PDK10000 and PDK10001.
0
 
James GlaubigerCo-FounderCommented:
Is this for a Payroll report?

If it is, take a look at the UPRxxxxx tables in the company database.   Specifically UPR30100 & UPR30300 & UPR30400 & UPR00100
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.