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?
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
Time Corrections for Reports
Working with a report, we made some interesting discoveries about the time corrections/updates
We are using the following Parameters:
Starting Entered Date (Date) formatted as Data type: "Date/Time"
Ending Entered …
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 …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online.
The email signature template has been downloaded from:
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers.
According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…