Inventory Management in Google Sheets | Track and Manage Inventory Effectively 

=sumifs(stock_ordered,stock_order_items,B3,status,"") GIT formula not working

Sir,How to create this sheet

liked your video, you are requested to kindly make a inventory video just like this automated one in which the items are 26 and 3 salesman's are selling in market with shop name. means i need shop data also on monthly basis. invoice entry will be also made manually when stock arrives with date. to be checked on month end. sales data entry is manual and also opening and closing stock should be updated on daily basis. thanks & regards lots of Love and Respect from Pakistan (love because you are my Teacher)

great

How the balance stock, safety stock & goods in transit formula works

But we also need balances of debtors and creditors billwise.

How to add expiry date to this.