The Changes Detail Panel is used to display a single data change or “Changes” record. Data Change records are created by the system when existing database records are edited. Data Change records are automatically created by the system when static data items such as customers, vendors or inventory items are edited after creation, and data change records are also created when certain types of transactional data (such as sales or purchase orders) are modified by an operator.
Each Data Change record identifies the specific record and the specific field in the record that was modified. A single edit to a database record can create one or more data change records (depending on the number of fields that were modified during editing). Mutliple Data Change records can be created for a specific field in a specific record (to handle multiple edits to the same data record and the same field in the same data record).
Data Change records allow you to determine the date and time that a database record was changed, the operator who made the change, and the previous and new contents of the specific field in the record that was modified.
The Changes Detail Panel is divided into 3 different sections.
The top section of the Changes Detail Panel displays information about the selected database record. This information includes the file number in which the record exists and the unique identifier that is used to associate the changes record to the data. The ident or identifier that is used by the system varies based on the file that the changes record is being written for (for example, the changes records for a company or customer record, are tied to the customer based on the account number field in the customer record). The changes record for transactional data such as a sales order or sales order line is tied to the record using the sales order number and sales order line (if applicable). The other information that is displayed in the top section of the Changes Detail Panel includes the recnum or record number of the selected record, the date and time that the change was recorded, and the operator initials of the operator who made the change.
The second or the middle section of the Changes Detail Panel displays the old value or prior value for the selected field (the value that was in the field prior to the change). This information can be blank (if a blank field was loaded during editing) or it may be present (if a previous value was loaded and was overwritten or modified during editing). Please note that multiple changes records can exist for a single field in a specific database record, so you may need to view more than one changes record to determine what has been loaded into a single
The third or lower section of the Changes Detail Panel displays the new value that was loaded into the selected field in the selected record during editing. The information displayed in this section may or may not match the current contents of the field. This is based on the number of changes records for the field, and the specific changes record you are viewing. In some cases, you may need to view multiple changes records to display the total update history for a single field in a single record.