Log Changes of Order Status

This feature allows for the recording on the order header and detail files the user-id, date and time that the ‘Change Status’ procedure was used against a sales/purchase order.In addition an optional comment can be recorded against the order header explaining the change.

Installation

Database Changes

Changes are required to the order header and, optionally, to the order detail databases.

File Item Name Type Description

HDR PREV-STATUS X (1) Holds the order status prior to change

HDR CHG-BY-USER X (6) Holds the user-id of the operator who changed the status

HDR CHG-ON-DATE D / E Holds the date the status was changed

HDR CHG-AT-TIME N Holds the time the status was changed

HDR CHG-COMMENT X (64) Holds comment explaining the change

DET PREV-STATUS X (1) Holds the order status prior to change

DET CHG-BY-USER X (6) Holds the user-id of the operator who changed the status

DET CHG-ON-DATE D / E Holds the date the status was changed

DET CHG-AT-TIME N Holds the time the status was changed

Application User Facilities

To enable the ‘Change Status Logging’ these new items need to be referenced within the Application User Facilities. A new parameter screen within the ‘Enter and Amend Orders / Advanced Input Facilities’ sub menu allows the Change Status Logging options.

Selecting the ‘Change Status Logging’ parameter screen allows you to reference the newly created data items so that, on change of status, the selected details are recorded.Note that you can leave the detail references blank so that details are only written to the order header.