Open Orders by Item

Use this widget to view all customer orders that are related to a specific item. Depending on where you are using the widget, you must select an item first either from the Item Details widget or from Infor M3 to retrieve open orders. Upon selection, you can view details of the item such as item number, item name, total order quantity, and total allocated quantity. Under the item display, you can browse through the customer orders and view details such as order number, line number, customer number, customer name, order quantity per customer, allocated quantity per customer, and the status of the open order. You can also drill back from a specific order to open 'Customer Order. Open Toolbox' (OIS300).

Prerequisites

  • Before using the widget, you must activate these tables in the M3 Function Search administration:
    • OCUSMA
    • MITMAS
    • OOLINE

    See information about updating table indexes in the M3 Core User and Administration Library (Cloud).

  • Ensure that the Item Details widget is added along with the Open Orders by Item widget from the widget catalog on your homepage or workspace. The Open Orders by Item widget retrieves data based on your selected item from the Item Details widget.
    Note: Workspace is only available in Infor OS Portal.

APIs used in the widget

The Open Orders by Item widget requires application program interfaces (APIs) that retrieve and display appropriate data.

This table shows the M3 APIs used in this widget:

Program Transaction
MMS200MI GetItmBasic
CMS100MI Lst_WD_OOLINE

See information about testing and running an API and its corresponding transaction in the M3 Core User and Administration Library (Cloud).

Infor Business Context (IBC) messages

The Open Orders by Item widget receives these published Infor Business Context (IBC) messages from either the Item Details widget or from Infor M3:

  • InforItemMaster
  • InforSalesOrder

Supported context messages

The Open Orders by Item widget receives these published inforBusinessContext and inforWidgetContext messages:

  • InforItemMaster
  • InforSalesOrder