Pricing Parameters (tdpcg0100m000)

Use this session to:

  • View historical parameter settings.
  • Modify current parameter settings.

The pricing parameter session contains characteristics that control the pricing functionality in LN.

Note

By default, the Description field contains the date and time when the previous parameter set was saved. If you change the parameters, change or delete the Description text as well, in order to avoid confusion.

This session contains:

  • A history list of parameter sets and their effective dates
  • The current parameter set, at the top of the list (without an effective date)

To view historical settings, double-click one of the historical parameter sets.

To view or change the current parameter settings, double-click the set without an effective date that appears at the top of the list.

If you make the required changes and save the new parameter set, LN performs the following actions:

  • Adds the new set to the history list.
  • Updates the current set (at the top of the list).

Related topics

 

Effective Date
The date and time when the parameters are valid. The current parameter set (without an effective date) is located at the top of the list. The historical parameter sets are identified by their effective date. parameter set historical
Description
The description of the parameter set. For example, you can indicate why you change the parameters.
Multiple Discount Levels Implemented
If this check box is selected, multiple discount levels can be used to retrieve discounts.

If this check box is cleared, only one discount level is used to retrieve discounts.

Note

Only if this check box is selected, the Level Discount Control fields are visible and can be specified on the Sales and Purchase tabs. The number of discount levels that you can specify depends on the Number of Discount Levels field.

Number of Discount Levels
Specify the number of discount levels that you want to use to retrieve discounts. You can specify a maximum of five discount levels.
Note

A maximum number of 5 discount levels can result into an application of 11 numbers of discounts in LN. A maximum number of 4 discount levels can result into 9 discounts. A maximum of 3 discount levels can result into 7 discounts, and so on.

The reason for this is that:

  1. The first level of discount is the discount linked to a price book.
  2. The second up to the sixth level of discounts are the line discounts defined in the Sales Line Discount Matrices (tdpcg0130m110) and Purchase Line Discount Matrices (tdpcg0130m130) sessions.
  3. The seventh up to the eleventh level of discounts are the total discounts defined in the Sales Total Discount Matrices (tdpcg0130m120) and Purchase Total Discount Matrices (tdpcg0130m140) sessions.

To use, for example, 11 numbers of discounts, the Add/Overwrite Total Discounts must be set to Add. If you choose Overwrite, LN overwrites the line discounts with the total discounts, which means that the maximum number of discounts can only come to 6.

You can specify the values for the line discount levels and order discount levels in the Level Discount Control fields on the Sales and Purchase tabs. For example, if you specify a number of 2 in this field, you can define 2 discount levels: level 1 and level 2. As a result, you can select values such as First Discount for level 1 and Best Discount for level 2. LN sets discount control levels 3, 4, and 5 automatically to Not Applicable.

If you use multiple discount levels, the final discount is the result of combining discount percentages or amounts across the separate levels. You can only record and search for prices at a single level.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Number of discount levels.

Combine Items for Pricing
This check box affects the recalculation of cumulative prices and discounts in the Price and Discount Recalculation Parameters (tdpcg0240s000) session.

If this check box is selected,:

  • The Apply Cumulative Price check box is by default selected when you recalculate prices in the Price and Discount Recalculation Parameters (tdpcg0240s000) session.
  • And you select the Apply Cumulative Discounts check box in the Price and Discount Recalculation Parameters (tdpcg0240s000) session, LN looks if an item is present on more than one line and adds the quantities of that item for all the lines to calculate a new discount.
Note

The way prices and discounts are recalculated also depends on the value of the Recalculate Prices and Discounts fields on the Sales and Purchase tabs.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Combine items for Pricing.

Matrix Definition Number Group
The number group that is used for matrix definitions.
Price Book Number Group
The number group that is used for price books.
Discount Schedule Number Group
Update Default Price Book
If this check box is selected, the Default Sales Price Book is automatically updated when a sales price is changed, or added in the Items - Sales (tdisa0501m000) session.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Update default price book.

Apply Discounts if No Contract Discounts
If this check box is selected, and no discounts are found in contracts, LN continues searching for discounts in other places.

Related topics

Allow Update of Price Books used for Contracts
If this check box is selected, you can add, modify, or delete lines of a price book that is linked to an active contract.

If this check box is cleared, you cannot add, modify, or delete lines of a price book that is linked to an active contract.

If the price book is not linked to a contract or the contract is not active, the price book can always be updated.

Update Default Purchase Price Book
If this check box is selected, the supplier price book is automatically updated when a purchase price is changed, or added in the Items - Purchase (tdipu0101m000) session.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Update default price book.

Apply Discounts if No Contract Discounts
If this check box is selected, and no discounts are found in contracts, LN continues searching for discounts in other places.

Related topics

Attribute Set for Sales Price
The matrix attribute set that is used for Sales Price matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Attribute Set for Sales Line Discount
The matrix attribute set that is used for Sales Line Discount matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Attribute Set for Sales Total Discount
The matrix attribute set that is used for Sales Total Discount matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Price Control
This field determines which sales price must be used from price books that are found by means of a price matrix, which you can enter in the Sales Price Matrices (tdpcg0130m010) session.

You have the following options:

  • 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 price matrix.
Note
  • If you select Lowest Price, it does not mean that LN searches each entry (sequence) that is effective for a specific matrix definition in the Sales Price Matrices (tdpcg0130m010) session. LN only compares prices between price matrices that contain matrix definitions for which the Order Priority field differs in the Matrix Priorities (tdpcg0120m000) session.
  • Because LN retrieves the price with the most recent effective date in the price matrix for a specific matrix definition, you can define an exception by entering a new entry with new effective dates in the existing price matrix.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Example

Settings in the Matrix Priorities (tdpcg0120m000) session for the Sales Price matrix type:

Priority12
Effectivity period01/01/2006-31/12/200601/01/2006-31/12/2006
Matrix definitionCustPrlist

 

Price matrices in the Sales Price Matrices (tdpcg0130m010) session for the Sales Price matrix type:

Matrix definitionCust
Priority1020
Effectivity period01/01/2006-31/12/200601/05/2006-30/08/2006
Price in price book710

 

Matrix definitionPrlist
Priority1020
Effectivity period01/01/2006-31/12/200601/06/2006-30/09/2006
Price in price book811

 

In addition, the following applies:

  • The Price Control parameter is set to Lowest Price.
  • An item is sold on the 30th of May 2006 and all price matrices are applicable.

LN retrieves the correct price as follows:

  1. For the first applicable matrix definition, which is the matrix definition with Order Priority 1 in the Matrix Priorities (tdpcg0120m000), LN retrieves the price with the most recent effective date in the price matrix . As a result, LN retrieves the price of 10 from the Cust Price Matrix.
  2. Because the Price Control parameter is set to Lowest Price, LN continues searching for prices in price matrices that are also stored in the Matrix Priorities (tdpcg0120m000) session. As a result, from the Prlist Price Matrix, which is stored as Order Priority 2 in the Matrix Priorities (tdpcg0120m000) session, LN retrieves the price with the most recent effective date in the price matrix, which is the price of 8.
  3. LN uses the price of 8, which is the lowest price.
Level 1 Discount Control
Select the value to apply for level 1 sales discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 2 Discount Control
Select the value to apply for level 2 sales discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 3 Discount Control
Select the value to apply for level 3 sales discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 4 Discount Control
Select the value to apply for level 4 sales discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 5 Discount Control
Select the value to apply for level 5 sales discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Default Sales Price Book
The default sales price book is used to store the base price for sales items.
Note
  • Define a default sales price book if you want to use only one price book for all your sold-to business partners. If you select the Update Default Price Book, you can keep the default sales price book up to date.
  • If you link the default sales price book to a price matrix in the Sales Price Matrices (tdpcg0130m010) session, you can use the PriceFactor field to have different unit prices for various sold-to business partners.
Default Service Price Book
The price book used to store default prices on a service item.

Service items are added to the default service price book.

Sales Price Date Type
The date type against which the pricing and discounting validity is checked in Pricing.
Recalculate Prices and Discounts
This parameter controls the way prices and discounts are recalculated for the following entities:
  • Sales quotation lines
  • Sales order lines
Note

How prices and discounts are recalculated, also depends on the value of the Combine Items for Pricing check box.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Recalculate prices and discounts.

Add/Overwrite Total Discounts
The setting of this parameter determines whether newly entered total discounts are added to the previous discounts or overwrite these discounts.
Use Derived from Item
Define how you want LN to retrieve default prices for customized items.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Use derived from item.

Attribute Set for Purchase Price
The matrix attribute set that is used for Purchase Price matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Attribute Set for Purchase Line Discount
The matrix attribute set that is used for Purchase Line Discount matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Attribute Set for Purchase Total Discount
The matrix attribute set that is used for Purchase Total Discount matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Price Control
This field determines which purchase price must be used from price books that are found by means of a price matrix, which you can enter in the Purchase Price Matrices (tdpcg0130m020) session.

You have the following options:

  • 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 price matrix.
Note
  • If you select Lowest Price, it does not mean that LN searches each entry (sequence) that is effective for a specific matrix definition in the Purchase Price Matrices (tdpcg0130m020) session. LN only compares prices between price matrices that contain matrix definitions for which the Order Priority field differs in the Matrix Priorities (tdpcg0120m000) session.
  • Because LN retrieves the price with the most recent effective date in the price matrix for a specific matrix definition, you can define an exception by entering a new entry with a new effective date in the existing price matrix.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Example

Settings in the Matrix Priorities (tdpcg0120m000) session for the Purchase Price matrix type:

Priority12
Effectivity period01/01/2006-31/12/200601/01/2006-31/12/2006
Matrix definitionSupplierPrlist

 

Price matrices in the Purchase Price Matrices (tdpcg0130m020) session for the Purchase Price matrix type:

Matrix definitionSuppl
Priority1020
Effectivity period01/01/2006-31/12/200601/05/2006-30/08/2006
Price in price book710

 

Matrix definitionPrlist
Priority1020
Effectivity period01/01/2006-31/12/200601/06/2006-30/09/2006
Price in price book811

 

In addition, the following applies:

  • The Price Control parameter is set to Lowest Price.
  • An item is purchased on the 30th of May 2006 and all price matrices are applicable.

LN retrieves the correct price as follows:

  1. For the first applicable matrix definition, which is the matrix definition with Order Priority 1 in the Matrix Priorities (tdpcg0120m000), LN retrieves the price with the most recent effective date in the price matrix . As a result, LN retrieves the price of 10 from the Suppl Price Matrix.
  2. Because the Price Control parameter is set to Lowest Price, LN continues searching for prices in price matrices to which other relevant matrix definitions are linked that are also stored in the Matrix Priorities (tdpcg0120m000) session. As a result, from the Prlist Price Matrix, which is stored as Order Priority 2 in the Matrix Priorities (tdpcg0120m000) session, LN retrieves the price with the most recent effective date in the price matrix, which is the price of 8.
  3. LN uses the price of 8, which is the lowest price.
Level 1 Discount Control
Select the value to apply for level 1 purchase discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 2 Discount Control
Select the value to apply for level 2 purchase discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 3 Discount Control
Select the value to apply for level 3 purchase discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 4 Discount Control
Select the value to apply for level 4 purchase discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Level 5 Discount Control
Select the value to apply for level 5 purchase discounts.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Allowed values

Discount Control

Supplier Price Book
The code of the supplier price book
Note
  • Define a supplier price book if you want to use only one price book for all your buy-from business partners. If you select the Update Supplier Price Book, you can keep the supplier price book up to date.
  • If you link the supplier price book to a price matrix in the Purchase Price Matrices (tdpcg0130m020) session, you can use the PriceFactor field to have different unit prices for various buy-from business partners.
Purchase Price Date Type
The date type used for purchase pricing.
Recalculate Prices and Discounts
This parameter controls the way prices are calculated for the following entities:
  • Request for quotation lines
  • Purchase order lines
Note

How prices and discounts are recalculated, also depends on the value of the Combine Items for Pricing check box.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Recalculate prices and discounts.

Add/Overwrite Total Discounts
Determines whether newly entered total discounts are added to the previous discounts or overwrite these.
Use Derived from Item
Define how you want LN to retrieve default prices for customized items.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Use derived from item.

Attribute Set for Transfer Price
The matrix attribute set that is used for Transfer Price matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Transfer Price Date Type
The date type used for transfer pricing.
Price Control
This field determines which purchase price must be used from price books that are found by means of a price matrix, which you can enter in the Transfer Price Matrices (tdpcg0130m030) session.

You have the following options:

  • 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 price matrix.
Note
  • If you select Lowest Price, it does not mean that LN searches each entry (sequence) that is effective for a specific matrix definition in the Transfer Price Matrices (tdpcg0130m030) session. LN only compares prices between price matrices that contain matrix definitions for which the Order Priority field differs in the Matrix Priorities (tdpcg0120m000) session.
  • Because LN retrieves the price with the most recent effective date in the price matrix for a specific matrix definition, you can define an exception by entering a new entry with a new effective date in the existing price matrix.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Example

Settings in the Matrix Priorities (tdpcg0120m000) session for the Transfer Price matrix type:

Priority12
Effectivity period01/01/2006-31/12/200601/01/2006-31/12/2006
Matrix definitionSupplierPrlist

 

Price matrices in the Transfer Price Matrices (tdpcg0130m030) session for the Transfer Price matrix type:

Matrix definitionSuppl
Priority1020
Effectivity period01/01/2006-31/12/200601/05/2006-30/08/2006
Price in price book710

 

Matrix definitionPrlist
Priority1020
Effectivity period01/01/2006-31/12/200601/06/2006-30/09/2006
Price in price book811

 

In addition, the following applies:

  • The Price Control parameter is set to Lowest Price.
  • An item is purchased on the 30th of May 2006 and all price matrices are applicable.

LN retrieves the correct price as follows:

  1. For the first applicable matrix definition, which is the matrix definition with Order Priority 1 in the Matrix Priorities (tdpcg0120m000), LN retrieves the price with the most recent effective date in the price matrix . As a result, LN retrieves the price of 10 from the Suppl Price Matrix.
  2. Because the Price Control parameter is set to Lowest Price, LN continues searching for prices in price matrices to which other relevant matrix definitions are linked that are also stored in the Matrix Priorities (tdpcg0120m000) session. As a result, from the Prlist Price Matrix, which is stored as Order Priority 2 in the Matrix Priorities (tdpcg0120m000) session, LN retrieves the price with the most recent effective date in the price matrix, which is the price of 8.
  3. LN uses the price of 8, which is the lowest price.
Use Derived from Item
Define how you want LN to retrieve default prices for customized items.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Use derived from item.

Promotions Implemented
If this check box is selected, the promotions functionality is implemented.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Disable unused concepts.

Attribute Set for Line Promotions
The matrix attribute set that is used for Line Promotions matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Attribute Set for Order Promotions
The matrix attribute set that is used for Order Promotions matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Promotion Number Group
The number group that is used to categorize promotions.
Line Promotion Control
Select a value to indicate how you want to select a promotion for a sales order line.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Promotion control

Allowed values

Promotion Control

Order Promotion Control
Select a value to indicate how you want to select a promotion for a sales order.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Promotion control

Allowed values

Promotion Control

Promotion Date Type
The date type against which promotions must be effective to enable their retrieval by LN for orders or order lines. For example, if you select order date, promotions that are valid on the order date of an order can be selected for that order.
Freight Rate Book Number Group
The number group that is used to categorize freight rate books.
Attribute Set for Client Freight Rate
The matrix attribute set that is used for Client Freight Rate matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Attribute Set for Carrier Freight Rate
The matrix attribute set that is used for Carrier Freight Rate matrix types.
Note

Only the matrix attributes you marked as applicable for this attribute set are shown in Pricing. If this field is empty, all attributes are shown for this matrix type.

Search by Distance/Zone
This setting controls the way LN looks up freight rates.
Client Freight Rate Control
These settings control the search for client freight rates.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Carrier Freight Rate Control
This setting controls the way carrier freight rates are retrieved.

Performance aspects

The setting of this field could affect system performance and database growth. For more information, refer to Price, rate, and discount control.

Rate Date for Client Freight Rate
The date type against which client freight rates must be effective to be retrieved by LN to calculate the transportation costs of shipments, orders, or order lines. For example, if you select order date, client freight rates that are valid on the order date of an order can be selected to calculate the transportation costs of that order.
Rate Date for Carrier Freight Rate
The date type against which carrier freight rates must be effective to be retrieved by LN to calculate the transportation costs of shipments, orders, or order lines. For example, if you select the Order Date option, carrier freight rates that are valid on the order date of an order can be selected to calculate the transportation costs of that order.