Although its usefulness is limited, you could look at the menu history
for that id and date in question, see what programs the user was in and
then query the files that can be changed by those programs for the
specific user id & date (User & UPMJ fields). It won't tell you
specifically what data was changed, but it will tell you the user
changed something on the record. If you don't find any records with the
name and date, don't feel too confident. Another user might have
updated the record since then. Not all programs, especially custom
programs, are written to update the user and/or date updated fields.
A journal on the file is the only way to be 100% certain that a change
to data was made by a person. Depending on which view(s) the journal
takes will determine if you will be able to tell exactly what data was
changed (or deleted). Even if you have before and after images on your
journal, journal receivers only hold so much data. Depending on how
your shop is setup regarding number of active receivers, how much data a
receiver holds before it rolls over and how long receivers are kept on
your system, you may not be able to get the data you are looking for
even though your files are journaled. Few shops journal all files.
JW
J Walker
JDE A7.3 cum(mongrel)