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.