Data Retrieval

You can use this setting to control which data is retrieved from M3 Business Engine.

These are the procedures to access Data Retrieval 1 and Data Retrieval 2.

Note:  These options are applicable for the IPW new UI. In IPW Classic, the parameters are placed differently between the two tabs.

Use this procedure to update Data Retrieval 1:

  1. From the menu, select Settings > Data Retrieval 1.
  2. Specify this information:
    Whs group
    Specify a warehouse group from M3 Business Engine.
    APS Policy
    Select an APS policy from the list. This setting is used to control which items are planned in the application.
    Forecast method
    Select Remaining forecast, Forecast, or None from the list. See Grid for details on how these options affect the demand columns in the grid.
    Stock transaction type
    Select Single trans or Multi trans.
    You can select Single trans if transaction MWS070MI > LstTrnByDateAPS exists. If it is not existing, you can select Multi trans.
    Forecast demand time
    Specify the demand time for the forecast as the forecast is defined on day level.
    Or/Pl or end offset
    Select the number of hours from the list. This setting is used to define the offset from the end of the bucket that is used for planning the date and time when creating new manufacturing orders or new purchase orders.
    MO start offset
    Select the number of hours from the list. This setting is used to define the offset from the start of the bucket that is used for planning the date and time when creating new manufacturing orders and taking supply decisions based on production start.
    IPW forecast cut-off
    Select the forecast cutoff in hours. If there is less than the forecast cutoff remaining in a bucket, the forecast is equal to zero in that bucket.
    Pl MO prod st time
    Select the check box to define the production start time for planned MO.
    Pl PO rel dt time
    Select the check box to define the release date time for planned PO.
    Planned PO time
    Select the check box to define the supply time for planned purchase orders.
    Released PO time
    Select the check box to define the supply time for released purchase orders.
    Alt U/M
    Select the Alternate Unit of Measure from (MMS015) that is retrieved. This is only required if the Group U/M is set to the Alternate U/M.
    Group U/M

    Select a display U/M option. This setting is used to configure the U/M for groupings of items in the grid.

    Use group U/M for items
    You can convert the item level in the grid to group U/M. This also affects the U/M for cells where decisions are taken.
    Use demand time fence for forecast
    Select the check box to use the demand time fence for the forecast. If selected, the forecast is set to zero if it is inside the demand time fence horizon.
    Planned PO time
    Planned PO is defined on the day level in (MMS080). You can define the planned PO to tie locally to control which bucket the planned PO is included in.
    Release PO time
    Released PO is defined on the day and time level in (MMS080). You can overrule the time locally on the released PO to control which bucket the released PO is included in.
  3. Click OK.

Use this procedure to update Data Retrieval 2:

  1. From the menu, select Settings > Data Retrieval 2.
  2. Specify this information:
    Exclude planned MO
    Select the check box to exclude the supplies from planned Manufacturing Order Proposals for order category 100 status 1 - 19.
    Exclude firm planned MO
    Select the check box to exclude the supplies from firm planned Manufacturing Order Proposals for order category 100 status 20 - 59.
    Exclude released MO
    Select the check box to exclude the supplies from released Manufacturing Order for order category 101 and order category 100 status 60.
    Exclude planned PO
    Select the check box to exclude the planned Purchase Order Proposals for order category 250 status 1 - 19.
    Exclude firm planned PO
    Select the check box to exclude the firm planned Purchase Order Proposals for order category 250 status 20 - 59.
    Exclude released PO
    Select the check box to exclude the released Purchase Order for order category 251 and order category 250 status 60.
    Exclude PO Agreement
    Select the check box to exclude the PO Agreement for order category 280.
    Exclude planned MO - material issues
    Select the check box to exclude the material demands from manufacturing order proposals for order category 110 order status 1 - 19.
    Exclude firm planned MO proposal / material issues
    Select the check box to exclude the material demands from manufacturing order proposals for order category 110 order status 20 - 59.
    Exclude released MO - material issues
    Select the check box to exclude the material demands from released manufacturing order for order category 111.
    Exclude internal distribution orders
    Select the check box to exclude the internal distribution orders. Select filter by DIDR=1 in MMS080MI > SelMtrlTrans.
    Exclude forecast
    Select the check box to exclude the forecast. Select the forecast from FCS350 > LstForQty.
    Exclude remaining forecast
    Select the check box to exclude remaining forecast. Select forecast from MMS080MI > SelForcTrans.
    Exclude production line
    Select the check box to exclude the production line information.
    Exclude planned DOs
    Select the check box to exclude the planned Distribution Order Proposals for order category 500/510 status 1 - 19.
    Exclude firm planned DOs
    Select the check box to exclude the firm planned Distribution Order Proposal for order category 500/510 status 20 - 59.
    Exclude released DOs
    Select the check box to exclude the released Distribution Orders for order category 501/511 and order category 500/510 status 60.
    Include stock transactions
    Select the check box to include the stock transactions.
    Include production start
    Select the check box to include the production start information.
    Include release date
    Select the check box to include the release date information on planned purchase order proposals.
    Include supplier name
    Select the check box to include the supplier name.
    Incl PO agreements not in Material Plan
    Select the check box to include the PO agreements that do not update the material plan. You can select this parameter by setting the DSBP=0 or Deselect PO trans which does not update POB in MMS080MI > SelMtrlTrans.
    Include PO agreements in supplies
    Select the check box to include the PO agreements in the supply cells in the grid.
    Include alternative routing
    Select the check box to include the alternate routing information on planned manufacturing order proposals.
    Include int dist orders in transit

    Select the check box to include the internal distribution order in transit.

    Note: This option only takes effect if Exclude internal distribution orders is selected in Data Retrieval 2. If the internal distribution orders have equal supply and demand, you can exclude them. The only exception is if the demand has been taken from a stock in the warehouse and has an in-transit supply. Therefore, you must include them even if you can exclude all the other internal distribution orders.
    Use demand time fence for forecasts
    Select the check box to use the demand time fence for the forecast. If selected, the forecast is set to zero if it is inside the demand time fence horizon.
    Include style information
    Select the check box to retrieve the color and options for each item number.
    Include planned PO with errors
    Select if the PO in status 00 are included in IPW. The PO can have a status 00 for several reasons, including missing price.
  3. Click OK.