Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-03-30
2
Medium Priority
?
589 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

604 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