Infor LN Integration: Include generic items in forecasting

A generic item in Infor LN represents an item structure that is configured according to a customer's preferences. When an actual sales order is specified in Infor LN for a generic item, the demand is recorded for the corresponding derived item. This means that for the generic item itself, no actual demand exists. Forecast, however, can exist for generic items as demand.

It is now possible to include generic items in forecasting. Forecasting at generic item level is controlled by the new SCV configuration parameter SCP_LN_FORECAST_GENERIC_ITEMS. The default value for the parameter is "N"; that is generic items are excluded from forecasting by default.

The Infor LN - Demand Planning integration by default imports all planning data from Infor LN. For items, this covers the master plan items and items whose generic/derived-from item is a master plan item. For sales orders, this covers all orders where the item fits into the above definition.

Depending on the value of the SCP_LN_FORECAST_GENERIC_ITEMS configuration parameter, planning data imported from Data Lake to Inbox is adjusted to work with regular items or with generic items. For items, and all item related master data, either generic items or derived items are removed from the imported item master (by setting the deleted flags to "Y"). For transactional data, when the parameter value is ’Y’, derived items are replaced with generic items. Currently this replacement happens for imported sales history, open sales orders and customer forecast.

The SCP_LN_FORECAST_GENERIC_ITEMS new SCV configuration parameter is added:

These new SCV database views are added:

  • SI_V_LN_ITEM_FILTER
  • SI_V_LN_ITEM_LOCATION_FILTER
  • SI_V_LN_ITEM_SUPERSESSION_FILTER
  • SI_V_LN_SALES_HIST_FILTER
  • SI_V_LN_SALES_OPEN_FILTER
  • SI_V_LN_DEMAND_FILTER
  • SI_V_LN_ITEM_TO_GENERIC_ITEM

These new mappings are added to read from the newly created views and adjust the imported records in Inbox:

  • BASE_SI_V_LN_ITEM_FILTER-SI_ITEM
  • BASE_SI_V_LN_ITEM_LOCATION_FILTER-SI_ITEM_LOCATION
  • BASE_SI_V_LN_SALES_HIST_FILTER-SI_SALES_HIST_TRX
  • BASE_SI_V_LN_ITEM_SUPERSESSION_FILTER-SI_ITEM_SUPERSESSION
  • BASE_SI_V_LN_SALES_OPEN_FILTER-SI_SALES_OPEN_TRX
  • BASE_SI_V_LN_DEMAND_FILTER-SI_DEMAND

These macros have been updated to apply the generic item adjustments after the import to Inbox is completed:

  • SCV - LN Import Demand Master Incremental
  • SCV - LN Import Demand Transactional Incremental
Note: This feature is available after loading the Infor LN template (base for LN.zip) for this version and is enabled after changing the value of the SCV configuration parameter SCP_LN_FORECAST_GENERIC_ITEMS. A new role or privilege is not required to access this feature.