i need to find out which user created a specific FA and on which date it was created. how do i do that?
thanks!
i need to find out which user created a specific FA and on which date it was created. how do i do that?
thanks!
Fixed Asset doesn’t have a field to relate to user user that created a record. If you have change log granule you can monitor records changes (deleted / Insertions) for specific tables and get user that made those modifications.
i’m not sure what “change log granule” is…is that a module of navision that allows you to look at the SQL change entries?
if i don’t have that, where could I go in the SQL database to look for that?
thanks!
Check in your Navision license if you have this line:
3,080 General Ledger - Change Log
To monitor changes in SQL you add to manually create triggers but isn’t practical.