Error: Invoking the web service failed
Overview
When accessing Dynamics NAV through NAV Web Services, it is possible for the the error Invoking the web service failed to occur.
Example text of error message:
Invoking the web service failed with the following message:
The filter "01/01/2021..12/28/2021" is not valid for the the Date field in the Accounting table. The value "02/28/2021" cannot be evaluated into type Date .
Cause
This error can occur when an application attempts to access Web Services and the Services Language setting is configured for a language other than the recommended default of en-US :
Resolution
-
Recommended Solution
insightsoftware strongly recommends setting the Services Language to en-US , as this is the default fixed culture for the Microsoft SOAP Web Services.
Setting this to en-US will still allow users to set their NAV RTC display language to another desired language and will not affect the overall functionality of the client's NAV instance.
Most applications, such as Jet Reports, are coded to work with Web Services in its default fixed culture (which is "en-US") so that all queries passed will work correctly and communications can be a constant.
Microsoft also notes that the default fixed culture for SOAP Web Services should be en-US to ensure that all third party applications work properly.
-
Alternate Option
Another option, if you are still wary of performing this, would be to create a separate NAV instance specifically for Jet reporting with "en-US" as the "Services Language".
A separate NAV instance for Jet reporting is the recommended practice for performance as noted in the following knowledgebase article: Jet reporting performance with NAV
With the "Services Language" set to en-US the client computer will still be able to set their local region and language settings to another desired language and use the syntax "01/01/21..31/12/21" in Excel.