Excel (Online): How do you create order templates, ordered, to deduct from main inventory?

[V1668]

Hi,
So I am trying to create order templates in one tab 
e.g. product A consists of 1,2 &3, product B consists of 1,4&5 etc
Then if customer A buys product A & customer B buys product A&B, in a separate second tab
How to I insert the different orders so the products would be added together then deducted in third tab for the inventory stock?

I managed to do an in and out stock levels but I cannot manage to do a template ordering of products when ordered by different customers to be added together then deducted from the main inventory stocks. Like by time and products of the products.

Anyone know where I can find a template? 

Hope it makes sense 
Thank you for your time

Here's the link
https://1drv.ms/x/s!AqWT2hIp5gTHgqgIsR6PTUtHFLG_8A

[#2]

@V1668 

managed to do an in and out stock levels

If you want calculate the stock in hand or balance,I prefer input all stock in and out in one table so that you can get balance of each product more easily by sql

e.g.

create temp table aa as 

select amount,debit,customer,memo,checked from stock where debit<>'select one' union all 

select -amount,credit,customer,memo,checked from stock where credit<>'select one' ;

select *,sum(amount) over ( partition by debit order by checked) balance from aa;

amount debit credit customer memo checked

10	product_a	select one	customer_a	buy,increase stock	2024-02-26 08:49:40-65dbe024c9fdd
2	select one	product_a	customer_a	sale,decrease stock	2024-02-26 08:50:15-65dbe04785fb8

Stock

amount

debit

select oneproduct_a product_b product_c 

credit

select oneproduct_a product_b product_c 

customer

memo

Submit提交Reset重置

[#3]

@peiyezhu 

for example:

https://e.anyoupin.cn/EData/1188.html