How to update available qty on an inventory tracker?

egrillasca

Hi!

I'm creating an inventory tracker and I want the "ITEMS AVAILABLE" column to keep updating as we reorder and sell items. I'm also creating two apps in AppSheet, one to make orders to suppliers and another to sell items, so both "ITEM REORDER QTY" and "SOLD ITEMS" column's values will come from other sheets which contains a log of all orders and sells made. How can I make the "ITEMS AVAILABLE" column show ("STOCK @ START" + "ITEM REORDER QTY" - "SOLD ITEMS") without forgetting/deleting the previous amount?

THANKS

Paul Newcome

You would do something along the lines of...

[Stock @ Start]@row + SUMIFS({Reorder Sheet QTY Column}, {Reorder Sheet SKU Column}, @cell = [Item SKU]@row) - SUMIFS({Sold Sheet QTY Column}, {Sold Sheet SKU Column}, @cell = [Item SKU]@row)

Paul Newcome

You would do something along the lines of...

[Stock @ Start]@row + SUMIFS({Reorder Sheet QTY Column}, {Reorder Sheet SKU Column}, @cell = [Item SKU]@row) - SUMIFS({Sold Sheet QTY Column}, {Sold Sheet SKU Column}, @cell = [Item SKU]@row)

egrillasca

Thank you!!

Paul Newcome

Happy to help. 👍️