microsoft great plains
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 [...]
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 [...]
