searching inventory for non movers

omyahamburg — Wed, 09 Jan 2013 07:25:34 GMT

Dear all

I have an inventory table with purchase and sales positions.

ID	Type	Date	Quantity
A	Purchase	31.01.2012	100,00
A	Sales	25.08.2012	-50,00
B	Purchase	28.02.2012	222,00
B	Sales	01.05.2012	-22,00
C	Purchase	31.01.2012	50,00
C	Purchase	01.08.2012	75,00
C	Sales	01.03.2012	-25,00
C	Sales	01.10.2012	-10,00
D	Purchase	31.12.2012	60,00

ID	Type	Date	Quantity
B	Purchase	28.02.2012	222,00
D	Purchase	31.12.2012	60,00

Can somebody help me out here ?

I do attach my sample qvw.

Thanks a lot.

Cheers

Joerg

Basing on Date 31.12.2012, I need to see all ID which had no Sales since 01.07.2012

The result should look like this

Re: searching inventory for non movers

Gysbert_Wassenaar — Wed, 09 Jan 2013 14:49:03 GMT

See attached qvw

omyahamburg — Wed, 09 Jan 2013 15:00:56 GMT

Great Gysbert !

That's what I was looking for.

Thx a lot.

Joerg