navision

How to change user department in Navision 2009 (role tailored)

How can i change users deparments in Microsoft Dynamics NAV RoleTailored Client, say i want to put myself in the [Purchase] department. Please help. ...

Dynamics Nav (Navision) webservice ReadMultiple date filter

Using the Navision webservices, how can you filter by a date. i.e. Within a SalesHeader table there is an "ExportedDate". I would like to find all SalesHeaders where the ExportedDate has not been set or were exported on a particular date. It seems that whenever we set a filter on a date field, then the webservice will either return all...

PHP with ODBC to remote db, where does driver need to be and can I drop SSL on the connection?

I need to connect from a web LAMP (PHP) environment to a remote Navision installation which has ODBC drivers on the server. Does the web server need the ODBC drivers on it locally as well? Or does PHP connect to the Navision server environment with it's own local drivers? Also, can I drop SSL on this connection for security - if so whi...

Screen blinks with data loss

We have Navision 5.0 clients with a 4.3 backend running on a SQL Server 2005 blade server. At random times the users complain that the screen blinks and that they may lose data. I actually witnessed it at a user's machine this morning, and later she noticed that some of her address lines were missing from the Purchase Order Header. I th...

Ready-made Dynamics NAV 2009 web services for integration with e-commerce system?

I'm planning to integrate our e-commerce module with Navision. I know you can set up and configure web services in NAV 2009, but I'm not familiar with Navision, and would like a more out-of-the-box solution, that we can quickly set-up for other customers. Does anyone here have experience with any ready-made web service solutions for NA...

Creating Orders in Microsoft Dynamics NAV via web services or an API

Hi, I am tasked with creating an API that would allow 3rd party customers the ability to send orders into our Microsoft Dynamics NAV 5.0 SP1. I want to be able to create a SalesOrder in Dynamics NAV not with the client but via an API so i can allow a seperate process to enter in orders automatically. Any help is appreciated in leading...

jitterbit sql server problem

To whom it may respond to, I got this message while trying to design a synch job for 2 different tables from 2 different databases : "Last reported error: SqlState = 42S22 NativeError = 207" [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Credit Limit'." Have modified the config file to use quotes instead of bracke...