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

25 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

  10. jocelyn on September 15th, 2010 11:46 pm

    I would like to have a copy please.
    Thanks,

  11. vimal on September 28th, 2010 5:00 pm

    I would like to see all details of purchase orders of traker send me a copy please.
    thanking you.

  12. Frank on October 8th, 2010 3:57 pm

    Would like to try the PO, does it have an option to track a PO for 100, 90 approved, 7 rejected, 3 returned for rework?

  13. Tushar on November 3rd, 2010 8:36 am

    please send me the ecel sheet.

  14. Tushar on November 3rd, 2010 8:36 am

    please send me a copy of the excel sheet.

  15. Shanda on November 5th, 2010 1:12 am

    You’re a God-send. I’m hoping I can get a copy of that program/spreadsheet. Me and my fiance started a business that exploded and keeping track is impossible. Thanks so much in advance.

  16. Brian on November 7th, 2010 12:48 am

    if it is possible to get a copy as well, that would be great. Thanks.

  17. Brian on November 7th, 2010 12:51 am

    I am interested in getting a copy also please. Thanks.

  18. inelda on November 11th, 2010 7:14 am

    Can I get a copy?

    Thanks

  19. Lamar on January 16th, 2011 3:19 am

    Could someone please forward me a copy as well!

    Thanks in advance.

  20. Christine on February 17th, 2011 9:53 pm

    Please forward me a copy of this to both my e-mail accounts
    christine@acculiftflooring and to
    caturner60@hotmail.com
    Been looking for something like this all day.

  21. Tawny Alterman on October 8th, 2011 8:34 pm

    http://www.thefutureiselectric.com/2011/02/lovin-the-cadillac-cts-coupe/|5

  22. Sandra Larmore on October 29th, 2011 8:38 pm

    Just want to say your article is as surprising. The clarity in your post is just excellent and i could assume you are an expert on this subject. Fine with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please continue the gratifying work.

  23. Antione Harig on November 3rd, 2011 12:54 am

    Exceptionally enlightening appreciate it, I do think your current audience will likely want significantly more reviews of this nature maintain the great hard work.

  24. lingerie on November 30th, 2011 8:15 pm

    Recently I have been looking for info about this topic for a while and yours is the best I have found so far. Thanks.

  25. raleigh contractors on December 9th, 2011 7:50 am

    Hiya! Quick question that’s totally off topic. Do you know how to make your site mobile friendly? My web site looks weird when viewing from my apple iphone. I’m trying to find a theme or plugin that might be able to correct this problem. If you have any recommendations, please share. Thank you!

Leave a Reply