Hello everybody,
you can use the NL Function Filter on the table Item Ledger Entry to get items which where handled in a specific period. This can be done with the following formula:
=NL("Filter";"Item Ledger Entry";"Item No.";"Posting Date";"010112..311212")
The formula returns a filter of all items (by the field "Item No.") handled in the specific period and can be wrapped by =NL("Rows";"Item";;"No.";"filter Expression from above") to get the desired Item List.
Is there a possibility to transfer that formula for Item Variants? For all of you who are not familiar with Dynamics NAV: The item variant table consists of records with a two field primary key ("Item No.", "Variant Code").
If you need further information to understand my problem, please ask for.
Best regards
Olli
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Olli,
You could do this using the Link= functionality. Basically, you could rewrite your Items example to look like this:=NL("Rows";"Item";;"Link=";"Item Ledger Entry";"Item No.";"=No.";"Posting Date";"010112..311212")
In this case there is only one set of linking fields, as expressed by the "Item No.";"=No." filter. However, if the 2 tables needed to be linked by multiple fields, you could easily do this by just adding another filter like this. Does that help?
Regards,
Hughes
P.S. Link= is also generally a faster way to accomplish this task than NL(Filter) so you may consider using it for your single field linking scenarios as well.
Please sign in to leave a comment.