Price, rate, and discount control

In the Pricing Parameters (tdpcg0100m000) session, the following Control fields determine the following:

  • Price control
    Which sales price or purchase price must be used from price books found by a price matrix.
  • Freight rate control
    Which client freight rate or carrier freight rate must be used from freight rate books found by a freight rate matrix.
  • Discount control
    Which sales discount or purchase discount must be used from discount schedules found by a discount matrix.

You can select the following values for these fields:

Price control

  • First Price
    For a specific matrix definition, LN uses the first price found in the price matrix with the most recent effective date.
  • Lowest Price
    For a specific matrix definition, LN retrieves the first price found in the price matrix with the most recent effective date. However, if other relevant matrix definitions are applicable, LN continues searching these other price matrices for lower prices. LN uses the lowest price found in a matrix.

Freight rate control

  • First Rate
    For a specific matrix definition, LN uses the first freight rate found in the freight rate matrix with the most recent effective date.
  • Lowest Rate
    For a specific matrix definition, LN retrieves the first freight rate found in the freight rate matrix with the most recent effective date. However, if other relevant matrix definitions are applicable, LN continues searching these other freight rate matrices for lower rates. LN uses the lowest freight rate found in a matrix.

Discount control

  • First Discount
    LN uses the first valid discount found in the level and ignores any other valid discounts. The first valid discount is the one with the lowest matrix sequence number. If more than one discount has the lowest sequence number, the first discount is the one with the latest effective date. When the first discount is found, the search for discounts stops.
  • Best Discount
    LN uses the best discount found for the level and disregards the matrix sequence priorities.
  • Accumulate
    All valid discounts are retrieved and returned as one aggregated percentage. The maximum aggregated discount percentage is 100.

For maximum system performance, to retrieve prices, select First Price, to retrieve freight rates, select First Rate, and to retrieve discounts, select First Discount.

Performance aspects
  • Effect on CPU: Yes
  • Effect on database growth: Not applicable