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 great example of a data integrity report!
A great example of a data integrity report! A couple months back I discussed the […]
“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.”
“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.” I saw […]
Rather than adding something new, try subtracting
Rather than adding something new, try subtracting I read recently that sociological research suggests, when presented […]
It’s always people, process, and technology
It’s always people, process, and technology I speak and write a lot about people, process, […]
Once it’s lost, trust can be difficult to regain
Once it’s lost, trust can be difficult to regain I recall hearing once long ago […]
Share your successes!
Share your successes! I was speaking at an association meeting recently and one of the points […]
What are YOUR data integrity reports?
What are YOUR data integrity reports? Sitting in an AMS demo with a client recently, […]
You might have to do SOME of the work yourself!
You might have to do SOME of the work yourself! Many, many years ago I […]
Don’t manage to the exception!
Don’t manage to the exception! One of the universal truths about data management is, wherever possible, […]
It’s always about improvement
It’s always about improvement Talking with a client recently, she expressed frustration about one particular project […]
