Print Prices via Price Matrices (tdpcg0431m100)

Use this session to print prices by price matrix.

The price matrices are selected based on the matrix attributes you enter in this session, and the prices are retrieved from the price books that are linked to the selected price matrices.

The following tabs are available in this session:

  • General

    Use this tab to:

    • Enter a selection range for price matrices.
    • Enter a selection range for price books.
    • Enter an effectivity period for price matrices and price books.
    • Enter various report settings.
  • Sales, Purchase, Transfer, Line
    Dependent on the price matrix selection you entered on the General tab, on these tabs, you can enter ranges of matrix attributes for which price matrices must be selected. Based on the selected attributes, LN selects the price matrices that fall within the selection range and prints the effective price book lines of the price books that are linked to the price matrices.
Tip

This session is mainly used to have insight into the price set up for a specific business partner.

 

Matrix Type
Defines the type of a matrix definition and is linked to a set of matrix attributes.

The following matrix types are available in Pricing:

  • Sales Price
  • Sales Line Discount
  • Sales Total Discount
  • Purchase Price
  • Purchase Line Discount
  • Purchase Total Discount
  • Transfer Price
  • Line Promotions
  • Order Promotions
  • Client Freight Rate
  • Carrier Freight Rate

Each type has its own a selection of attributes. For a matrix type, the combination of a maximum of six attributes identifies the matrix definition.

Related topics

Matrix Type
Defines the type of a matrix definition and is linked to a set of matrix attributes.

The following matrix types are available in Pricing:

  • Sales Price
  • Sales Line Discount
  • Sales Total Discount
  • Purchase Price
  • Purchase Line Discount
  • Purchase Total Discount
  • Transfer Price
  • Line Promotions
  • Order Promotions
  • Client Freight Rate
  • Carrier Freight Rate

Each type has its own a selection of attributes. For a matrix type, the combination of a maximum of six attributes identifies the matrix definition.

Related topics

Matrix Definition
Defines the group of elements (matrix attributes) that a Pricing matrix uses to determine a price, discount, promotion, or freight rate.

Imagine you are a furniture vendor and you decide to maintain your sales prices based on two elements:

  • The specific item you sell.
  • The way to handle payments.

In this case, the matrix type is Sales Price, the matrix definition is Furni (this name is user-definable), and the matrix attributes are Item and Payment Method.

Note

Matrix definitions are maintained in the Matrix Definitions (tdpcg0110m000) session.

Related topics

Matrix Definition
Defines the group of elements (matrix attributes) that a Pricing matrix uses to determine a price, discount, promotion, or freight rate.

Imagine you are a furniture vendor and you decide to maintain your sales prices based on two elements:

  • The specific item you sell.
  • The way to handle payments.

In this case, the matrix type is Sales Price, the matrix definition is Furni (this name is user-definable), and the matrix attributes are Item and Payment Method.

Note

Matrix definitions are maintained in the Matrix Definitions (tdpcg0110m000) session.

Related topics

Matrix Sequence
For a matrix type, the order in which matrix definitions are searched for.
Note

Matrix sequences are maintained in the Matrix Priorities (tdpcg0120m000) session.

Related topics

Matrix Sequence
For a matrix type, the order in which matrix definitions are searched for.
Note

Matrix sequences are maintained in the Matrix Priorities (tdpcg0120m000) session.

Related topics

Buy-from BP
The buy-from business partner to which the price book applies.

Enter a buy-from business partner to only print prices for a specific buy-from business partner.

Buy-from BP
The buy-from business partner to which the price book applies.

Enter a buy-from business partner to only print prices for a specific buy-from business partner.

Ship-from BP
The ship-from business partner to which the price book applies.

Enter a ship-from business partner to only print prices for a specific ship-from business partner.

Ship-from BP
The ship-from business partner to which the price book applies.

Enter a ship-from business partner to only print prices for a specific ship-from business partner.

Currency
The price book currency.

The price book currency can differ from the price matrix currency.

Currency
The price book currency.

The price book currency can differ from the price matrix currency.

Item
The item for which the price book is created.
Item
The item for which the price book is created.
Period
The first day of the period during which price matrices and price books are printed if they are effective.
Note
  • A price matrix or price book must only fall partly within the effectivity period to be effective.
  • Before a price book line can be checked on effectivity, the price matrix to which it is linked must first be valid in the effectivity period.
Period
The last day of the period during which price matrices and price books are printed if they are effective.
Note
  • A price matrix or price book must only fall partly within the effectivity period to be effective.
  • Before a price book line can be checked on effectivity, the price matrix to which it is linked must first be valid in the effectivity period.
Print Language
If this check box is selected, the report must be printed in another language.
Note

Both price unit and quantity unit descriptions are printed language-dependent. LN prints the language dependent short unit description, as linked to the unit for the language, in the Unit Description by Language (tcmcs0107m000) session.

Language
The code of the language in which the report must be printed.
Note

Both price unit and quantity unit descriptions are printed language-dependent. LN prints the language dependent short unit description, as linked to the unit for the language, in the Unit Description by Language (tcmcs0107m000) session.

External Document
Use this check box to print an internal or an external report. If this check box is selected, business partner information is not printed on the report.
Print Price Matrix Attributes
If this check box is selected, the price matrix attributes are also printed on the report.
Print Multiple Matrices per Page
If this check box is selected, more than one price matrix is printed on a page if sufficient space is available on that page.

If this check box is cleared, each price matrix is printed on a separate page.

Print Selection Range Report
If this check box is selected, LN prints the settings you entered in this session on a separate report.

With this functionality, you can analyze the outcome of the report's values based on your settings.