Change Log Management not working

nverma
Member Posts: 396
Hello Everyone,
One of our clients wants to track all tables associated with G/L Transactions.
I have set 'All Fields' for Insert, Modify, Delete for the tables specified above. I have enabled Change Log Activated. I restarted NAV/Company. I tried Creating a SI, and Posted it, but the system did not create entries for G/L Entry and Sales Invoice Line in the Change Log Entries table.
Any idea whats going on?
Note - NAV 5.0 SP1, but these objects are being run in NAV 2009 R2.
One of our clients wants to track all tables associated with G/L Transactions.
17 G/L Entry
21 Cust. Ledger Entry
113 Sales Invoice Line
123 Purch. Inv. Line
125 Purch. Cr. Memo Line
179 Reversal Entry
203 Res. Ledger Entry
271 Bank Account Ledger Entry
272 Check Ledger Entry
I have set 'All Fields' for Insert, Modify, Delete for the tables specified above. I have enabled Change Log Activated. I restarted NAV/Company. I tried Creating a SI, and Posted it, but the system did not create entries for G/L Entry and Sales Invoice Line in the Change Log Entries table.
Any idea whats going on?
Note - NAV 5.0 SP1, but these objects are being run in NAV 2009 R2.
0
Answers
-
While searching online, I found a post that stated that Change Log only logs manual changes (viewtopic.php?f=5&t=25838&start=0). That is why the G/L Entry table does not create an entry in the Change Log Entries since it gets created via code (same applies to Sales Invoice Line).
I hope this explanation helps someone in the future who is dealing with the same/similar problem.
When I went to the table and manually modified Sales invoice Line description field, then the system created an entry in the Change Log.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions