Matrix structure

To retrieve the correct pricing information for calculating the price, discount, or transportation costs of an order, load, or shipment, you can specify pricing matrices. A matrix is a structure in which pricing information is grouped according to particular criteria.

Pricing matrices

In a pricing matrix, you can specify prices, discounts, promotions, or freight rates for customers, suppliers and/or items.

These pricing matrices are available:

  • Price matrix
  • Discount matrix
  • Promotion matrix
  • Freight rate matrix

Price matrix

In these sessions, you can maintain matrix attribute values and links to sales prices, purchase prices, or transfer prices:

Promotion matrix

In these sessions, you can maintain matrix attribute values and links to promotion discounts for sales orders and sales order lines:

Freight rate matrix

In these sessions, you can maintain matrix attribute values and links to carrier rate and client rate agreements:

Elements for Pricing matrices

Each Pricing matrix includes these elements:

  • Matrix type
    A matrix type is used to define the type of matrix definition and pricing matrix. The matrix type is linked to a set of matrix attributes. Each type of pricing matrix has its own matrix attributes.
  • Matrix definition
    A matrix definition includes a group of matrix attributes and a matrix type.
  • Matrix attributes
    Matrix attributes are the elements for which you want to set up a price, discount, promotion, or freight rate.

    Matrix attributes are table fields from the following sessions:

    • Business Partners (tccom4500m000)
    • Sales Orders (tdsls4100m000)
    • Purchase Orders (tdpur4100m000)
    • Items (tcibd0501m000)
  • Matrix priority
    A matrix priority is used to define the order in which LN searches matrix definitions. If a matrix definition has no matrix priority, LN does not search the Pricing matrices that use that definition.
  • Pricing information
    Pricing information, such as price books, discount schedules, promotions, or freight rate books must be specified for sets of matrix attributes and values.

The pricing elements can be specified in these sessions:

Pricing elementSession
Matrix type, matrix definition, matrix attributes, matrix priorityMatrix Definition (tdpcg0610m000)
Price bookPrice Book (tdpcg0611m000)
Discount schedule

Discount Schedule (tdpcg0612m000)

PromotionPromotions (tdpcg0140m000)
Freight rate bookFreight Rate Book (tdpcg0616m000)

 

Setting up Pricing matrices