The AUDTUSER contains the username of the user who last edited/posted a transaction. But this gets overwritten by ADMIN or whoever does the Day End Processing. If necessary, create another field to hold the username of the user who does the Day End Processing. Preserving the original AUDTUSER is valuable to track which user entered a particular record.

by: Ubaidullah N. | over a year ago | Operations Management

Comments

• Most records (but not all) already have an 'ENTERED BY' field. More generally an activity log is needed and has been expressed in other ideas on this site.

  by: Steve B. | over a year ago

• Absolutely!

  by: Srikanth M. | over a year ago

• OEORDH2 has the enteredby field, but agree on activity log.
  
  Currently we use triggers, but only on specific fields, eg when and expected shipdate is changed we capture the user, old value, new value and date of change. and when a price on an order is changed same deal

  by: John W. | over a year ago

• Activity log is definitely needed.

  by: Kristy L. | over a year ago