A few years ago, I was working on an interface project, and wanted to have the ERP system send copies of any and all transactions that have changed over the past few days. I’ve done this before on other platforms, so I asked the lead developer what I thought was a no-brainer request:
- Do the transaction files capture a date/time stamp somewhere in the record, each time the record is modified – DateLastUpdated, something like that?
His answer came back almost immediately … No. Well, I guess this is possible, but we’re working with a fairly up-to-date ERP, and I’ve worked with enough systems and data bases to know that many/most applications timestamp their records when updating, or maybe write changes to a log file of some sort. And the answer came back just a tad too quickly … so I asked the question again, but this time I took some time to preface my question with an apology (of sorts) …
- I mean no disrespect, I am fully aware of your experience and skill on this particular platform – but I need to be clear, because I think I’m asking for something that’s fairly basic.I just need you to be a tad more specific when you say ‘the system doesn’t do that’.
Is it more accurate to say ‘I have never seen the system do that’ or do you know for a fact that that the system cannot do that?
It’s a subtle difference, but it’s important to drill into this level of detail. Most of us are pushed for time and quick to come up with the fast answers, so we can move on to the next item in the todo list. Answering off the top of our head is a pretty normal response, I do it a lot myself, but this was a pretty important feature request because the lack of it meant a ton of additional work in other areas. Besides, I’m humble enough to know there are many features and functions in any platform I’ve ever worked on that I don’t fully understand – never had the need. Plus, I don’t see a ton of wildly original thought and unique features in many of these system that we work with. In cases like this, I’m asking for something that I’ve seen in another platform, assuming that the author of this platform was a reason intelligent person and has added that same basic functionality.
Truth be told – in this instance, the transaction file in question did not have a DateLastUpdated field, and we had to look at transaction logs to get the information we needed. Still, the developer in question had little problem with my pushback; he readily acknowledged that he did not have the layout of this particular table memorized, and had never heard of such functionality – but the concept made sense, and he was happy to look. Besides, if his snap answer was wrong, it would have saved him a ton of work …
Drilling into the specifics like this (do you know No, or do you Not Know?) applies to more than just software developers. Engineers lawyers, accountants, sales reps – many folks from across the business are faced with questions that they try to answer from their Experience, hoping for the Quick Answer. It takes some confidence to question the “local expert” – but if the right questions saves a ton of effort, searching for a workaround – well, that’s an excellent question to ask.