Full Change Log

nav_nav

Hi,

Is there any way (customisation probably) to have the system logg ALL changes ?
A datawarehouse application is looking for an incremental upload. The timestamp on SQL is not a valid option since they want to be able to select all changed lines since the last upload.
Standard change log only logs user changes. Is there any way to assure you log ALL changes (system changes included) ?

Thanks

garak

If you need the informations about modifications create through reports or Codeunits, you must develop it self. Take a look into cu 1 an changelog. You must call the functions from your codeunits or reports.

An other way is, if you use sql Server, to create an function on sql server which shows you all changes to an date / time.

Regards

nav_nav

- I know you could create some functions in codeunit 1, but that only triggers user changes. If you would use the developers toolkit to check where the modify is called without true...
- a function on sql server is interesting. Can you do that without loosing your code each time you compile your object or install a new fob ?

garak

To the second. Yes you can do this.

I'fe create that in sql. But i doesn't need all navision tables. So i've specific which tables the function should search trough. And the search job is at night (after Maintenance jobs).

For Reporting you can use navision or sql features (like Report Services in 2005)

Regards

nav_nav

Could you please post exactly what you did ? According to MBS this is not possible.