peo
Troubleshooting with SQL Profiler
One of the Payroll Specialists called us today, wondering if her session in Darwin was hung up and needed to be killed. Darwin, as I may have mentioned before, is a Microsoft Great Plains Dynamics product customized for the Professional Employer Organization (PEO) industry. We have SQL Server as the back-end. The IT Manager asked [...]
Finding Tables for Employee Census Report
This is one of the posts where I describe the more technical aspects of a project I’ve been working on. The contents here are meant mainly to trigger my own memory when needed in the future. The HR department has requested a census report so that the company can shop around for benefits with other [...]
Reorganizing clients in Darwin provides opportunity for SQL Server clean-up
This is a post where I share more of the technical aspects of my job as a ‘conscientious programmer/analyst’. The company I work for is reorganizing clients into new databases in the Darwin business system (a customized version of Microsft Great Plains Dynamics), and the business sees this as a great opportunity to clean up [...]
05 Nov 2007 – Utterz from the road
Three topics discussed: Effects of Daylight Savings Time ending one week later this year, especially on the commute home. New Media Cincinnati: http://www.newmediacincinnati.com or http://danieljohnsonjr.com/2007/11/new-media-cincinnati-meetup-november.html Dashboard-types of reporting I’ve been doing to provide a good pulse on the company. I love doing this kind of marketing-type of analysis. Hear all my Utterz: http://www.utterz.com/~h-danieljohnsonjr/list.php —–Check out [...]
Keeping upper management knowledgeable and salespeople paid
This is another post where I share technical details about a project I have been working on. SITUATION Sales executives within the company receive monthly commission checks based on active client employee counts and gross payroll, for clients that they have brought on. In addition, upper management needs to see high-level numbers such as active [...]
Reaching the point of diminishing returns on a project
Over the past month, I have been working on a project to automate payroll entry for a client that has close to 300 employees and is growing. Naturally, it is the company’s best interest to get this payroll automated as much as possible. To do this I’ve been developing an application to bridge the payroll [...]
Server-side processing rocks the house!
I’ve spent the last couple of weeks learning how to optimize the search tool we built. The short story is that we’re now using a pass-through query in Access to pass parameters to stored procedures on SQL Server. Processing time has gone from about 2 minutes to less than 2 seconds. Now that I know [...]
Microsoft Great Plains – Integration Manager in action
The company uses a version of Microsoft Great Plains (GP) that’s been customized for the PEO industry. One piece of that is Integration Manager (IM). I’ve talked about the bridge application a number of times before. With an Excel file from a client and, with some sophisticated programming, we create a tab-delimited text transaction file [...]
At a Conference in Downtown Cincinnati
Over the next few days I’ll be attending a conference in downtown Cincinnati. I’m really glad that I’ll be able to catch the bus instead of driving the hour commute to Dayton. The conference is being conducted by Thinkware, a vendor that has — and I’m probably oversimplifying this — customized Microsoft Great Plains for [...]
Helping company take advantage of a tax credit
Image by alberth2 via Flickr I found out last year from the Accounting department at my current company that employers with tipped employees can get a tax credit based on how employees have reported their tips. I guess it’s the IRS’s way to encourage employers to get their employees to report tips so that they [...]
