Users can export supplier data from the Supplier Management module into an Excel (.XLSX) file. The content of this file is determined by the current search results; therefore, users can control which suppliers are included in the export by applying search filters, such as specific supplier groups or metadata tags, prior to generating the file.
The exported file is organised into separate tabs, each containing specific categories of information.
There are two ways to make the Excel export:
From the Supplier card you can select the 3 line menu :hamburger: and select Export to (.xlsx). This will produce a Supplier Data Report
From the Supplier search view (within Search results) you can select the supplier by ticking the checkbox, and then select Export (xlsx.). You then have two options, 1) exporting a Supplier Data Report, or Create a basic information package.
Report tabs
Suppliers
(both reports)
This tab contains the primary registry data for the selected suppliers. The information includes:
Industries
(both reports)
This tab lists the service and product classifications associated with the suppliers.
Journal
(both reports)
This tab provides a history of diary entries and events associated with the suppliers.
Supplier's Contact Person
(both reports)
This tab isolates specific contact information for easier access.
Metadata
(both reports)
This tab details custom data tags attached to the suppliers, including the specific data types and values.
Contracts
(Supplier data report only)
This tab lists agreements associated with the supplier.
Claims
(Supplier data report only)
This tab lists claims or complaints associated with the supplier.
Supplier's Groups
(both reports)
This tab provides performance and ranking data relative to the groups the supplier belongs to.
Questions and answers
(Basic information package only)
On this tab you will see the full list of questions and answers. This includes all answer types.
Supplier liability
(Basic information package only)
This tab covers all liability information for the supplier
Supplier’s key information
(Basic information package only)
This tab provides business metrics for each supplier including turnover, profit and number of personnel.
Supplier request for information
(Basic information package only)
For all information requests sent to the supplier a row is added on this tab providing the details of each.
Article Ref: 241120251313
