Sometimes staff has to do the work...
As a child, I was attracted to computers because of the games. As a young professional, I was attracted to computers to make my life easier (because I'm inherently lazy!). So when I work with my clients, I love to automate as much as can be automated. But sometimes we just gotta do the work ourselves, because it makes no sense (time or money or both) to try to make the computer do the work for us.
Case in point: a client of mine was recently trying to figure out how to make their database manage deferred revenue for ad insertions in their magazine. Their practice (a common one) is to book the order now but not invoice for the ad until the magazine is printed. After much discussion about what it would take to program the database to manage this, a wise staffer pointed out that staff could just capture the orders when they are originally placed (no financials associated with the orders), and create the invoices after the magazine had printed. Thus no need for deferred revenue. Problem solved!
Would it be "easier" for staff if the system would manage deferred revenue and they could create just one invoice and be done? Yes, it would. But the reality is that the magazine only prints every other month, and there are fewer than 20 ads per issue, so staff has to create 20 invoices once every two months. Maybe two hours of work.
It's not automatic, but it's not that much work, and it's far less expensive than trying to program the database to do it for them. Sometimes staff just has to do the work.
Wes's Wednesday Wisdom Archives
A Data Integrity Report…for Reports!
I’ve written elsewhere about the value of data integrity reports. But one of the most […]
Simple rules for complex systems
Simple rules for complex systems I first heard the phrase “simple rules for complex systems” […]
Accentuate the positive
Accentuate the positive I’ve written before about the importance of database public relationsand celebrating success. I’ll add […]
Annual dues vs. anniversary dues
Annual dues vs. anniversary dues I served as director of membership for several years at […]
A change of systems requires a change of mindset
Every AMS vendor will tell you that the toughest part of implementing a new system […]
It doesn’t have to be optimal to be beneficial
It doesn’t have to be optimal to be beneficial I’m a big fan of the […]
Look for small wins
Look for small wins One of the toughest things about system implementation is simply how […]
Are you closing the loop?
Are you closing the loop? If your association does a call for presentations for any […]
Declare victory and move on
Declare victory and move on The law of diminishing returns is the point at which the […]
Clean as you go
Clean As You Go A good cook or baker knows that, when working in the […]