We are working on a web interface to Navision for our senior project,and planning to do it using ASP.NET and MS-SQL. Therefore we need to know which stored procedures and views do we need to use in order to get or put information. So, do you know such a MSSQL-Guide for Navision?
I could be wrong… But as far as I know, Navision makes the SQL calls within the Client Apps. There is no “Exposed” SP. There are views that you can see, but anything that will take parameters, you are on your own. And forget about flowfields… They are not in the tables, you will need to “SQL profile” them or, again, write your own.
Never use any other application than the Navision client to put data directly into Navision tables, then you are only asking for trouble. Write data into a new table instead, which then can be imported into Navision with for example a NAS client.