Looking Back

By Chris Walker posted 12-16-2011 17:41


Unless something happens that requires a pretty quick response, this will be my last post of 2011. And since it’s the end of the year I thought I’d do like so many others and take a look back. However, I’m not looking back at stuff that happened during the year; I’m going back to 1991, to a project and period in my career that I really, really enjoyed. I consider it the first ECM project that I worked on, though I'd never heard of ECM at the time. It’s also the first independent consulting gig that I took on.

In September of 1991 my wife was asked to move from the Montreal area to the Toronto area for what was supposed to be a maternity leave replacement as one of her colleagues had just had a baby. Since the alternative was unemployment for her, and since I wasn’t working anyways (I was back in school) we decided to make the move. The company she worked for was a small distributor of electronic components (switches, plugs, receptacles, etc.). Their clients were mostly in Canada, with a few in the U.S. Their suppliers were predominantly in Europe and Asia, with a few in the U.S. They also had to deal with transport companies and customs brokers/agents in order to carry on their core business.

My wife’s job was to handle sales orders, purchase orders, customer service, transportation, and customs (I did say it was a small company). Other roles in the organization included one accountant/bookkeeper, some sales guys, a general manager, a warehouse dude, and the owner (one of the nicest guys I have ever worked for or with). I was engaged to implement some accounting / order processing software for them (ended up selecting ACCPAC vWhateverWasCurrentIn1991). I eventually ended up doing double-duty as the IT / Warehouse dude (regular whse dude ended up in jail, I ended up reporting to my wife – oh the fringe benefits).

This company was really excited to be getting their first computerized system of anything. Included in the bundle of stuff that they were getting was a rockin’ 24-pin, tractor fed, colour, dot matrix printer to handle their multi-part forms. They could only afford one colour monitor so there was a discussion about who’d get it and who’d get stuck with the grey-scale monitor. The fax machine used rolls of thermal paper (I’m sure at least one of you reading this has no idea what I am referring to). Printing to the correct printer was controlled by turning the switch on the printer switch box (I still have one in my basement somewhere). Everything, even the stuff that was born digital, was stored in filing cabinets, and everyone had their own copy (we hoped), whether or not they needed it.

Every customer, supplier, and vendor had a file. These files were kept in the GM’s locked office, which wasn’t generally a problem until his love life fell apart and he started taking “mental health days” several times a week. Orders from the customers came in by phone or fax. Faxes were great, especially when several orders came in overnight and needed to be separated from each other using scissors. Confirmations from suppliers were received by phone, fax (see point about customer orders), and mail (sometimes after the order itself). Customs paperwork came in by courier (time was of the essence) or fax. Outbound paperwork was couriered, faxed, or mailed. Sometimes the same document was delivered by all three methods, just to be sure. Internal – internal paperwork was walked to the recipient, except for the out-of-town sales guys who got their stuff via fax (including a nude picture from a calendar we got from a Taiwanese supplier – very tasteful, too bad I sent it to a customer by mistake, oops).

But, they had ACCPAC now. I don’t remember exactly which modules I implemented for them, but G/L, A/R, A/P were part of the mix. Not only did they have automated accounting software, we even went so far as to try to eliminate some paper duplication and streamline some processes. There was certainly some resistance (mostly from the accountant/bookkeeper but she went batty, got fired, and hid a CDN$36k tax bill in the customer invoice files). The point is that there were improvements made, even if we couldn’t apply automation to everything. And I made really good money (by the standards of the day), wasn’t on the clock 24/7 (no cell phones or internet), had plenty of time for me (and my wife/boss), and delivered a project I felt really good about. As things turned out, the company offered my wife and me permanent positions, but we missed Montreal so declined and headed home.

If I had to do that project over again today I would, assuming that the client could afford my rates. I’ve learned a lot (and made mistakes from which I’ve learned) over the last twenty years, so I certainly wouldn’t do things the same way, process or approach wise. The biggest difference, however, would be in the technology. Not only are the tools we have available today much better than what they were back then, they’re enormously less expensive when you consider what you get for your money. In fact, I’d guess that much of the software they’d need for today’s conditions could be had from truly viable open source sources. So maybe they could afford me, after all.

I was going to write a long-ass section detailing what I’d implement to handle which bits of the business, but I changed my mind. We all have an idea of what we’d do with this type of a project.

#opensource #paper #process #ACCPAC #ECM