+ Reply to Thread
Results 1 to 5 of 5

inventory transactions

  1. #1
    Registered User
    Join Date
    05-28-2020
    Location
    Playa, Mexico
    MS-Off Ver
    office 365
    Posts
    3

    inventory transactions

    i am trying to create an inventory file were i keep track of the inventory through transactions.

    please see the attached file so it makes sense what i am talking about.

    for example,
    in my file i need to select a base, this is the store from were i make the transaction
    i select a type of transaction, (sold- it should deduct the quantity from the inventory, used- it should deduct the quantity from the inventory, ordered-no response needed, received- it should add the quantity to the inventory and transfer- it should deduct from the inventory from the selected store and add to the inventory of the selected destination.

    i dont know if this is even possible but i hope someone can give me some advise with this or if impossible advise me on a different approach.

    regards,
    Attached Files Attached Files
    Last edited by Joerivanw; 05-28-2020 at 05:15 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010
    Posts
    616

    Re: inventory transactions

    Hi,

    A little bit messy and long, perhaps can be simplified.

    In I3 and across:

    Please Login or Register  to view this content.
    Let me know if you have any concerns.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-28-2020
    Location
    Playa, Mexico
    MS-Off Ver
    office 365
    Posts
    3

    Re: inventory transactions

    yeessss,
    Thank you so much!

    It all seemed impossible to me but almost everything functions now, the only option that doesnt seem to work is the "received" function.
    this should add to the inventory but does nothing.
    i added the file again with a small alteration.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-28-2020
    Location
    Playa, Mexico
    MS-Off Ver
    office 365
    Posts
    3

    Re: inventory transactions

    i found the problem, now everything is in order.
    thanks again!

  5. #5
    Valued Forum Contributor
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    Office2010
    Posts
    616

    Re: inventory transactions

    Great! glad to help.

    Yes, the formula started from C1 and not C2, that's the problem with long formulas, they are hard to trace.

    (Transactions!$C$1:$C$25="received")


    I'm uploading the correct file for the closure of this tread.
    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)

Similar Threads

  1. [SOLVED] Formula for Inventory Summary based on Inventory List
    By EWolfe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2018, 10:35 AM
  2. Replies: 0
    Last Post: 09-04-2018, 02:52 AM
  3. Want to set Week End Inventory #s to load in Opening Inventory
    By tkeat1692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2013, 11:24 PM
  4. Replies: 22
    Last Post: 09-20-2013, 02:00 PM
  5. Replies: 2
    Last Post: 09-17-2013, 07:12 PM
  6. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  7. Replies: 0
    Last Post: 10-04-2005, 08:05 PM

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