Change Log Setup
kenl
Member Posts: 182
Hello,
I am using NA4.0 with SQL option. I have a problem to setup Change Log.
The procedure I have done:
1) Go to Change Log setup-> Setup-> Tables
2) Select table Id 7012 (Purchase Price), All Fields for Insert, some fields for Modify, some fields for Delete.
3) Go back to Change Log setup, activate it.
4) Go to Item card, -> Purchase->Price, create some new price, modify, and delete some old price.
5) Go to Change log, there is no log for purchase price. (I can only see the log for my change in the change log setup.)
(I try to set all field for insert, modify, delete, but still no log)
Do you know why?
I am using NA4.0 with SQL option. I have a problem to setup Change Log.
The procedure I have done:
1) Go to Change Log setup-> Setup-> Tables
2) Select table Id 7012 (Purchase Price), All Fields for Insert, some fields for Modify, some fields for Delete.
3) Go back to Change Log setup, activate it.
4) Go to Item card, -> Purchase->Price, create some new price, modify, and delete some old price.
5) Go to Change log, there is no log for purchase price. (I can only see the log for my change in the change log setup.)
(I try to set all field for insert, modify, delete, but still no log)
Do you know why?
0
Comments
-
Have you reopened the company after activating the change log?
From the online help:Setting Up Change Log
A common problem in an administrative computer system is to locate the origin of errors and alterations in data. It could be anything from a wrong customer phone number to a wrong posting to the general ledger. The change log functionality gives you the ability to track all direct modifications a user makes to data in the database.
You must specify for each table and field what you want the system to log, and then you need to activate the change log.
To Set Up Change Log:- Open the [url=navision://client/run?target=Form%20593]Change Log Setup (Table) List[/url] window.
- Fill in the fields for each line. For Help about a specific field, click the field and press F1.
- Close the window.
- To activate the change log, in the [url=navision://client/run?target=Form%20592]Change Log Setup[/url] window, click to insert a check mark in the Change Log Activated field. Close the window.
You must close the company and open it again for the new change log settings to take effect. - To close the company, click File, Company, Close.
- To open the company, click File, Company, Open. In the Open Company window, select the company and click OK.
The program always logs changes to the Change Log Activated field, which means that you are always able to see which user deactivated or reactivated the change log. This cannot be turned off.0 -
Thanks. Now the log is working.
0 -
Where does it log to? Is there a file or somewhere in the database that all this activity is written to, where can you see it?
Regards,
David.0 -
Nevermind, found it!0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions