I am using Jet Essentials 2015 15.0.14280.0. We are in the process of upgrading from NAV 2009 to NAV 2013 R2. I have a formula that runs just fine from our NAV 2009 datasource, but when I try to run it from NAV 2013 I get the following error: "Flow fields cannot be applied when using a field cache".
My formula is : =NL("ROWS=5","ITEM","NO.","variant filter","l","search description","???m","shelf no.","inline*","manufacturer code","<>oem","qty. on sales order",">0","NO.","=IF(NF(,""inventory"",""location filter"",""storm"",""variant filter"",""l"")<NF(,""qty. on sales order"",""variant filter"",""l"")+NF(,""Trans. Ord. Shipment (Qty.)""),NF(,""no.""))").
Any thoughts on what is causing this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Here is the reply that I got back from Jet Support:
I ran this by our development team and they were able to identify the issue.
The error is a bit confusing because there is no field cache explicitly defined in the report.
It appears that the issue is that we do not support the use of flow filters on NF functions which are being used as a calc filter with NAV 2013 SQL Server Data Sources.
You would need to restructure the report in order for this to work against a NAV 2013 SQL Server Data Source.
Here is an idea of how you could do this.
1) A "Rows" function that applies all the non-NF filters and returns record keys
2) The NF functions to calculate the condition
3) An NF to retrieve the row from the record key
4) A conditional hide on the rows which do not pass the condition
Please sign in to leave a comment.