Price and Stock Availability

Use this widget to view the sales price and stock availability in different warehouses for a selected item.
Note: You must activate the OOLINE and MITBAL tables in the M3 Function Search administration before using the widget. To update table indexes, see Infor M3 CE Core Administration Guide.

As a homepage or workspace widget, you can retrieve and view data based on your selection from the Item List widget or as a context widget to M3 where InforItemMaster IBC message is published for your selected item. When you select an item, the Price and Stock Availability widget shows the sales price together with the graph showing all available stocks distributed in different warehouses. If you click a single bar in the graph, it will drill back to 'Item. Connect Warehouse' (MMS002). You can also search for an item using the item number to view other items other than the selected item from Item List

APIs used in the widget

The Price and Stock Availability widget requires application program interface (API) to retrieve data from M3 and vice versa.

This table shows details about M3 APIs available in this widget:

Program Transaction
CMS100MI Lst_WD_CuoCoLn
CMS100MI Lst_WD_AtpWhsBy
MMS200MI SearchItem
MMS200MI Get
MMS200MI GetItmPrice
OIS345MI LstPriceMargin
MNS150MI GetUserData
OIS100MI GetLine

To use and test the API, see procedure about Running of MI Transaction in Infor M3 Core Infrastructure and Technology User Guide.

Infor Business Context (IBC) messages

This widget retrieves data upon receiving these IBC messages:

  • InforItemMaster

From M3: When an M3 program publishes the InforItemMaster IBC message, this widget receives the message and retrieves the respective M3 APIs which return and display the appropriate data of a specific item.

From Workspace: When the Item List widget publishes the InforItemMaster IBC message, this widget receives the message and retrieves the respective M3 APIs which return and display the appropriate data of a specific item.
Note: Workspace is only available in Infor OS Portal.