Home
Login
Sign Up
Home
Login
Sign Up
 
 

Site Menu

Message
Is there a way in Infor M3 to see who made the last change and what field they changes?
Jeff Eilers *MUGA
BC:

Question:

Article:

Is there a way in Infor M3 to see who made the last change and what field they changes?

We are trying to look into who made changes within a certain M3 screen. Even if someone goes into change mode and doesn't change anything their username is tied to the bottom of the screen. Would like to be able to see what field is changed and possibly what the old value was.
Delivered Read
Group: *MUGA
1
9
353
Latest msg: Yes in Cloud, Field Audit Trail is the way to go - if setup you can press F9 on a relevant record and it will show you exactly what changed and when. from Scott Neustadt, on 12/10/2025
Comments (9) (Descending Chronological Order)
There are no comments at this time, be the first to comment
Scott Neustadt
BC:
Yes in Cloud, Field Audit Trail is the way to go - if setup you can press F9 on a relevant record and it will show you exactly what changed and when.
Marie-Pascale AUTHIE
BC:
Hi Mimi,
Yes, this came in one of the releases. So, if you had FAT activated in transactional tables before you kept it.
If you started after that release, then you could not add. I can't remember when, but I would say maybe 2 years.
I have not checked if you had FAT activated on CO Header and wanted to add a new field if it would prevent.
MPA
1
Mimi Ismail
BC:
Is FAT on transactional tables in the Cloud something new? We have FAT turned on for OIS100 and OIS101 - those are transactional tables.
Marie-Pascale AUTHIE
BC:
Hi Jeff,
In Cloud:
- enable field audit trail only on master tables
- for transactions tables, Infor removed FAT but you can:
- SQL query the transaction table with "IncludeAllVariations" function
- or you can indeed set up CMS045 and CMS048 to trace all changes on a particular field, with visibility in CMS300

Example of SQL
--*includeAllVariations=MHDISH
Select * from MHDISH
WHERE CONO = 100
AND DLIX = Read more...xxx

Hope this helps,
MPA
 Show less...
2
Jessica Vincent
BC:
Jeff unless something changed you can't use FAT on transactional tables in the Cloud. My challenge was our users had FAT and missed it. They wanted to self-serve on what changed. We have a custom CMS100 list that shows the changes as a shortcut in OIS101. If you are interested in how we did it our dev manager could give some details. FAT does still work on non-transactional tables and is a good option if you want to track changes on something like customer or supplier.
Benjamin Gass
BC:
The field audit trail is your friend there. F9 can be pressed on most any panel to access it. Unfortunately you have to configure what fields you want from what tables before it starts recording anything.

Business Engine Field Audit Trail should be available in administration tools unless you need some additional IFS permissions.

 Read more... https://docs.infor.com/m3udi/16.x/en-us/m3beud/default.html?helpcontent=appfoundhs/ses121.html&hl=field%2Caudit%2Ctrail Show less...
Infor Documentation Library
docs.infor.com
Ryan Smith
BC:
Hi Jeff, if you are on multi tenant cloud, we sometimes utilize the Compass tool and select the table with all variations to see who and what changed.
Jon Litofsky
BC:
I can think of two paths. One would be to use BE Field Audit Trail, but that requires that it be setup in advance. The other option, which I use regularly, is to use SQL to export record versions from the data lake using Data Fabric/Compass. I export the table fields I am interested in, sort by date or change number, and then can see when the field value changed and the ID that changed it.
Mimi Ismail
BC:
For OIS100 and OIS101 we set up an audit trail of the fields we want to audit under Administration Tools - > Business Engine Field Audit Trail. It gives us the value of the field before it was changed, after it was changed, who changed it, and the time.

Online