Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Limitations of the Dynamics NAV 2013 and later (Web Services) Data Source


In the 'Dynamics NAV 2013 and later (Web Services)' Data Source, NL(Picture) does not work when Calc Filters, Link Filters, or manual sorts are present in the NL(Picture) formula.


DateFormula Field Values/Filters

DateFormula field values use unit abbreviations such as D for Day, WD for Week Day, or M for Month.  So a value like "5D" means 5 days.  DateFormula values are stored in a non language-specific manner, and then translated when the value is retrieved.  Currently in 'Dynamics NAV 2013 and later (Web Services)' data source, the Jet Excel Add-In only retrieves and filters by DateFormula values using the English unit abbreviations.
Was this article helpful?
0 out of 0 found this helpful