Solved

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

Posted on 2009-03-30
2
546 Views
Last Modified: 2013-12-11
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.
0
Comment
Question by:coanda
2 Comments
 
LVL 7

Expert Comment

by:James Glaubiger
ID: 24045966
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
 
LVL 3

Accepted Solution

by:
coanda earned 0 total points
ID: 24051960
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now