+ Reply to Thread
Results 1 to 3 of 3

Master inventory product price changes with new order

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Delaware
    MS-Off Ver
    Excel 2003
    Posts
    2

    Master inventory product price changes with new order

    I am using the sample spreadsheet that user highbarger provided on April 4, 2011. I added unit costs to the spreadsheet along with other columns. The cost for some products changes with the supplier with new purchases. Is there a formula I can use determine which unit cost to use? I know the number of each product in the master inventory prior to the purchase, so when the total count left in inventory gets to that number, I can change the unit cost to the new price.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Master inventory product price changes with new order

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    03-07-2013
    Location
    Delaware
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Master inventory product price changes with new order

    Here is my wookbook. It is for a non-profit organization that I keep track of their inventory. On the Master Inventory sheet, several of the items in the column UNIT COST changed with a new purchase order. Since we still have some of these items in stock, I can't just change the number and if I just change it, it will affect the SALES sheet and the individual monthly sales sheets (SALE 2013-xx). So I need to have a way to determine if the item purchased is from the new purchase order or the previous one. Thanks fo your help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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