Take it easy on me I am new to NAV. I have some programming knowledge (mostly VB and VB.net). I am starting to get into NAV/SQL. I am working with a Navision system with the SQL backend. As of now we are using macros to enter data through the NAV front end. What is the suggested way to reassure that all data (if its put in via INSERT or UPDATE from an excel or access file) is applied. I am assuming when you use the NAV front end it updates several records at once as opposed to a Query that would just update the table it is told to. Is there any way to figure out what tables need updated or a way to write directly to a NAV form (besides macros) from a Query?
In order to update data directly via ODBC, C/FRONT or sql statements you are supposed to be a NAV expert.
There are so many relationships - especially when you come to orders or similar that I would strictly advice you to not go this way at all.
If there is absolutely no other way to get the data into NAVision, I would strongly advice you to write this data into a kind of buffer table in the 50000 range and use some Navision code to move this data into the tables where it belongs - just to make sure that all triggers are executed properly.
What does that mean? How are you creating these macros? Using anything other than a NAV process to enter data you run the risk of not executing all business logic, and you can have serious issues as a result.
Using programs like MacroMagic and such are the same as entering data. Just do not like doing it this way.
But i guess there is no choice in the matter.