Create Sourcing Rules That Source According to Quantity and Supplier

You can source according to quantity and different suppliers.

Assume you need to create these sourcing rules for your AS54888 item:

  • If the quantity is less than 100, then buy from Superfly Supplier.
  • If the quantity is equal to or more than 100, then buy from your Mr. T supplier.

Try it.

  1. Go to the Order Promising work area, then click Tasks > Manage Sourcing Rules.
  2. Create a new sourcing rule.
    Attribute Value
    Name Sources for AS54888
    Organization Assignment Type Local
    Start Date Select one.
  3. In the Sources area, click View > Columns > Manage Columns, then move these columns into the Visible Columns list.
    • From Quantity
    • Less Than Quantity
    • Quantity Unit of Measure
  4. In the Sources area, add two new sources.
    Type Supplier Allocation Percent Rank From Quantity Less Than Quantity Quantity Unit of Measure
    Buy From Superfly 100 1 Leave empty 100 Each
    Buy From Mr. T. 100 1 100 Leave empty Each
  5. Click Save.

Six months later, you add a new supplier, Michelle's Supplies, and you now have these new requirements.

  • If the quantity is less than 100, and if Superfly can supply the requested quantity, then buy from Superfly.
  • If the quantity is equal to or more than 100, and less than 200, and if Mr. T can supply the requested quantity, then buy from Mr. T.
  • If the quantity is equal to or more than 200, then buy from Michelle.
  • If Superfly or Mr. T doesn't have enough supply, then buy from Michelle.

To implement these changes, edit the suppliers you already added, then add two new sources for Michelle. Here's what it looks like.

Type Supplier Allocation Percent Rank From Quantity Less Than Quantity Quantity Unit of Measure
Buy From Superfly 100 1 1 100 Each
Buy From Mr. T. 100 1 100 200 Each
Buy From Michelle 100 1 200 Leave empty Each
Buy From Michelle 100 2 Leave empty Leave empty Leave empty