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?