Inventory movment table

YarinInbar — Thu, 08 Sep 2022 09:50:38 GMT

Hello, I want to develop a sheet that reccomends to move a item from one store to another, based on less days that the item is excpected to be on stock.

I have a table that shows thoese values:

Store name,
Item code,
Sales amount,
Inventory amount,
Inventory entry date,
sales amount / inventory amount * today()-[inventory entry date] AS [stock expected days]

store	item code	sales amount	inventory amount	inventory entry date	stock expected days
STORE A	8574	15	1	01/09/2022	0.47
STORE B	8574	17	3	25/07/2022	7.94
STORE C	5874	21	1	15/06/2022	4.05

I want to be able to get a table like this:

SELECTION: CURRENT STORE - STORE B

item code	current store	current stock days	target store	stock expected days
8574	STORE B	7.94	STROE A	0.47

Can you advice? 😅

topic Inventory movment table in App Development

Inventory movment table