You can use the Dimension Matrix to work with variants across various order documents, to create and maintain document lines for item with variants in an easy way.
The Dimension Matrix is a page that gives you an overview of all variants that belong to an item, grouped according to their variant dimensions. For example, an item comes with two variant dimensions (color and size) and consists of the following variants:
| Color | Size |
|---|---|
| Black | S |
| Black | M |
| Black | L |
| Red | S |
| Red | M |
| Red | L |
The Dimension Matrix of the item will look like below, where the columns represent the first dimension (color), and the rows represent the second dimension (size).
By default, the columns and rows of the matrix are shown in their dimension value. If you wish to display the columns and rows in their description, you can enable the Dimension Matrix Show Description setting that is available in the matrix. The same setting is also available in Retail Setup, which you can configure and it will act as the default value for the setting in the Dimension Matrix.
If the item consists of three or more variant dimensions, you can use the fields in the Extra Combination Filters section to select the combination of variant values to be displayed.
The Dimension Matrix is available for the following document types:
- Retail Purchase Quote
- Retail Sales Quote
- Retail Purchase Order
- Retail Sales Order
- Retail Purchase Credit Memo
- Retail Sales Credit Memo
- Retail Purchase Return Order
- Retail Sales Return Order
- Retail Transfer Order
In the order document, the Dimension Matrix is accessible by creating a document line for items with variants, entering the Item No. but without filling in the Variant Code, and then drilling down in the Quantity field. Alternatively, you can also access the matrix by clicking the Show Dim. Matrix action in the Variant Framework menu.
In the Dimension Matrix, the Show Values field shows the current value being maintained. Depending on the document type, you can maintain the value for Quantity, Qty. to Receive, Qty. to Ship, and/or Qty. to Invoice. Besides, you can also use the Show Values field to view the value of Quantity Received, Quantity Shipped, and/or Quantity Invoiced.
By default, the document line for the variants is created in the base unit of measure, but you have the option to change it to the unit of measure that is selected in the item document line, by selecting the Document Unit of Measure option in the Unit of Measure field.
Note: After the first variant document line has been created, any subsequent variant document lines are created with the same unit of measure as the first document line.
In the Dimension Matrix, enter a value in the cells for the variants that you would like to work on, and click the OK button to close the matrix. The document lines will be created or updated for the variants based on the values that you have entered in the matrix. Only the document line for the item (without the Variant Code) is shown in the order document. You can use the Show Lines action in the Variant Framework menu to view the document lines for the variants.
You can also directly enter a value in the Quantity field on the document line for the item (without the Variant Code), and the quantity will be distributed among the variants based on the following conditions:
- If there are no existing variant document lines created for the item, the quantity is distributed to the variants according to their variant weights, as defined in the Variant Framework.
- If Collection Framework has been defined for the selected unit of measure, the quantity is distributed to the variants according to the collection pattern.
- If there are existing variant document lines created for the item, the quantity is distributed proportionally based on the existing quantity in the variant document lines.
The Dimension Matrix is also available for the posted documents related to the Retail Purchase Quote, Retail Sales Quote, Retail Purchase Order, Retail Sales Order, Retail Purchase Credit Memo, Retail Sales Credit Memo, Retail Purchase Return Order, Retail Sales Return Order, and Retail Transfer Order to provide an overview of the posted quantities of the variants.
See also