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,
Bookmarks