Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Easy Visibility to Audit Fields from within the Application

I know these can be exposed in a GI but it would be nice to have something similar to Ctrl-Alt-Click Element inspection (Maybe Ctrl-Atl-RtClick) that exposes these elements for whatever table contains the record for the field selected...

Audit Fields

The following attributes are placed on data access class (DAC) fields used for data audit:

  • PXDBLastChangeDateTime: Maps a DAC field to the database column and automatically sets the field value to the data record’s last modification date and time.

  • PXDBCreatedByID: Maps a DAC field to a database column and automatically sets the field value to the ID of the user who created the data record.

  • PXDBCreatedByScreenID: Maps a DAC field to a database column and automatically sets the field value to the string ID of the application screen that created the data record.

  • PXDBCreatedDateTime: Maps a DAC field to a database column and automatically sets the field value to the data record’s creation date and time.

  • PXDBCreatedDateTimeUtc: Maps a DAC field to a database column and automatically sets the field value to the data record’s creation UTC date and time.

  • PXDBLastModifiedByID: Maps a DAC field to a database column and automatically sets the field value to the ID of the user who last modified the data record.

  • PXDBLastModifiedByScreenID: Maps a DAC field to a database column and automatically sets the field value to the string ID of the application screen on which the data record was last modified.

  • PXDBLastModifiedDateTime: Maps a DAC field to a database column and automatically sets the field value to the data record’s last modification date and time.

  • PXDBLastModifiedDateTimeUtc: Maps a DAC field to a database column and automatically sets the field value to the data record’s last modification date and time in UTC.

The framework binds the DAC fields to database columns and automatically assigns field values.

  • Brett Nothan
  • May 22 2020
  • Attach files