Sometimes you need a simple way of following changes of values for certain fields in M3. By using the event log in M3 you have a handy solution 😊 Follow the steps below and you will have a log of changed values for supplier bank accounts in just a few minutes!
To be able to follow changes of bank accounts you need to start by creating a record in CMS045, event subscriptions. The table where you can find bank accounts is called CBANAC, and the operator should be update.
Tick the box “Include in auto job event DB changes (CMS912)” to activate the logging functionality. Once that is done the next step is to add the fields you want to log, in my example BCBAF1, bank account. Option 12 (event log fields) takes you to CMS048 where you add the field.
The configuration is as simple as that! 😊 The last step is to restart the autojob CMS912 to activate your event log. Go to MNS051 and chose to stop and then start the autojob again. Once this is done M3 will start logging all changes of the activated field.
The program CMS300, display event log, will show all logged records. Once you have created a good sorting order and view you will be able to see a list of all changes done.
Since CMS300 is a program that uses the new list standard (you can find it in CMS005), you can configure the list in a very flexible way. In my example above I have added both the supplier master and the user master to the list to be able to show both supplier name and user name in the view.
Nice function, isn´t it? 😊