Skip to Content
0
Former Member
Apr 19, 2010 at 02:58 PM

Date of last movement in Query

105 Views

Dear all,

I have a query in which I would like to display the last movement of goods. The Key figures are

1. Quantity receipt stock

2. Quantity issued stock

I would like to get the last date of either last receipt stock amount or the last issued stock amount.

I tried to do so by implementing two conditions

Key figure = Quantity receipt stock - TOP N - Value = 1 -- Characteristic Assignment = Individual Chars and chars combination

Unfortunately this is not working. It delivers the biggest movement but not the last.

Could you please help me.

Thanks

Stefan