Hi,
I would like to to show only articles which have a stock quantity <>0 on one or another date. How could I filter these articles?
Greetings,
Hi,
I would like to to show only articles which have a stock quantity <>0 on one or another date. How could I filter these articles?
Greetings,
Put your 2 dates in the options area and combine them with an Excel formula =$D$4 & "|" & $D$5. It will look funky because of the lack of formatting but it will work. Ensure Posting Date and Stock Quantity exactly match the field names that you are using to filter. Then in your NL Rows function, include the Filters= and that should work. Good luck!
Column C Column D Column E Column F
Row 4 Date 1 07/22/2013
Row 5 Date 2 08/02/2013
Row 6 Posting Date 41477|41488
Row 7 Stock Quantity <> 0
Row 8
Row 9 =@NL("Rows","Your Table",,"Filters=",$C$6:$D$7)
Note that the Filters are only Rows 6 & 7. Do not include Rows 4 & 5 because they are combined together in Row 6.
Hello,
thank you for your solution. I think it do not fit really.
I would like to show all artikels, which have a quantity on one specifc date. So I need to make a sum of the item ledger entries and will only show items which have a quantity. My idea was to make the following filter:
||"Filter","Item","1 No.","NL(""Sum"";""32 Item Ledger Entry"";""12 Quantity"";""3 Postingdate"";""..28.12.2020"";""Itemno_."";NF(;""1 No.""))",">0" |
But this do not work...