Sourcing Reports

RFx Summary Report

While the ICM Sourcing application provides businesses a comprehensive platform to manage bids from suppliers, previously it only provided buyers the ability to manage supplier details, requests for quotation, and similar tasks.

This release introduces dedicated reports for Sourcing which give visibility to top management and concerned departments on sourcing activities. It provides them with a consolidated view of data available for any RFx, with various categorizations, enabling them to take more informed decisions.

They will be able to generate reports using the following filters –Sourcing Event, Category, RFx Status, and RFx Created Date From/To.

The report will display details about the RFx/RFI. The results will be displayed in the descending order of the creation date of the RFx. The RFx ID will have a hyperlink to the supplier related information for the selected RFx. If no data is found, then a validation message will be displayed.

Access to these reports can be provided via Security Groups (similar to other reports). Only authorized users with access to Sourcing can view the Sourcing Reports, however, the privileges of the Reports further follow the authorization that the user has in ICM. If the user does not have the privileges to view a particular RFx in ICM, for example, they would not see those in the Report even though they have the view privileges for Reports.

Extracting the RFx Summary Report

1. Click the Reports tile on the Dashboard. The Reports page opens.
2. Select the Sourcing option from the Default Reports drop-down. The Sourcing Reports Dashboard page opens.

3. Click on the RFx Summary Report Dashboard tile. The RFx Summary Reports page opens.

4. Filter reports using the following fields –Sourcing Event, Category, RFx Status, andRFx Created Date From/To. The RFx Summary Report will be displayed with the following columns that can be sorted: RFx ID, RFx Name, Sourcing Event, Category, Primary Owner, RFx Created Date, RFx Status, Suppliers invited, Suppliers accepted invite, Suppliers declined invite, Suppliers without action, Suppliers Awarded

5. Click the RFx ID to view the report for the RFx, for example ICMAppSrcRFx_2. The Supplier Information Report will be displayed with the following columns: Supplier ID, Supplier Name, Supplier Contact Name, Invitation Action, Awarding Status, Awarding Date, Contract(s) – Agreement Code, Agreement Status, Bidding Status, Bidding Status Update Date, Selection Status. The report can be downloaded as an Excel Workbook (CSV/XLS) or PDF format.

The columns NDA, SOW, Warranty Agreement indicate the supplier contract classification as Prerequisite, Associate or Mandatory in brackets.

RFx Details Report

The RFx Details Report helps procurement, buyer teams and the business to view its sourcing requests and the responses to it. With this, they will be able to derive insights for future reference.

Based on user authorization, a report can be viewed for each RFx. It provides a detailed view of all activities taken up with suppliers, such as supplier actions, bidding details, awarding action, etc.

The RFx Details Report contains sections with the following data:

• RFx/RFI Information – This section gives details on the RFI such as RFI ID, Category and so on
• RFx/Round/Awarding Approval Pending Details – This section gives details on the number of bidding rounds, information on awarding and so on
• RFx Supplier Information – This section gives details on each supplier with contact details and statuses of bids awarded
• RFx Bidding details –This report opens in a new window and provides supplier-based, round-based and line-item based views.
• RFx Awarding details – This section gives the Awarding details for an RFx

Note: Bidding and Awarding details are only available for RFI.

Access to these reports can be provided via Security Groups (similar to other reports). Only authorized users with access to Sourcing can view the Sourcing Reports. Even if the users are authorized to view/access a specific report, the privileges of the Reports further follow the authorization that the user has in ICM. If the user does not have the privileges to view a particular RFx in ICM, they would not see those in the Report even though they have the view privileges for Reports.

Extracting the RFx Details Report

1. Click the RFx option on the Sourcing tile on the Home page. The RFx page opens, which displays a table with the list of RFxs in the system.

2. Click the View icon. The Details page for that respective RFx opens, for example RFx_25_RCD.

3. Click on the Reports tab at the bottom in the list of tabs. The RFx Details Report option is displayed.

4. Click the RFx Details Report option. The report opens in a new tab. It can be downloaded as an Excel Workbook.

The report will be displayed with the following columns: RFx ID, RFx Name, Category, Primary Owner, RFx Created Date, RFx Status, RFx Start Date, Suppliers invited, Suppliers accepted invite, Suppliers declined invite, Suppliers without action and Suppliers Awarded.

5. Click the + icon next to the Supplier Information section. The Supplier Information Report is the same as displayed in the RFx Summary Report.

6. Click the Bidding Details section. The Bidding Details Report opens with the following columns: Supplier Id, Supplier Name, Round Name, Shortlisted Status, Bid Submission Status, Line Item Name, Quantity, Base Price, Supplier Quote Currency and Total Price. 
7. Click the View Details By drop-down. The following options are displayed:

• Supplier View: Select this view to see a consolidated snapshot of bid responses in each round segregated by supplier.
• Round View: Select this view to see a consolidated snapshot of bid responses of suppliers segregated by round.
• Line View: Select this view to see a consolidated snapshot of supplier responses for respective line items.

8. Click the sorting icon to sort by Supplier Id, Supplier Name, Round Name or Shortlisted Status.

The Bidding details report (where applicable) further offers views from three perspectives:

• Supplier-based: Select this view to see a consolidated snapshot of bid responses in each round segregated by supplier
• Round-based: Select this view to see a consolidated snapshot of bid responses of suppliers segregated by round
• Line-item based: Select this view to see a consolidated snapshot of supplier responses for respective line items

For example, below screenshot displays the Bidding Details Report by Supplier View:

Note: Bid Submission Status details marked with an * (asterisk) indicate that it is a surrogate bid. For example, Not Submitted and Closed*.

Change History Report

With this release, the Change History Report has been introduced, which provides a consolidated view of the change history of rounds, bids, awarding, line items and attachments within a RFx.  This will help the procurement team to view the entire history at a glance for auditing purposes.
Based on the authorization, the report is accessible to buyers from within a RFx transaction. All the latest updated information captured at the point of time when the report is generated will be displayed in it. Suppliers do not have access to this report.
The Change History Report can be generated by applying the following filters: Entity Type, User Name, User Role and Supplier Name.
By default, the report is filtered on Entity Type as RFx/RFI. Based on requirement, users can change filters. The report provides details with columns such as Date & Time, Event, Entity Type, Entity Name, User Name, User Email, User Role, Supplier Name, Notes, Attribute Name, Previous Value and New Value.

Extracting the Change History Report

1. Click Sourcing > RFx on the Home page. The list of existing RFx and RFI is displayed.

2. Click the View icon against the item for which you want to view the Change History Report, for example Procurement for Admin Department. The RFx Details page opens.

3. Click the Reports tab. The following reports for the respective RFx are displayed - Attribute Value Report, RFx Details Report and Change History Report.

4. Click Change History Report. The report opens in a new tab.
5. Filter the report using the following fields: Entity Type, User Name, User Role and Supplier Name.

The report will be displayed with the following columns: Date & Time, Event, Entity Type, Entity Name, User Name, User Email, User Role, Supplier Name, Notes, Attribute Name, Previous Value and New Value.

• Date & Time: Displays the date and time of an event occurrence, for example when the RFx was created and published. The report is displayed in descending order, with the latest event occurrence record first. 
• Event: Displays details about the event, for example an Associated Document was created for a line item.
• Entity Type: Displays the type of entity, for example RFx or Suppliers, for which the change was logged in the history.
  • The different entities of RFx which are captured in the Change History Report are: RFx, associations to RFx such as Line Items, Suppliers, Supplier Contacts, Bulk Agreements such as NDA / Fixed Cost, Internal/External Attachments, Round Bids and Awarding. 
  • The different entities of RFI which are captured in the Change History Report are: RFIs and associations to RFIs such as Questionnaire, Questions, Bulk Agreements such as NDA / Fixed Cost, Internal/External Attachments, Round, Responses, and Supplier and Supplier Contacts.
• Entity Name: Displays the unique name of the entity instance For example,  Procurement for Admin Department.
• User Name: Displays the name of the user who performed the action mentioned in Event.
• User Email: Displays the email ID  of the user who performed the event.
• User Role: Displays the role of the user who performed the action mentioned in Event. For example, Primary Owner, Secondary Owner.
• Supplier Name: Displays the name of the supplier. Supplier Name will be displayed for supplier actions on a Bid or for a surrogate buyer's actions on behalf of a supplier.
• Notes: Displays the entries in the Notes section, if any.
• Attribute Name, Previous Value, New Value: Displays the previous and current values for the Attributes for an entity. For example, when the RFx is sent for approval, the Previous Value of the RFx (status) was Draft and the New Value of the RFx (status) is Waiting for Approval.     

6. Click the Export drop down menu icon. The options for file formats in which you can download the report are displayed: Excel, PDF and CSV.

7. Select the desired option, for example PDF. The report will be downloaded on your local drive as a PDF file.

Related Topics: Overview of Reports | Agreement Details Page | Legal and Compliance Reports | Admin Reports | Workflow Reports | Obligation Management Reports |