Purchase-order tracking application with Excel 2007: kickoff

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.

Posted on October 17, 2006 by Yoav Ezer 
Filed Under Cogniview, Excel, Methodology

Comments

9 Responses to “Purchase-order tracking application with Excel 2007: kickoff”

  1. Simon Ward on April 5th, 2007 12:53 am

    Wow! Thjis sounds like something we’re trying to do too. Can you give me an update?

  2. Tarek on March 14th, 2008 8:43 pm

    i would love to have a copy of this sheet
    really need one!

  3. SZE TOH WU PIN on April 11th, 2008 5:27 pm

    I would like to have a copy of this sheet,please.Thanks.

  4. Riverstown on May 2nd, 2008 4:37 pm

    Excellent idea! If you could send me a copy of the sheet, I will be happy to evaluate it and give you feedback.

    Thanks!

    R.

  5. Frank Rocco on May 14th, 2008 8:07 pm

    I would like to have a copy of this sheet,please.

    Thanks.

  6. Ali Carmel on May 28th, 2008 5:15 am

    Would please like to be able to have a copy too

  7. Kerstin on June 4th, 2008 12:28 pm

    I would really appreciate a copy too!
    Thanks a lot!

  8. Yoav on June 4th, 2008 12:32 pm

    Hi Guys,

    Sorry to disappoint, but the project was never finished :(

  9. Jed Eilers on June 10th, 2010 7:03 pm

    I would like more information and a copy

    Thanks

Leave a Reply