Distribution Help and User Guide | Stock Matrix v25

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.

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.

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.

1.2. Purchase Order Processing

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

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.

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

2. Stock Matrix Menu

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.

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.

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.

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.

Stock Items tab

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

Generate Stock Codes

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

Generate Stock Items

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

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

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

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. This needs enabling in settings.

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

4.1. Settings

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. 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.

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.

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

4.3. Enable Module

The Enable Strings supplied by Sicon are displayed here.

5. Dashboards

Dashboards can be created here and new Dashboard Panels created.

6. Help and User Guide Menu Option

This menu option provides access to this Help & User Guide.

7. Help & User Guide Archive

7.1. Distribution - Stock Matrix v22.1

Distribution Help and User Guide | Stock Matrix

8. Roadmaps

The Sicon Product Roadmaps include product Improvements that we’re currently looking at developing and those that are under consideration for future releases.

Our Current Release Plan contains development that has been approved and is either currently underway or due to be added to the next release cycle.
The Future Release Considerations includes internal development plans and RFC’s to be considered for a future release cycle.

Please note, the Sicon Product Roadmaps content is not a committed plan and is subject to change.

How to navigate the Sicon Product Roadmaps

1. Select the Product Type you are looking for from the left side menu; Sicon Financials, Sicon Commercials, Sicon Manufacturing, Sicon Approvals.
2. Select the Product you would like to view.
3. Select the relevant Product Improvement from the dropdown list.
4. You can vote for your favourite ideas by simply clicking the thumbs up or thumbs down icons within each Product Improvement article, we will then use this to help determine development priorities.
5. If an improvement is scheduled to go into a specific Sicon release version, a tag will appear at the bottom of the page, if you select this tag you will be able to view all planned development for that particular release.
6. Alternatively, if you know what you’re looking for, you can search using the bar at the top of the page.

9. Release Notes

The release notes page shows which release of the system includes new features or issues resolved.

New features detailed in the Release Notes relating to Pre-Release versions will not be detailed in the current Help and User Guide until the end of development phase.

10. Known Issues

What is a Known Issue?
Known Issues are issues that have previously been reported and may require development to resolve, but have minimal impact on the software or user process. Generally they are either a cosmetic issue or have a suitable workaround available, which is detailed on each known issue entry. As such, they are not prioritised for a resolution and any linked Support Case will be given a link to this website and the case will be closed.

Sicon will review the current Known Issues and other development priorities ahead of each major release. This allows our finite development resource to be predominantly focused on high-impact issues and development. There is a voting button at the bottom of each Known Issue which can be used to indicate the priority of the issue to your site (1 = low priority, 5 = high priority).

This then updates the overall vote at the top of the page, which Sicon will then use to help determine priorities.

Once an issue is resolved in a major release, the website will be updated to reflect which version the update has been applied to; the Sicon Release Notes will also continue to document all fixes.