Customer hierarchy for rebate processing

If Customer Hierarchy for Rebate Processing is selected in SA Administrator Options-Products-Rebates, a customer hierarchy is used to calculate rebates for customers. The rebate records are prioritized based on the customer and customer rebate type. The system moves down the hierarchy until a qualifying record is found. If multiple records are located, the one with the most recent start date is used.

If multiple level customer rebate types exist, the system rebate is calculated and compared to the customer rebate type levels in Customer Rebate Type Setup. The levels that are used also depend upon the settings in SA Administrator Options-Products-Multiple Level. The highest rebate is then applied to the sales order line.

This list shows the customer hierarchy that is used to calculate rebates:

Level 1 - Product

  • /customer/job/whse
  • /customer/job
  • /customer/whse
  • /customer

Level 2 - Rebate Type, or Rebate Type and Sub Type

  •  /customer/job/whse
  • /customer/job
  • /customer/whse
  • /customer

Leve 3 - Price Type

  •  /customer/job/whse
  • /customer/job
  • /customer/whse
  • /customer

Level 4 - Product Line

  •  /customer/job/whse
  • /customer/job
  • /customer/whse
  • /customer

Level 1 - Product Category

  •  /customer/job/whse
  • /customer/job
  • /customer/whse
  • /customer

Level 1 - Product

  •  /customer rebate type/whse
  • /customer rebate type

Level 2 - Rebate Type

  •  /sub type/all/whse
  • /sub type/all
  • /all/whse
  • /all

Level 3 - Price Type

  •  /customer rebate type/whse
  • /customer rebate type

Level 4 - Product Line

  •  /customer rebate type/whse
  • /customer rebate type

Level 5 - Product Category

  •  /customer rebate type/whse
  • /customer rebate type

Level 1 - Product

  •  /all/whse
  • /all

Level 2 - Rebate Type

  •  /sub type/all/whse
  • /sub type/all
  • /all/whse
  • /all

Level 3 - Price Type

  • /all/whse 
  • /all

Level 4 - Product Line

  • /all/whse 
  • /all

Level 5 - Product Category

  • /all/whse 
  • /all