Stock and Sales Subtraction

ahmd — Wed, 05 May 2021 11:27:44 GMT

Hi,

I want to subtract sales from stock in script.

scenario: I have ST of product A and Product B and SL takes place on different dates. When the SL sold out from product A then product B needs to be substract.

Such as on 22.01.2021, ST Product A was 18 and items sold out until 29.01.2021 but on this dates total remaining ST Product A was 3 and Sold items were 4 so 3 - 4 = -1. So 3 items should be subtract from Product A and 1 items should be subtract from Product B. and also mark it in last 2 columns that the sold items take place from Product A or Product B.

Main Product	Sub Product	Date	ST Product A	ST Product B	SL	SL from Product A	SL from Product B
A	AA	10.02.2021			20	15	5
A	AA	09.02.2021	15	5	1		1
A	AA	06.02.2021			1		1
A	AA	05.02.2021			1		1
A	AA	04.02.2021			1		1
A	AA	03.02.2021			1		1
A	AA	02.02.2021			1		1
A	AA	01.02.2021			1		1
A	AA	31.01.2021			1		1
A	AA	30.01.2021			1		1
A	AA	29.01.2021		5	4	3	1
A	AA	28.01.2021			4	4
A	AA	27.01.2021		2	2	2
A	AA	26.01.2021			2	2
A	AA	25.01.2021		3	1	1
A	AA	24.01.2021			3	3
A	AA	23.01.2021			2	2
A	AA	22.01.2021	18		1	1

topic Stock and Sales Subtraction in QlikView

Stock and Sales Subtraction