Blog > Purchase-order tracking application with Excel 2007: Kickoff

Comments Off on Purchase-order tracking application with Excel 2007: Kickoff

Purchase-order tracking application with Excel 2007: Kickoff

Posted by on Tuesday, October 17th, 2006

The company I work for, Cogniview, offers customers various ways to purchase its products. A customer can use PayPal to purchase online, send a fax order, or send a purchase order by fax or e-mail.

We have had an unusual amount of purchase orders lately. Everybody is happy when a PO comes in, but our accounting department started complaining that tracking those purchase orders is becoming difficult.

We had a meeting in which we agreed that some sort of purchase tracking system should be created. I persuaded everyone that it would take a tenth of the time to write it in Excel 2007 then in C++ (the language of choice for our programmers). So I have been awarded the pleasure of writing it myself.

In the coming week or so, I will share with you the process of designing this system and implementing it–successfully, I hope.

I will also make the Excel application available to anyone who’s interested.