In NAV, we created a custom flow field that has a date filter on it to isolate a months worth of data that exists on the customer table. The table filters on it are below and is based on the Cust. Ledger Entry table.
Field Type Value OnlyMaxLimit ValueIsFilter
Customer No. FIELD No. No No
Global Dimension 1 Code FIELD Global Dimension 1 Filter No No
Global Dimension 2 Code FIELD Global Dimension 2 Filter No No
Shortcut Dimension 3 Code FIELD Shortcut Dimension 3 Filter No No
Posting Date FILTER 01/01/16..01/31/16 No No
Currency Code FIELD Currency Filter No No
When I try to pull it into a jet report with the field formula: =NL("FlowField","Customer","Nav Jan"), the table has an error. The debugger reads: Invalid filter "010116D..013116D".
Thoughts on how to resolve this?
Date
Votes
1 comment
-
Jet Reports Historic Posts As rough guess, just treat your new field as a normal field. eg =NL(,"Customer","Nav Jan")
PS: Following NAV design patterns, you shouldn't really hard code a date filter into a FlowField. :)
Please sign in to leave a comment.