1 Reply Latest reply on Mar 10, 2016 6:41 PM by DanielShanahan

    Inventory

    Rosalie

      Hello Everyone,

       

      Im using the Inventory Starter Solution for my inventory needs. but I am having a trouble in changing the "Units in Hand" Field. I want that if I enter a value to the "Units In" in the Stock Transaction Portal it will not add in the calculation on my "Units on Hand" ; and I want also that If I enter a value to the "Units Out" field in the Stock Transaction Portal it will automatically enter the remaining total quantity in my "Units In" and it will also update my "Quantity on Hand" field. is this possible to achieved?

       

      In the attached file If I received 15 Stocks and 3 is out i want that in the  "Units on Hand" will show 9 not 21.

       

      I have attached the Inventory file that Im working for your reference.

       

      Thank you so much to any help.

       

      Rose

        • 1. Re: Inventory
          DanielShanahan

          Hi Rose,

           

          I want that if I enter a value to the "Units In" in the Stock Transaction Portal it will not add in the calculation on my "Units on Hand"

          Why not?  If you receive 10 units from your supplier, would you not want your Units on Hand to go from 21 to 31?

           

          and I want also that If I enter a value to the "Units Out" field in the Stock Transaction Portal it will automatically enter the remaining total quantity in my "Units In" and it will also update my "Quantity on Hand" field.

           

          The remaining total should be in the Units on Hand field of the Inventory table.  And each transaction row should be EITHER an In OR an Out, not both.

           

          A better way to set this up would be to prevent the user from creating a transaction that is both in or out.

           

          See if the attached helps.