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
Positive change is harder to see
Positive change is harder to see Humans are wired to see negative change because we […]
MVP: Minimum Viable Product
MVP: Minimum Viable Product In product development there is a concept known as MVP, or […]
You always need a reason for collecting data
You always need a reason for collecting data When you ask for data from someone […]
If you’re unhappy, speak up!
If you’re unhappy, speak up! My clients will often ask me something along the lines […]
Does it advance the mission?
Does it advance the mission? Because associations are mission-driven, everything you do should be seen […]
How should you start a new data project?
How should you start a new data project? When you’ve got a new data project […]
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 […]
