Feature - Order Inquiry Revision Drill Down

Feature - Order Inquiry Revision Drill Down

Release Date: 1/8/19

The feature allows the user to drill down to the line item audit trail information for an order. A new F4=ChgHst option has been added to the Order Inquiry program.



The F4=ChgHst option is also available from the End of Line Items screen.



Finally, the F4=ChgHst option is also available from the Order Inquiry Order Totals screen.



When the F4 key is pressed, the user is presented with a list of dates when the order was changed.



Order Information

Order# - The order number viewed in the inquiry program
Cust - Customer number
Ship-To - If a ship-to is present on the order, it is displayed to the right of the customer number.
Ship-To Name - The ship-to name is displayed to the right of the ship-to number.
Entered - This is the date the order was entered.
Pick Date - This is the date the picking ticket was printed. This date and literal will only display if the picking ticket has been printed.
Inv Date - This is the date the invoice was printed. This date and literal will only display if the invoice has been printed.

Change Information

This information is grouped by date and user. If two users change the same order on the same day, two separate lines will be shown with one for each user.

Date - The date when the line items were updated 
First - The first recorded time for the date for the user
Last - The last recorded time for the date for the user
Elapse - The number of minutes between the first time and the last time
By - The Elliott user ID who made the change
Add - The number of records added
Chg - The number of records changed
Del - The number of records deleted
Cnl - The number of line items cancelled
Cls - The number of line items closed
Shp - The number of times the ship date was changed on the order

From this screen the user can press Enter to review the details of the changes made.



Order Information

Order# - The order number viewed in the inquiry program 
Date - The date of the change selected from the summary screen

Change Information
Time - Time the change was made
Line - The order line item number
Item# - Item number
Act - Action - Possible options are A (line item added), C (line item changed), D (line item deleted), V (line item cancelled), X (line item closed), and S (ship date changed)
Orig/New Qty Ord - Original and new quantity ordered
Orig/New Unit Prc - Original and new unit price
O/New Disc% - Original and new discount percent
Orig/New Req-Date - Original and new request date
Orig/New Prm-Date - Original and new promise date

Bottom Information
Item - Description from the line item audit trail file
By - Elliott user who changed the line item
Act - Full description of the action code - Possible options are Add, Change, Delete, Cancel, Close, and Ship Date.
Source - Application where the change occurred - Possible options are Order Entry, Sales Desk, Quote, Blanket Order, Cancel Order, Consolidate, Order Import, Web Services, Recurring Order,  Fill Back Order, and Stock Analysis.
Export - Display whether the line item audit information been exported
OrigOrd - The original order number if the order was consolidated or copied from another order

Restricted Access to the Drill Down
Restricting a user from seeing an item's cost is set up through User Global Security.



A new Global Setup flag has been added that will restrict access to the inquiry based on whether or not the user can see cost. 



If option 8. Must User See Cost To See COP Order Revision is set to Yes and the user does not have rights to see the item cost, they will not have access to the F4=ChgCst feature.

Programs Modified: NSCTLFIL.FD, NSCTLFIL.W32, NSCTLINI, NSCTLMN4, CP0400, CPORDINQ
Programs Added: CPREVSUM, CPREVDTL
CLS


    • Related Articles

    • Feature - Added CSV Support to the Item Audit Trail Report

      Release Date: 01/29/2019 Added CSV support to the Item Audit Trail Report. Enter "Y" in field "6. Export to CSV File." Enter the path and file name in field "7. CSV File Name & Path." The default for field 6 is N. Values for both fields will be ...

    • CP1900 Customer Order Processing Line Item Auditing Inquiry

      Line Item Auditing Inquiry Application Overview This application allows inquiries into the order action types of add, change, delete, and void that have occurred in the order entry sales process. Users, supervisors, and management can use this ...

    • Feature - Added F4=Revision Option to PO Inquiry Drill Down

      Release date: 5/31/2018 The PO Inquiry and the Drill Down to PO Inquiry from other areas are implemented as two different programs. Some of the functions implemented in PO Inquiry-- like F4=Revision -- are not implemented in PO Inquiry Drill Down. PO ...

    • CP1800S1 Customer Order Processing Purge Line Item Audit

      Purge Line Item Audit Application Overview This function will purge all history from the Line Item Audit Trail file. As with any purge process, you should ensure that you have any necessary reports for historical and record keeping purposes. Run ...

    • Feature - Added a Drill Down to Order by Item Inquiry in Newly Received Items Inquiry

      Release date: 1/8/2020 Version 8.5 and Up A new "F1/F2=Open Ord/Quo" option has been added to: COP-> Inquiry-> Newly Received Items Inquiry Pressing the F1 key will display all open orders for the highlighted item. Pressing the F2 key will display ...