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
    Depending 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 are 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 a specific 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.