Distribution Help and User Guide | Stock Matrix


Table of Contents

Product overview

Help and User Guide maintained for Sicon Distribution | Stock Matrix version 220.0.0 and upwards


The Stock Matrix module allows you to create multiple stock items from predefined attributes. This is useful where, for example, the stock item has multiple permutations regarding size and colour. The User can define the format and attributes required for the Stock Codes and the system will generate each variation of the code.

Dis Stock Matrix Section 1 image 1

Product Installation

Within Sage Admin, Distribution Scripts should always be enabled when adding the individual Features to the User Role.

Dis Stock Matrix Section 1 image 2


1. Changes to Standard Sage screens

In addition to the new menu options described later in this help and user guide, there are also changes to standard Sage screens, which are detailed in this section.


1.1. Sales Order Processing

Matrix – Allows the Stock Matrix function to be used from within the Sales Order.

Dis Stock Matrix Section 1.1 image 1

Multiple stock items, from predefined Stock Matrix Groups, can be added to the Sales Order. If the ‘Use Advanced Selection’ tick box is enabled, the drop-down list will filter as the user enters the text. However, as this can compromise the performance of this screen, it’s advised that this feature is only used when there is a large number of groups to filter.

The Sales Order quantities can be entered in a Grid or List view.

Clicking on the value entry field in Grid view displays the free stock quantity to the right.

Dis Stock Matrix Section 1.1 image 2

Dis Stock Matrix Section 1.1 image 3

Once the quantities have been entered, the Add to Sales Order button will create the Sales Order lines.

Where a Sales Price has been added to a Price List, a pop-up screen allows the edit of prices and discounts, before creating the Sales Order lines.

Dis Stock Matrix Section 1.1 image 4

Dis Stock Matrix Section 1.1 image 5

Dis Stock Matrix Section 1.1 image 6


1.2. Purchase Order Processing

Matrix – Allows the Stock Matrix function to be used from within the Purchase Order.

Dis Stock Matrix Section 1.1 image 7

Multiple stock items, from predefined Stock Matrix Groups, can be added to the Purchase Order. If the ‘Use Advanced Selection’ tick box is enabled, the drop-down list will filter as the user enters the text. However, as this can compromise the performance of this screen, it’s advised that this feature is only used when there is a large number of groups to filter.

As with the Sales Order, the Purchase Order quantities can be entered in a Grid or List view.

Dis Stock Matrix Section 1.1 image 8

Once the quantities have been entered, the Add to Purchase Order button will create the Purchase Order lines.

Dis Stock Matrix Section 1.1 image 10


2. Stock Matrix Menu

Dis Stock Matrix Section 2 image 1


2.1. Stock Matrix Settings

The attributes for the Stock Matrix are configured in the settings. Pre-defined Attributes of Size and Colour can be automatically added, and new ones set. The Attribute Options can be amended when, for example, colours are added or removed from the product line.

Dis Stock Matrix Section 2.1 image 1 LHS

Dis Stock Matrix Section 2.1 image 2 RHS

Update Matrix Groups will amend the details of any group that is using the attributes, after they have been modified.


2.2. Stock Matrix Groups

Attributes Tab

Within the Stock Matrix Groups, the user can create a new group and choose which attributes to use.

Dis Stock Matrix Section 2.2 image 1

Dis Stock Matrix Section 2.2 image 2 LHS

Dis Stock Matrix Section 2.2 image 3 RHS

The Stock Item Code Format will determine the format in which the codes are generated. The drop down list allows the user to add a group attribute, but free text can also be added to the field.

Dis Stock Matrix Section 2.2 image 4

Characters can be added to separate the attributes in the stock code, and the tick boxes determine whether the fields will be included when creating the code.

Dis Stock Matrix Section 2.2 image 5

Stock Items tab

In the Stock Items tab, all the details required to create the stock item are input.

Dis Stock Matrix Section 2.2 image 6

Generate Stock Codes

This will generate the stock codes based on the information input into the Stock Items Group screen.

Dis Stock Matrix Section 2.2 image 7

Generate Stock Items

Once the stock codes have been generated, the stock items can be created.

Dis Stock Matrix Section 2.2 image 8

At this point, stock can be added and prices set.

Dis Stock Matrix Section 2.2 image 9

Dis Stock Matrix Section 2.2 image 10

Dis Stock Matrix Section 2.2 image 11

The stock items have now been created and can viewed in the Stock List screen.

Dis Stock Matrix Section 2.2 image 12

Stock Matrix Utility

This allows stock matrix groups to be created based on existing stock items. It allows existing stock codes and names to be taken apart to create new matrix groups.


3. Reports

Consignment Transfer – Only available with Warehouse Replenishment module

Purchase Orders & Returns Linked to Sales Orders – Only available with POP Management

Purchase Orders Outstanding Tracking Dates – Only available with Container Manager.

Purchase Orders Awaiting Confirmation Detail – Only available with POP Management

Purchase Orders Awaiting Confirmation Summary – Only available with POP Management

Discontinued Stock Items – Only available with SOP Management.


4. Utilities Menu

Dis Stock Matrix Section 4 image 1


4.1. Settings

Dis Stock Matrix Section 4.1 image 1

Enable ‘Stock Matrix’ button – The Stock Matrix button will appear on the POP and SOP screens.

Default filter option for the stock matrix – The filter in the Stock Matrix screen will default to this setting.

Enable Stock Matrix Utility – Enables the Stock Matrix utility to be used.


4.2. Sage to Sicon SO Fulfilment

This screen allows you to update existing Sales and Purchase Orders to use the new fulfilment methods in Distribution. You can click the Run button to apply the switch to all live and on hold orders, or alternatively specify individual sales or purchase order numbers and click the relevant run button next to the order number field.

Dis Stock Matrix Section 4.2 image 1


4.3. Import Stock Item Settings

The Distribution Settings, required within the Stock Item Details screen, can be imported via a .csv file. Clicking on the Example Import File button provides the user with the Excel sheet to populate, and subsequently save as a .csv file.

Dis Stock Matrix Section 4.3 image 1

The Check File button will check the data for any errors. Lines with errors will be highlighted in red. Hovering the mouse over the Stock Item will display the reason for the error. Please note, the Stock Item data must be in the exact format as the data in Sage, i.e. capitals/lowercase.

Dis Stock Matrix Section 4.3 image 2

Once all the data is correct, the Import button will no longer be greyed out and the data can be imported.


4.4. Enable Module

The Enable Strings supplied by Sicon are displayed here.

Dis Stock Matrix Section 4.4 image 1


5. Dashboards

Dis Stock Matrix Section 5 image 1

Dashboards can be created here and new Dashboard Panels created.


6. New Features & Important Information

Distribution New Features & Important Information

Sicon Main Menu