Category: Supply

Supply User Manual ENG -> Products -> 3.4 LU-SU2103: Products in Supplier Catalogues -> E. How to configure auto-deletion of ESC supplier catalogue

The task is available under Tools > Tools > Delete Old ESC Catalogues. It is deactivated by default, and if active, will run with a default interval of six months between executions.

The functionality will be extended with a new “Specific Partner” field, allowing users to delete ESC catalogues only from a selected supplier. This field is mandatory.

The deletion configuration is defined at instance level.

The list will display:

• Source instance
• Date of deletion
• Number of catalogues deleted

Clicking on a record will show these details plus the Last Execution Message (including the catalogue names).

Supply User Manual ENG -> Products -> 3.4 LU-SU2103: Products in Supplier Catalogues -> D. How to export a supplier product catalogue price list

D. How to export a supplier product catalogue price list

Go to: Partners/Suppliers/ Supplier Catalogue

1. Tick the box of the Catalogue you want to export
2. Click on “Export lines (csv)” on the right action menu

Please note that this same export file can be updated and used to import updated data fro the Catalogue.

Supply User Manual ENG -> Products -> 3.4 LU-SU2103: Products in Supplier Catalogues -> C. How to update a supplier product catalogue price list.

C. How to update a supplier product catalogue price list.

Go to: Partners/Suppliers

1. Click on the pencil icon next to the Supplier whose Catalogue list you want to update to open it in edit mode
2. You can add a new line to an existing catalogue. When a new line is added directly to an existing catalogue, this new line must have its ranking assigned unless there is already a ranking at header level
3. Click on the Catalogues tab
4. Click on the Edit Catalogue icon next to the version/name of the catalogue you wish to update, this will open the Supplier Catalogue in a new screen

Edit tab

1. Click on the pencil icon next to the product that you want to update and make the appropriate changes. (NB the system will keep a record of the original and all previous versions of this catalogue list)
2. Click on the floppy disk icon next to the product line to save and repeat for all products as required.
3. Click on the Save button to save all changes to this Supplier Catalogue.

Update records

The supplier catalogues are linked to the supplier and can be synchronized. The supplier in each instance must be active in order for the catalogue to be synchronized and directly activated. Any product added / changed, or any change of price can be synchronized this way.

It is possible to see Track Changes for Catalogues which are for external suppliers. This is available via the Action menu in an excel format. This includes entries for any changes to the rankings of the catalogue & its lines. 

ESC’s catalogues are created by HQ and only synchronised to coordination. ESC partner must be activated as well as the catalogue by coordination. For catalogues for other external suppliers, these are synched down to project level, but the same rule applies for activating supplier and catalogue to have visibility of these.

N.B : It is not possible to add a product to a valid catalogue if the product is already included in another valid catalogue of the same supplier, otherwise you will receive a blocking warning message.

Supply User Manual ENG -> Products -> 3.4 LU-SU2103: Products in Supplier Catalogues -> B. How to create a supplier product catalogue price list

B. How to create a supplier product catalogue price list

In order to create a Supplier Catalogue Price List for a supplier, the user should follow the relevant MSF procedures outlined for gathering this sort of information, commonly known as market analysis (which may involve a Tendering process) before entering this data into the system. To make this inputting process as efficient as possible, it is possible to both enter this information directly into the Supplier/Product record as well as to import the data into the system via an excel file.

To enter the Supplier Catalogue Price List directly into the system, Go to: Partners/Suppliers

1. Enter the relevant search values in the header fields to find the Supplier you want
2. Tick the checkbox next to the supplier in the list view
3. In the Actions Menu on the right-hand side, click on New Catalogue. A screen displaying New

Catalogue will appear.

Product catalogue – 1

1. Enter the Name (how you want to call this Supplier’s catalogue)
2. The “From” field will automatically display today’s date but can be edited
3. Enter the “To” date using the calendar button. This should reflect the last day on which the information you are entering is valid (e.g. if the price is fixed how long it is fixed at this price according to the supplier’s bid). This field is not mandatory.
4. The currency will pull through from the currency entered for this supplier
5. Each new catalogue must have a ranking. A default “3rd choice” ranking is automatically assigned for catalogues created via synch or auto VI import but can be changed.
6. The Partner field will display the name of the Supplier that for which you are adding the catalogue price.
7. The Active box will reflect the state from the Supplier record (i.e. this should have been ticked if we are considering using them and have asked for product pricing etc)
8. In the Import Line section, the Add Attachment button will allow us to browse and select the excel file that we want to import, and next to this is the “Import file” button which will import the data from the excel file.
9. To Add products individually to the catalogue, in the Products tab, click on the New button
10. Click on the magnifying glass icon to bring up the search products window and enter the relevant values to find the product(s).
11. Select all relevant products, and check that the default UoM is correct (or changing it if need be)
12. Enter the minimum quantity which the supplier had based their price on. If there is none then 1 can be entered. If you try to save a line with 0 as a minimum quantity, the system will display an error message
13. Enter the Unit Price (which should be related to currency selected)
14. Enter any SoQ Rounding figure (e.g. if Pens are the product, the UoM and price may be per pen (i.e. pce), but the supplier sells the pens in packets of 50, in which can the rounding would be 50.)
15. Enter the minimum order quantity – depending on the supplier, the lowest quantity of the goods they would accept to supply per order
16. Enter any other comment
17. Click on the floppy disk icon to save the line and either repeat the steps to add another product or click on the Save button to save the catalogue list.
18. When catalogue is complete and all lines are saved, user can confirm catalogue by clicking on the Confirm button. This means all data it contains will be used by system for relevant transactions.

Product catalogues – 2

N.B: It is possible to have 2 active catalogues for the same supplier in the same instance as long as the products are different in each catalogue. If one supplier has more than one catalogue for the same product, user will receive a warning message.

Please note that it is possible to create a Catalogue of the Coordination instance at coordination instance. This function has been added to enable the related projects, to which this catalogue is synchronized down, to have a Coordination Supplier Catalogue. This will help to get more accurate estimation prices for intra-mission orders.

Supply User Manual ENG -> Products -> 3.4 LU-SU2103: Products in Supplier Catalogues -> A. LU Introduction (LU-SU2103)

A. LU Introduction (LU-SU2103)

One optional characteristic of the Supplier record is the supplier catalogue product list. This allows the user to view a list of the products which the supplier is able to supply, together with the prices and other relevant information of these products.

The advantage for users is that as soon as they request, or receive a request for any product which is listed in a supplier catalogue price list, the system will automatically be able to indicate which suppliers are able to source this product, at what price they offer it and other information such as standard packaging types, lead times etc, which can help the user to plan their supply activity more efficiently, as well as facilitating supplier management by providing current and historical information about supplier activities and pricing.

Supply User Manual ENG -> Products -> 3.3 LU-SU2102: Product List -> D. How to update a product list via import file

D. How to update a product list via import file

Go to: Products/Products

1. In the Products Search view, enter the appropriate values in the filters in order to view as many as possible of the products you want to add to the list.
2. Click on Search
3. From the results, select the checkbox next to each of the products that you want to add, or click on the checkbox at the top of the products lists to select all the products on the same page (but do NOT progress to any other pages)
4. In the Action Menu on the right-hand side, click on Import to list

Import to a product catalogue

1. The “Import to” list screen will open and display the list of products you have selected
2. In the List definition section, select from the options:
   • Existing list, if you want to add these products to an existing list
   • New list, to create a new list
   • Replace list, to replace a list which is already in existence
3. If you have selected either the Existing or Replace options, you will need to select the Existing list that you want to add to or replace.
4. If you have selected the New list option, enter the Name of the new list
5. And Enter the type

• List, if for a list
• Sub-list, if for a sub list which belongs to a “parent” list

1. Click on Import products button to import products to list
2. In the Product list screen enter all relevant details:

The fields Type and Name will have already been populated according to the information already in the system.

Import product list