+ Reply to Thread
Results 1 to 3 of 3

Purchase Order Database

  1. #1
    Registered User
    Join Date
    03-04-2016
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    1

    Purchase Order Database

    I am at an intermediate level when it pertains to MS Excel but I am looking for ideas on an efficient way to store, track/report, and update data in excel. Here is my dilemma...

    I am a purchaser and I issue many purchase orders for a company that does not have any sort of ERP or database system. I only have MS applications to work with. There are two of us on the team and we each have a different way of keeping track of our purchase orders. So I need to create a tool that the both of us can use and manage our purchase orders and run reports and/or track them. What is the best way in Excel to build a database of our purchase orders, be able to update them as needed, run reports (what is open or closed, show data for specific job names, calculate total spend for each job, etc...), and share this information with others?

    My thoughts are to build a pivot table based on information that we enter into a master data sheet. the master data sheet will have the following headers: purchase order number, job name, vendor name, purchase order amount, issue date, and status (open or closed).

    What are your thoughts on this?? I appreciate any and all responses.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Purchase Order Database

    Hi newguy and welcome to the forum,

    All this sounds great and doable. The hard part is the sharing your workbook and have you both enter data at the same time.
    Read about sharing at:
    http://www.gcflearnfree.org/excel2013/2/print

    I've found the problem comes when trying to "standardize" on a system the other person doesn't like. Have I said "I hate politics".

    To do pivot tables and harder stuff you need a copy of Excel installed on your hard drive. I'd suggest at least one person have the full version so that person can do the harder stuff.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-01-2016
    Location
    CPH, Denmark
    MS-Off Ver
    2013
    Posts
    1

    Re: Purchase Order Database

    Hi thenewguy001,

    I can feel your pain to use Excel. I have just released this www.expeni.com very simple PO solution - with quick demo in it. At least do not ignore it by thinking that it is just another crapy solution. You take a look at it. It is simple and new features are in progress.

    Let me know if you need any help on this.
    no problem for the price as well... I just need real users...

    Thanks
    /iffi

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populate my Purchase order from a list of Purchase Order numbers and their details
    By Carolbell44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2015, 07:14 AM
  2. How to connect purchase order and sell order with party ledger and daily day book
    By harisjawed86 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2014, 11:36 AM
  3. Order entry and Purchase Order using VBA
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 12:39 AM
  4. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM
  5. Replies: 10
    Last Post: 09-27-2012, 03:59 PM
  6. purchase order list & order number generator
    By podaf in forum Excel General
    Replies: 2
    Last Post: 06-28-2009, 06:02 PM
  7. purchase order counter in excel purchase order template
    By Brandy@baoco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1