<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

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? 😊

Discuss this post

Recommended posts

Managing and keeping track of external documents like customer contracts does not have to be difficult. With a simple configuration you can archive customer contracts in Infor Document Management (IDM) and automatically associate the document with a customer record. This way you will always be able to easily find the document, without leaving the M3 user interface.
Sometimes you want to know how many records you have of a certain type in a list. If I am looking at purchase order lines I might want to know how many open order lines I have per supplier, or how many delayed order lines we have at the moment. If I am working with manufacturing orders I might want to know how many open orders we have in my facility, or how many orders we have of a certain type. How do we show this in a simple way?
In this blog post I describe how to get your item names in the language connected to the user when using custom lists in Infor M3.
If you are running Infor OS/H5 you have the possibility to create really nice homepages for your users. The homepages are the starting points for all roles, and one of the widgets you probably want to have on your homepage is the menu-widget. On the menu widget you can add links to M3 programs for example, but by using bookmarks you can make the links smart, and let them open the programs with predefined selections and searches.
In this blog post I'm describing how to create bookmarks in M3. Since we are moving towards Infor OS and H5, we need to handle that there are some differences in how you manage bookmarks in the different user interfaces for M3.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down