Tuesday, May 8, 2012

Service Parts Planning Setup - Step 7

Demand Priority Rules
The SPP planning engine will take the criteria and criteria order defined in the demand priority rules form to give the priority to the different orders like Sales orders, Forecast, Schedule Date etc while creating the 
planned orders.
Functional Details

Navigation -- Service Supply Chain Planner --> Setup --> Demand Priority Rules




Important Fields
Name - Name of the demand priority rule
Descrption  - Description of the rule
Enabled - Checkbox to enable or disable the rule

Criteria Name and Criteria Order


As shown in the above screenshot, the criteria can be, for example:
Schedule Date - The Due date of the orders will be given highest priority
Sales Orders, Forecasts & MDS Entries Priority - Sales Orders collected from source, Forecasts from Demantra will be given the highest priority



SPP Planning Engine will first plan and meet the demands given in the Demand Priority Rule.
Technical Details
The Demand Priority rules will be stored in the table - MSC_SCHEDULING_RULES



SQL Query

SELECT DISTINCT
  msr.meaning, -- Demand Priority Rule Name
  MSR.RULE_ID ,
  MSR.USAGE_CODE ,
  MFG.MEANING , -- Criteria Name
  MSR.SEQUENCE_NUMBER -- Criteria Order
FROM MFG_LOOKUPS MFG,
  MSC_SCHEDULING_RULES MSR
WHERE MFG.LOOKUP_CODE = MSR.USAGE_CODE
AND MFG.LOOKUP_TYPE   = 'MSC_PRIORITY_RULE'
and msr.meaning = 'Demand Priority Rule Name';