Home
Login
Sign Up
Profile Options
Tools
Edit Profile
Manage all aspects of your profile here including demographics, emails, notification settings, etc...
Change Password
Begin the password change process
Email Subscriptions
Manage your opt-in/opt-out email subscriptions
View Profile
View your profile - what other's see
Sign-out
Sign out of this community
1-800-819-1190
Contact support line
Smart Connect
Connect with others and manage various member options
View QR Code
View your profile QR Code - Connect and or share your contact information
Tour Page
Take an interactive tour of this page
Knowledge Base
Visit the knowledge base for more info
Instant Messaging
Full page representing all of your instant messaging conversations
Insights
Member reporting and analysis
Terms of Use
Cookies
Privacy Policy
Contact Us
Help
 
 

Site Menu

Forum | 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
Uncategorized
Group: *MUGA
9
160
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
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...
1
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