payroll
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 [...]
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 [...]
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 [...]
Migrating Existing Access Applications to Access 2007
This post is one of the more esoteric ones where I delve into the geeky details of some of my programming work. I know – it’s really sexy, isn’t it? I have mentioned the bridge application I developed that helps make payrolls run faster, helping client employees get paid faster, and so forth, using Microsoft [...]
Helping 145 employees get paid
Not my normal function, but the payroll specialist was in a pinch, so she called and asked me to run the program that loads transactions into the business system, helping 145 client employees get paid on time.

