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

    • CP0400M Customer Order Processing Order Inquiry

      Inquiry Order Inquiry Application Overview This function gives you fast and easy access to all the necessary information to provide customer service for open or posted orders on file for a customer. It allows you to quickly access and display a ...

    • BM1601 Bill of Material Feature/Option Configuration Inquiry

      BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...

    • BMINQMNU Bill of Material Work Order Inquiry

      Work Order Inquiry Application Overview Work Order Inquiry is an interface that provides work order header information as well as current production progress. Current production progress, like Complete Quantity, Scrapped Quantity and Last Production ...

    • 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 ...

    • CP0406 Customer Order Processing Freight Calculation Inquiry

      Freight Calculation Inquiry Application Overview This inquiry allows you to calculate freight charges and any variations such as UPS Red vs. UPS 2nd Day, Fed Ex vs. UPS, increase or decrease order quantities, etc., for existing orders or potential ...