Matrix Definitions (tdpcg0110m000)
Use this session to view, enter, and maintain matrix definitions.
To start the Matrix Definition (tdpcg0610m000) session, double-click a record.
- If you enter a matrix definition with the Matrix Priority field specified, LN automatically inserts a record in the Matrix Priorities (tdpcg0120m000) session. For this inserted record, the effective date is empty.
- You can update the Matrix Priority in the current session and in the Matrix Priorities (tdpcg0120m000) session. If a matrix definition has only one linked priority record, changes are synchronized between both sessions. If a matrix definition has several linked priority records, the Matrix Level and Matrix Priority fields are empty and unavailable in the current session.
- If you change the value of the Matrix Priority field to zero, the linked priority record is removed from the Matrix Priorities (tdpcg0120m000) session. If you remove the priority record from the Matrix Priorities (tdpcg0120m000) session, the Matrix Priority field becomes zero in the current session.
Field Information
- Matrix Type
-
Allowed values
- Sales Price
-
The corresponding matrix attributes are used for sales pricing.
- Sales Line Discount
-
The corresponding matrix attributes are used for calculating discounts on sales items at order line level.
- Sales Total Discount
-
The corresponding matrix attributes are used for calculating discounts at sales order line level. The discounts are applied to the respective lines based on determining and eligible check boxes on the lines.
- Purchase Price
-
The corresponding matrix attributes are used for purchase pricing.
- Purchase Line Discount
-
The corresponding matrix attributes are used for calculating discounts on purchase items at order line level.
- Purchase Total Discount
-
The corresponding matrix attributes are used for calculating discounts at purchase order line level. The discounts are applied to the respective lines based on determining and eligible check boxes on the lines.
- Transfer Price
-
The corresponding matrix attributes are used for pricing of items transferred from one (internal) warehouse to another warehouse. For example, goods moved from a nettable to a non-nettable warehouse.
- Line Promotions
-
The corresponding matrix attributes are attributes for promotions at order line level.
- Order Promotions
-
The corresponding matrix attributes are attributes for promotions at order header level.
- Client Freight Rate
-
The corresponding matrix attributes are attributes for client rate books.
- Carrier Freight Rate
-
The corresponding matrix attributes are attributes for carrier rate books.
- Matrix Definition
- Combine by Price Group
-
If this check box is selected, the Apply Cumulative Discounts option is available in the Price and Discount Recalculation Parameters (tdpcg0240s000) session. This option enables you to apply cumulative discounts to calculate discounts based on all items that belong to the same price group.
Note: This field is only applicable if the matrix type is Sales Line Discount or Purchase Line Discount.Performance aspects
The setting of this field could affect system performance and database growth. For more information, refer to Combine items for Pricing.
- Matrix Level
-
The discount level for the matrix definition, as set in the Pricing Parameters (tdpcg0100m000) session.
Note:- This field is only visible if the Multiple Discount Levels Implemented check box is selected in the Pricing Parameters (tdpcg0100m000) session.
- This field is only applicable for discount matrices.
- Matrix Priority
- Matrix Attributes 5