4 Replies Latest reply on Jun 12, 2015 8:09 AM by leeputnam

    Inventory Reference Portal

    leeputnam

      I run a small company and we provide rentals to customers. We have a rental page that allows us to select from a list which products the customer is renting. Each product has a unique serial number, and we track its condition (working, cosmetic damage, broken). We would like to be able to see how many times each serialized product was rented at the end of each year, that is why we have a "many to many" relationship.

       

      If we have more then one of the same item on a rental, we have to create a new line item for each occurrence.

      EVENT TABLE
      DateProductQTY
      6/10/2015Blue Chair1
      6/10/2015Blue Chair1
      6/10/2015Blue Chair1

      This is cumbersome and takes up a lot of space on our preparation check lists.

       

      What I want to do is be able to add a QTY column, that will turn red, or limit the user from adding more product them we have in available inventory. It would also be great if it could remove the selected product from the inventory list for the date assigned. That way if we have two rentals on the same day we don't over book.

      EVENT TABLEINVENTORY
      DateProductQTYProductSerialAvailable
      6/10/2015Blue Chair2Blue Chair12NO
      6/10/2015Red Chair2Blue Chair13NO
      Blue Chair14YES
      Blue Chair15YES
      Blue Chair16YES
      Red Chair17NO
      Red Chair18NO
      Red Chair19YES

      Any thoughts or ideas would be greatly appreciated!

       

      Notes: I have a "Many to Many" relationship utilizing a line items merging table.