filter item entries which have remaining quantity at a historical date


I would like to filter/select all item ledger entries which meet the criteria that the quantity of the entry until a chosen date in the past is higher than zero.

In other words for example I would like to select today all item ledger entries which have a remaining quantity as at 31 May Higher than zero (Meanwhile the remaining stock as at 10 July of this entry maybe zero).

So I can use NL("Sum","item ledger entry","quantity","entry no.","12345","posting date","..31/05/2020") to determine for each entry what is the quantity as at 31 May and then hopefully filter the result - entries that still have quantity on that date.

is that possible?


Please sign in to leave a comment.