Establishing Distribution Rules and Sets

To establish distribution rules and sets, use the Distribution Sets component (DST_SET_OM) and the Distribution Rules component (DST_RULE_OM).

Page Name

Definition Name

Usage

Distribution Sets Page

DST_SET_OM

Define distribution sets. Establish the distribution codes on the Distribution Pcts (percentages) page.

Distribution Rules Page

DST_RULE_OM

Define distribution rules to determine the order in which the system searches for matches against the distribution sets matrix when sales orders, contracts, and RMAs are entered.

If you want to determine account distribution by products, product groups, customers, customer groups, regions, order groups, Inventory business units, or any combination of these elements on a sales order, RMA, or contract, you need to define distribution sets and distribution rules. You can have multiple revenue, discount, and surcharge codes as long as they add up to 100 percent.

Note: Contracts, claimback contracts, and RMAs use only revenue codes.

Distribution sets assign account distribution information to combinations of defining elements.

During business unit setup, you can select one distribution rule on the PeopleSoft Order Management business unit Accounting and Billing page for sales orders and RMAs. Distribution rules for claimback contracts can be defined on the PeopleSoft Order Management business unit Claimback Settings page. All sales orders entered for that business unit use the distribution rule you select to determine default distribution codes. If the distribution rule fails to find a distribution set match for the sales order, the order uses the distribution codes that you define on the Accounting and Billing Options page. You can override default distribution codes during order entry on the Distribution Accounts page. For RMAs, use the revenue distribution accounts to change the revenue code.

The distribution code for contracts in established on the BU Definition page.

You base all your account distributions on the warehouse (Inventory business unit) and your products are shipped from four warehouses: A, B, C, and D, except for a single large customer (customer ID 50006). Sales order information for that customer is distributed to unique revenue, discount, and surcharge accounts.

You establish a distribution set with 50006 entered in the Customer field. Then you set up four additional distribution sets, each with a separate value in the Inventory business unit field and unique revenue, discount, and surcharge codes. Next, you establish a distribution rule called Default, with two lines. The first line has the Customer field selected, and the second has the Inv BU field selected.

You link the Default distribution rule with Order Management business unit OM2.

The system searches all sales orders entered in business unit OM2. When you enter orders for customer 50006, the system stops searching at the first line of the distribution rule after finding a match on Customer. The distribution codes that you established in the distribution set for customer 50006 access by default the orders. For all other orders, it continues to line 2, where it finds a match on Inventory business unit. The distribution codes that you selected in the distribution set for Inventory business unit A access by default all the sales orders referencing Inventory business unit A. The same is true for sales orders referencing warehouses B, C, and D.

Use the Distribution Sets page (DST_SET_OM) to define distribution sets.

Establish the distribution codes on the Distribution Pcts (percentages) page.

Navigation:

Set Up Financials/Supply Chain > Common Definitions > Distribution Accounting > Distribution Sets

Field or Control

Description

Document Type

Your selection determines which account is debited. Valid options are: Claimback Contract, Contracts, Sales Orders, and Returned Material Authorization.

Product ID, Product Group, Customer, Customer Group, Region, Order Group, and Inventory Business Unit

You can elect to set up account distribution for an individual or a combination of these elements. Select the fields from the available options.

Note: Your combinations cannot include both an individual customer and a customer group or an individual product and a product group.

"Customer" refers to the ship-to customer.

Distribution Type

The distribution type is an attribute of the distribution set. It is not used in deriving distribution accounting.

Use the Distribution Rules page (DST_RULE_OM) to define distribution rules to determine the order in which the system searches for matches against the distribution sets matrix when sales orders, contracts, and RMAs are entered.

Navigation:

Set Up Financials/Supply Chain > Common Definitions > Distribution Accounting > Distribution Rules

Note: The same elements that you selected on the Distribution Sets page appear as options on this page.

Field or Control

Description

Default

Select to indicate that this distribution rule is the rule to be used when no other rule is specified on the business unit.

Sequence Number

Determines the search hierarchy for matches with distribution sets. Once a single match is found, the system uses the set to assign distribution codes to the order, contract, claimback contract, or RMA.

Select the most detailed set definition for the first sequence and continue entering combinations in decreasing granularity. In other words, if you define a distribution set that applies to a single customer, select only the Customer check box on the first line. If you define a distribution set that applies to a region and customer group, select those check boxes on the second line, and so on.

Note: "Customer" refers to the ship-to customer.