Home » Categories » Multiple Categories

Log Changes of Order Status

Datafile Software

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.

Custom Fields
  • Release ID: 5.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Revalue All Currency Orders
Viewed 1106 times since Tue, Jul 3, 2012
Designing a SOP System
Viewed 1159 times since Tue, Jul 3, 2012
Compact & Audit Database
Viewed 1259 times since Wed, Jul 4, 2012
Acknowledgements, Delivery Notes and Invoices
Viewed 1143 times since Tue, Jul 3, 2012
Header Optional 1
Viewed 1193 times since Wed, Jul 4, 2012
Sales Order Batch Update
Viewed 1268 times since Tue, Jul 3, 2012
Detail Back-2-Back
Viewed 1692 times since Wed, Jul 4, 2012
Delete - Delete an Order
Viewed 1136 times since Tue, Jul 3, 2012
System Profiles
Viewed 1423 times since Wed, Jul 4, 2012
E-Mail Settings - Document Design Manager
Viewed 1914 times since Wed, Jul 4, 2012