If then loop

[#1]

I have the following table:

Date	Entry type	Item	Qty	GRN no.	Vendor
1-Jan-16	GRN	RBC12300	10	GRN-101	ABC
3-Jan-16	Sale	RBC12300	-20	SRN-678	DEF
4-Jan-16	GRN	RBC12300	30	GRN-102	CDE
5-Jan-16	Output	RBC12300	25	ORN-345	RC!
6-Jan-16	GRN	RBC12300	15	GRN-103	ABC
1-Feb-16	GRN	RAC56789	10	GRN-101	ABC
3-Feb-16	Sale	RAC56789	-20	SRN-678	DEF
4-Feb-16	GRN	RAC56789	30	GRN-102	CDE
5-Feb-16	Output	RAC56789	35	ORN-345	RC!
6-Feb-16	GRN	RAC56789	15	GRN-103	ABC

Table 2:  

Closing stock of RBC 12300			60
Closing stock of RBC 12300			70

i need the following output :

The system should compare recent Receipts (GRN and Output)

with the closing stock. to the extent Receipts matches with the closing stock, it should consider.  

6-Jan-16	GRN	RBC12300	GRN-103	15
5-Jan-16	Output	RBC12300	ORN-345	25
4-Jan-16	GRN	RBC12300	GRN-102	20
6-Feb-16	GRN	RAC56789	GRN-103	15
5-Feb-16	Output	RAC56789	ORN-345	25
4-Feb-16	GRN	RAC56789	GRN-102	30

for eg. in the output for item RBC 12300, GRN Qty is 30, but only 20 is considered as the sum total is equal to 60.

kindly provide code for this in qlikview/

[swuehl]

I don't really understand your requested output description:

- Are you only considering records looking back to the last sale as 'recent'? Or why have you left out 1-Jan and 1-Feb receipts?

-"for eg. in the output for item RBC 12300, GRN Qty is 30, but only 20 is considered as the sum total is equal to 60."

I am totally lost, can't get how you calculate 30, then consider only 20????