The matrix Countries x Vendors is used to rapidly set the possible Vendors per Country. This matrix will affect the list of potential Vendors when entering the price per Product.
This matrix can not be turned off.
The Countries are shown horizontally, the Vendors are listed on the left. The intersection either a green check () if there is a relation, or is blank of there is none. The matrix, as shown on-screen, is for overview only, you can not make edits on-screen.
To edit the matrix, use the import & export function :
Use the button 'EXPORT TO EXCEL' to export the current matrix to MS Excel. When the file is ready, you an choose to open or save it.
Please note that you need to save it as a Microsoft Office Excel 97-2003 Worksheet, and not as a Webpage or Office Excel 2007 ( .xlsx) format.
This matrix has a Conversion table below. This table helps you to enter the correct values in Excel. For this matrix, enter these values in Excel:
|•||Y : for Yes, stating that the relation is present|
|•||N : for No, stating there is no relation|
Edit the Excel sheet in MS Excel, then upload it to SSP, using the BROWSE and IMPORT buttons. When the Excel file is uploaded it is processed immediately, there is no need for an extra save action.
If there are errors, they are shown clearly on top of the screen, for example:
Optionally, you can choose to lock the matrix. The name of the Administrator who locked the matrix is shown and only that person can unlock it again. This functionality prohibits the event that 2 or more Administrators are working on the same matrix at the same, with the risk of overwriting each other's changes.
|•||Cancel : disregards any changes and returns you to the list of all Matrices.|