The I1 - Orders/Quotes/Invoices panel in Customer Consolidated Inquiries (ibis_su45) displays order, back order, quote and invoice details for the customer entered in the Header Section.

  • The Display Details drop list offers five options to display the information in the list box. The display options are:

    All -  displays all open orders, back orders, quotes and invoices for the customer
    Orders -  displays all open orders (default)
    Back Orders -  displays back orders from orders that have been invoiced; i.e. the original order had a product that was partially shippable
    Quotes -  displays quotes
    Invoices -  displays invoices

  • The Sort by list offers five options by which to sort the information in the list box. The sort options are:
    • Order + Invoice: sorts ascending by order number (oldest to newest).
    • Order (D) + Invoice: sorts descending by order number (newest to oldest).
    • Order Date + Order + Invoice: sorts ascending by order date (oldest to newest).
    • Order Date (D) + Order + Invoice: sorts descending by order date (newest to oldest).(Default).
    • Customer PO + Order + Invoice: sorts ascending by PO number first, then within identical PO numbers, sorts ascending by order number.

  • The field to the right of the 'Sort by' field allows you to determine the starting value for the items in the list box. This field is dependent on the 'Sort by' field, for example:

    • If you select the Customer+Order+Invoice as the 'Sort by', then a customer code is entered in this field and the list box will begin with that customer code.
    • If you select Order (D)+Invoice+Customer as the 'Sort by', then you enter an order number in this field and the list box will begin with that order number.

  • The list Box displays the following information for each order, back order, quote or invoice:

    • Order - displays the order number for all transaction types.

    • SDN - Shipping Document Number - displays one the following options:
      • Order - represents a sales order that has not been scheduled or a quote.
      • Number - represents the shipping document number itself. For example,
        • 01 represents the first printing.
        • 02 or higher represents the printed back order(s).
      • Blank - represents a back order that has not yet printed (this back order is the result of a previous invoice cycle.)
      • Dirbl - represents an invoice generated via Invoice Direct Bill and Credit Note Entry (ibis_in41) as a direct bill.
      • Notes - represents a credit note generated via IN41.
      • Delete - represents the invoice for the sales order that has been deleted.

    • Customer - represents the customer code as entered on the corresponding document.

    • Ship To - displays the alternate ship-to code. If the shipping address is the same as the customer's address, this field displays 'SAME'. If the ship-to is manually entered, this field displays 'MANUAL'. If an alternate ship-to code is entered on the order, quote or invoice, the ship-to code from Customer Ship-To Address (ibis_sush.su14) displays.

    • Order Date - represents the order date for quotes or orders, and invoicing date for direct bills and credit notes.

    • Customer P.O. - represents the customer PO number as entered on the corresponding document.

    • Order Value - represents the TOTAL order value.

    • Fill Rate - percentage calculated by dividing the shipped value by the outstanding value of the sales order.

    • Payment Status - reflects the status of all payments methods against the order.

    • Holds - displays any holds active for the order. These are only applicable for orders and quotes. Direct bills and credit notes are not controlled by holds. There are 7 possible hold statuses:
      • H - Manual Hold
      • C - Credit Limit Exceeded Hold
      • D - Delinquent Hold
      • S - Ship Complete Hold
      • M - Minimum Order Hold
      • N - Minimum Back order Hold
      • P - Pricing Hold

    • Invoice - represents the invoice number (if applicable) associated with the order. Since this program displays both open orders and invoices from history, this column is used in conjunction with the status to determine if the order is currently being processed through the invoice cycle, or has already been processed completely through the cycle.
      • If the invoice number displays under the 'Invoice Date' field and the 'Status' is invoiced, the order is currently being processed in IN41/IN42.
      • If the invoice number displays in the 'Invoice' field and the 'Status' is blank, the invoice is complete and now resides in history.

    • Invoice Date - represents the date on which the invoice was created.

    • Status - represents the current status of the order. Available options are:
      • Entered - an original sales order that is not scheduled.
      • Scheduled - a sales order that is scheduled via OE32.
      • Printed - a sales order that is printed via OE34 or OE33 or OM33.
      • Packing - a sales order that is currently open or on hold in Packing Station Packing Entry (ibis_ps30).
      • Shipping - a sales order that is assigned a shipment number and is currently open or on hold in PS30/Quick Ship or in P/S Shipment Entry (ibis_ps41).
      • Backordered - an unscheduled sales order that has been through the invoice cycle (IN42, IN43, IN44) at least once and contains only back ordered lines.
      • Invoiced - a sales order that has been assigned an invoice number, but has not been processed through the invoice cycle (IN43, IN44).
      • Blank - represents an invoice or credit note from history.
      • Quote - an open quote as entered in OE30 with quote as the transaction type.
      • Recalled - a sales order that is currently recalled.
      Note: Invoiced orders have no status.

    • Whse - the warehouse associated with the document.

    • Order Type - displays the order type. Valid options include: regular, sample, FOB (Free On Board), estimate or draw.

    Double-click on a line in the list box to open OE45/IN45.

  • Display Details Button - select a line from the list box and hover over Display Details until it becomes a button; click the button. The Order and Quote Consolidated History (ibis_oe45) or the Invoice History Consolidated Query (ibis_in45) screen opens to display the detailed order or invoice information. Double-clicking a line in the list box also invokes OE45 or IN45.