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.
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
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.
Article ID: 301
Created On: Wed, Jun 13, 2012 at 1:50 PM
Last Updated On: Wed, Jun 14, 2023 at 5:25 PM
Online URL: https://kb.datafile.co.uk/article/log-changes-of-order-status-301.html