Thanks for the pointer. I’ve been checking out the Change Log and can see that it is populated from four tables - 23, 38, 39 and 2000000003, which look to be PO Headers and Lines, creditor’s details and user permissions. Is that correct? How do I identify the actual tables from the table number?
It also has an actual time stamp in the change lof, so I can run some out of hours reports as well.
I’m doing these straight from the Query Browser in SQL, because that’s what I know (i.e. I know SQL, but not NAV). Is there an easier way in the application or should I stick to what I know best?
The files that are logged in the change log are specified in its setup - you can go to the object designer (Tools → Objects designer) to see these. The change log only logged manual changes in data from forms so will not give you every thing you need. You would be best to discuss your requirments with your local partner as it would appear you need customisation to log all your requirements.