Hi All,
i wish to log all actions with ledger journals and vendor payment journals.
So i run into System administration > Database log setup and added some ledger journal fields to logging:
For example, i modified General ledger description. But if on GL journal form Options > Record info > Database log i see nothing:
What's is my mistake? Does anybody succeed in setting up journals log?
*This post is locked for comments
If you are interested in an alternative of the standard database log, you can take look at the solution:
appsource.microsoft.com/.../naviconuk.advanced_database_log
Or youtube channel: www.youtube.com/.../videos
It would much appreciate it if you could provide your feedback.
Hi All!
I have the same problem.
I configured the database log for several tables, but if you change the entries in these tables, the database log is empty
I will be grateful for the advice
I just tried it, and that worked ok. I went for the "Journal lines" entry having a PoolRecId field, as this field is only present on the LedgerJournalTrans table.
In regards to your errors, the "Unable to configure Database logging" part comes from exception handling in the database log wizard.
"The given key was not present in the dictionary" probably comes from some of the .Net code involved in creating the trigger.
I don't have any explanation for these errors.
I wouldn't recommend putting a log on LedgerJournalTrans though.
It is a table meant for data entry, so you'll get a huge amount of log entries, with following performance implications.
Palle, have you succeed in setting log on journal lines? Looks like i tried all tables in General ledger / Ledger journal lines and a) with some tables nothing happens b) some tables after i choose fields give me error "Unable to configure Database logging. The given key was not present in the dictionary."
I was thinking about the logInsert, logUpdate, logDelete and logRenameKey methods in the Application class. You can still see them, but they don't seem to be called anymore.
The EventCUD triggers on SysDataBaseLog are also not called, since the records are now being inserted directly from the database, outside the AOS of Dynamics.
I'm working on a solution where we need to track CUD dynamically on user specified tables. Earlier we have piggybacked on the database log, but now we also create triggers. Since both the database log now and earlier the "Cross-company data sharing" feature does this, I think it is a viable approach to take. You can check the code in the DataSharing model to see how triggers can be created from Dynamics. I haven't checked where the code is for creating the database log triggers, but that is probably more relevant for the stuff you work on.
To build something inside Dynamics with event handlers, Lane Swenka has made this nice solution, or proof of concept if you want: www.axdeveloperconnection.it/.../runtime-eventing-dynamics365-operations
Lanes solution adds an overhead to all transactions, having a negative impact on performance for all tables, and it calls stuff that Microsoft might change without any notice. In relation to my product, I don't have the guts to use that approach.
If your stuff is covered by entities, you might be able to benefit from the change tracking that you can setup on the entity in "Data management".
I don't know of any better ways...
Hi Palle, thanks for sharing this info.
I have a doubt about how to monitor create/update/delete events globally.
I've built a solution which is based on the callbacks that kernel calls when using the Events framework. About kernel triggering you mentioned in your recent blog post, "you can still find the old application code in Update 8, but it is not triggered anymore."
Do you refer to the DatabeseLog events only (logInsert, logUpdate, logDelete, logRename)? Or also EventCUD triggers were included? (eventInsert, eventUpdate, ...)
Is there a better way to monitor these events? (delegates, kernel events, etc)
I hope someone can throw some light on this.
Thanks!
Documentation on the upgrade process is here: docs.microsoft.com/.../upgrade-latest-update
If you just want the triggers to be created, you can probably get that done by just running the wizard again.
It have tried it now for LedgerJournalTable. The tricky part being to figure out which "Ledger journal table" to create the trigger for. There are five "Ledger journal tables" to choose between.
I chose the one having a PaymentsGenerated_IT field, as this field is only present on the actual LegderJournalTable table. It's the fourth "Ledger journal table" on my system:
That creates this trigger in SQL:
And this is the result from a small test:
A side note is that is seems like the trigger is not removed again from the database if you remove a table from the setup. I consider that to be a bug.
The database log implementation is changed in Update 8. Writing to the database log used to be handled from the AOS. In Update 8 this is done from SQL Server triggers on the tables in the database.
So if you have a setup from an older version and haven't run any data upgrade, I would imagine that you are missing the triggers. Could you check those?
#1
André Arnaud de Cal...
293,272
Super User 2025 Season 1
#2
Martin Dráb
231,931
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
