is it possible
count # of items (entries?) listed in the item table > in history
# items
1-1-2004 150
1-1-2005 200
1-1-2006 210
etc.
I tried unsuccesfully something like
=NL("count";"item";"no.";"Datefilter";"1-1-2000..1-1-2004")
=NL("count";"item";"no.";"Datefilter";"1-1-2000..1-1-2005")
=NL("count";"item";"no.";"Datefilter";"1-1-2000..1-1-2006")
thanks for any sugestions
Date
Votes
6 comments
-
Jet Reports Historic Posts Hi Jan,
I believe the Date Filter field is a flow filter field, which means that it applies to flow fields, but it can't be used for general filtering. Perhaps, what you need to do is use the Item Ledger Entry table and filter on the Posting Date?
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
No this is not an option,
Because if I'm correct this will count only items excisting in the in the item legder entry table and are those items with at least one activity
and I want to count ALL items at a specific date (regardless activity or not.)
thanks anyway -
Jet Reports Historic Posts Hi Jan,
I guess I don't understand what you mean by items "at a particular date". How does an item have a date if that date is not related to some activity? The "Date Filter" field in NAV is a flow filter field which is used to filter flow fields on the Item table and typically those flow fields go to activity tables such as the Item Ledger Entry. Unless the "Datefilter" field you are talking about is some sort of custom field which gives an item a date that is unrelated to activity on that item then I don't really understand what you are trying to get.
Regards,
Hughes -
Jet Reports Historic Posts Hi Jan,
I guess I don't understand what you mean by items "at a particular date". How does an item have a date if that date is not related to some activity? The "Date Filter" field in NAV is a flow filter field which is used to filter flow fields on the Item table and typically those flow fields go to activity tables such as the Item Ledger Entry. Unless the "Datefilter" field you are talking about is some sort of custom field which gives an item a date that is unrelated to activity on that item then I don't really understand what you are trying to get.
Regards,
Hughes
I would like to know how many items are created the item table on 1-1-2004, 1-1-2005, 1-1-2006 etc. etc. -
Jet Reports Historic Posts Hi Jan,
So I guess the real question is, is the problem your filter or the fact that you don't know which field on which table will give you an item's creation date? I don't know which field on which table gives you an item's creation date (assuming there is such a field at all). That would really be a question for your Navision dealer. As far as your filter itself, assuming you know which field contains your items' creation dates, you should be able to do a count and just filter by a particular date. You might need to do a CountUnique if the table contained more than one entry per item and count the unique item numbers.
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
thanks
will closes this topic for now and have a look around
Please sign in to leave a comment.