Sales Order Inquiry field descriptions
If a field is not displayed in the Advanced Search, select it in the Criteria field to make it available.
Fields are presented in alphabetical order.
- Approval
-
If the Legacy/Operational Hold Approval field is available and you select Operational Hold Codes, then the Approval field becomes unavailable.
Specify a one-character approval code or hold code in this field to limit the search results to orders with that code. The codes that you can use in this field are specified in the Limit Managed Hold Codes field in SA Operator Setup-Entry Options-OE Entry Options. If you specify a code that you are not approved to use, then this message is displayed: Operator Security Prohibits Use of this Hold Code (1214).
- BackOrder Filter
-
Use this field to limit orders in the search results by back order status.
Select All to include all orders.
Select BO only to include only back orders.
Select Exclude BO to include all orders except back orders.
- Certificate/License ID
-
Specify a product certificate/license ID to limit the search results to orders with sales order lines for that certificate/license ID. If you specify a certificate/license ID, then you must specify additional search criteria.
- Criteria
-
Use this field to select additional fields to use in Advanced Search. If you search for these values, then you must specify additional criteria, such as a warehouse, customer, or product:
- Certificate/License ID
- Customer Reservations Contract
- Customer Reservations Override Only
- Restriction Code
- Restriction Override Only
If you do not specify additional criteria, then this message is displayed: "Insufficient Search Criteria Selected. Please Include Additional Filter(s) and Resubmit Your Search"
- Customer #
-
Specify a customer number to limit the search results to orders for that customer.
- Customer Purchase Order #
-
This field is displayed when you select Purchase Order in the Criteria field. Specify a customer purchase order number to limit the search results to order associated with that purchase order.
- Customer Reservations Contract
-
Specify a customer reservations contract number to limit the search results to orders with sales order lines for that contract. If you specify a customer reservations contract, then you must specify additional search criteria.
- Customer Reservations Override Only
-
Select this field to limit the search results to orders with an override quantity. These are orders where the customer’s reservation record was short the required quantity and stock was borrowed from another customer’s reservation record. If you use this field, then you must specify additional search criteria.
- Display
-
Select Header Info or Line Detail to indicate which type of information to display in the grid.
- Disposition
-
Use this field to limit orders in the search results by disposition. If you select All, then all orders, regardless of the disposition, are included in the search. If you select None, then orders without an assigned disposition are included in the search.
- Division
-
Specify a division to limit the search results to orders created with that division.
- Entered From
-
Specify a date to limit the search results to orders created on or after that date.
- Entered To
-
Specify a date to limit the search results to order created up to but not after the specified date.
- Freight Out Required Only
-
Select this option to limit the search results to orders where freight out was required.
- From Submit Date
-
Specify a date to limit the search results to orders with a submission date on or after that date.
- Fulfillment Order
-
Use this field to limit orders in the search results to fulfillment orders.
Select All Orders to include all orders.
Select Fulfillment Orders Only to include only fulfillment orders.
Select Fulfillment Orders Excluded to include all orders except fulfillment orders.
- Fulfillment Tied Order
-
Use this field to limit orders in the search results to fulfillment tie orders.
Select All Orders to include all orders.
Select Fulfillment Tied Orders Only to include only fulfillment tie orders.
Select Fulfillment Tied Orders Excluded to include all orders except fulfillment tie orders.
- Invoiced From
- Specify a date to limit the search results to orders invoiced on or after that date.
- Invoiced To
- Specify a date to limit the search results to order invoiced up to but not after the specified date.
- Legacy/Operational Hold Approval
-
This field is displayed when these criteria are met:
- Operational hold codes are activated.
- You selected Legacy/Operational Hold Approval in the Criteria field
Use this field to search for orders with legacy hold codes or operational hold codes. If you search for legacy hold codes, then use the Approval field to search for a specific approval type or hold code. You must use the Criteria field to access the Approval field. If you search for operational hold codes, then the Operational Hold Codes field automatically becomes available. Use it to search for specific operational hold code.
- Line Type
-
Select one or more line types to include in the search. If you do not select value, then all values are used in the search. If you select one or more values but not all values, then the Display field is disabled with the default value of Line Detail.
- Operational Hold Codes
-
This field is displayed when these criteria are met:
- Operational hold codes are activated.
- You selected Legacy/Operational Hold Approval in the Criteria field
- You selected Operational Hold Codes in the Legacy/Operational Hold Approval field.
Select an operational hold code to limit the search results to orders that contain the code.
- Product
-
Specify a product to limit the search results to orders for that product. The product does not have to exist in your inventory. You can specify a catalog product, a non-stock product, or a customer product number, barcode, supersede, or interchange defined in Product Extended Product Cross Reference Setup.
If the product that you specify is not set up in Product Setup, then Product Extended Product Cross Reference Setup is used to cross-reference it to one of your inventory products. If you specify an interchange or barcode product name and the product has a Product Extended Product Cross Reference Setup record, then this message is displayed: Cross Reference Product Selected For Use (cross reference type). The type of product, interchange or barcode, is included with the message. Crossref is displayed below the Customer Purchase Order # field to indicate a Product Extended Product Cross Reference Setup record is being used, and the product name is changed.
You must have the auto lookup feature activated to successfully enter an interchange product. If the auto lookup feature is not activated when you enter an interchange product, then non stock is displayed. If you close the Sales Order Inquiry and access the function again, then the interchange product is displayed correctly.
If you specify a customer product number, then the field is changed to the cross-referenced product. Crossref is displayed below the Customer PO field, but no message is displayed.
If these conditions are met, then the products that are available in the Product lookup are determined by customer values:
- You specify a customer in the Advanced Search before you access the Product field.
- Customer cross-reference records are set up in Product Extended Product Cross Reference Setup.
Catalog products and stocked products can be cross-referenced. A window is displayed when a catalog interchange product is specified. When you accept the default of yes, the catalog interchange product and this message are displayed: Cross Reference Product Selected For Use (Catalog-Interchg).
Leave the Product field blank to display information for all orders. If no product is specified, then the value of the line item is displayed in the far right column instead of the quantity. If notes exist for this product, then an asterisk (*) or exclamation point (!) is displayed next to the product. If an exclamation point is displayed, then the notes is required and you should review it before continuing.
- Product Type
-
Use this field with the product field to limit the search results to order line items, kit components, tally components or implied core products.
Select Product on Orders Only to include orders with the product. When you select Product on Orders Only, a line level search is performed. This type of search returns results faster than the All Orders and Kit Components option which searches components before searching lines.
Select Product used as Kit Component to include only orders with kit component products.
Select Product used as Tally Component to include only orders with tally component products.
Select Product used an Implied Core to include only orders with implied core products. When you select Product used as an Implied Core, you can also specify the type of core product and a time period in months.
Select All Orders and Kit Components to include all orders and kit components.
- Promised From
- Specify a date to limit the search results to orders promised to ship from the warehouse on or after that date.
- Promised To
- Specify a date to limit the search results to orders promised to ship from the warehouse up to but not after the specified date.
- Record Count
- Specify the number of records to include in the search results.
- Reference
- Specify reference information to limit the search results to orders with that information.
- Requested Ship From
- Specify a date to limit the search results to orders with a customer requested ship date on or after that date.
- Requested Ship To
- Specify a date to limit the search results to orders with a customer requested ship date up to but not after the specified date.
- Restriction Code
- Specify a restriction code to limit the search results to orders with that restriction code. If you specify a restriction code, then you must specify additional search criteria.
- Restriction Override Only
- Select this option to limit the search results to order where a product restriction override was used. If you select this field, then you must specify additional search criteria.
- Sales Rep External
- Specify the external sales rep initials to limit the search results to orders that are assigned to that sales rep.
- Sales Rep Internal
- Specify the internal sales rep initials to limit the search results to orders that are assigned to that sales rep.
- Sales Warehouse
- Specify a warehouse to limit the results to orders with that originating warehouse when the order is created for a different warehouse.
- Saved Searches
- If you have saved previous search criteria, then select your saved search to use the same search parameters.
- Ship To
- Specify a customer ship to number to limit the search results to orders for that customer ship to address.
- Shipped From
- Specify a date to limit the search results to orders with an actual ship date on or after that date.
- Shipped To
- Specify a date to limit the search results to orders with an actual ship date up to but not after the specified date.
- Show Only Direct Order Lines
- Select this option to limit the search results to orders with direct order, also known as drop ship lines.
- Stage
- Select an order stage to limit the search results to orders in that stage.
- Suspended Only
- Select this option to limit the search results to orders that are suspended in Sales Order Entry. The Suspended /Floor Plan column displays an ‘s’ for suspended orders or an ‘f’ for Floor Plan orders.
- Taken By
- Specify initials to limit the search results to orders that were taken by that individual.
- To Submit Date
- Specify a date to limit the search results to orders with a submission date up to but not after the specified date.
- Tracker #
- Specify a tracker number to limit the search results to orders with that tracker number. Tracking documents are created in the Overseas Trade (OT) module. They track individual purchase orders or purchase order lines that are being shipped from an overseas vendor. The third-party shipping application also creates tracker numbers that you can use to limit your search.
- Transaction Types
- Select a transaction type to limit the search results to that type of order transaction. Select Select All to display all orders, regardless of transaction type.
- Warehouse
- Specify a warehouse to limit the search results to orders for that warehouse.
- Warehouse Transfer Billed Orders
- Use this field to limit orders in the search results to warehouse transfer billed orders.