Generating Quotation Comparison Report

This is an analytical report that helps the user on deciding the supplier to whom the order is to be placed. You can generate a report that enables you to compare quotations.

Select the “Generate Quotation Comparison Report” link under the “Procurement Reports” business component.

The “Generate Quotation Comparison Report” page appears.

Enter the following in the “Report Criteria” group box. Data entry in the following fields is optional:

From RFQ #	The starting number in the range of RFQ numbers for which the quotation comparison report is required (Alphanumeric, 40). You can enter the number in full or specify it partially using the “*” character.
To RFQ #	The ending number in the range of RFQ numbers for which the quotation comparison report is required (Alphanumeric, 40). You can enter the number in full or specify it partially using the “*” character.
RFQ Date From	The starting date in the range of dates of the RFQ (Date Format).
RFQ Date To	The ending date in the range of dates of the RFQ (Date Format).
RFQ Location	Use the drop-down list box to specify the location in which the RFQ is raised. The system lists all the organization units in which the RFQ can be raised.
RFQ Type	Use the drop-down list box to select the type of the request for quotation for which the report must be generated. The system lists the following values: "Competitive Bidding" and "Selective".
RFQ Category	Use the drop-down list box to select the category of the request for quotation document for which the report must be generated. The system lists all the active RFQ categories that are defined in the “Create Common Category“ activity of the “Logistics Common Master” business component.
User Status	Use the drop-down list box to select the user-defined status of the request for quotation for which the report must be generated. The system lists all the 'active' user statuses defined in the “Create User Status” activity in the “Logistics Common Master” business component.
Buyer Group	The group identifying a set of buyers (Alphanumeric, 25).
Supplier #	The code identifying the supplier of the item (Alphanumeric, 45).
Created By	The name of the user who created the RFQ (Alphanumeric, 30).
Created Date	The date on which the RFQ was created (Date Format).

Click the “Search” pushbutton to display the search results.

The system displays the following in the “Search Results” multiline:

RFQ #	The number identifying the RFQ.
RFQ Date	The date on which the RFQ is created.
Location	The location in which the RFQ is raised.
RFQ Type	Indicates whether the RFQ is of type “Selective” or “Competitive”.
RFQ Category	The category to which the RFQ belongs.
User Status	The user-defined status for the request for quotation.
Buyer Group	The buyer group to which the login user is mapped.
Created By	The name of the user who created the RFQ.
Created Date	The date on which the RFQ was created.
No. Of Responses	The number of quotations received with respect to the RFQ.

Check the box in the “Select” column of the multiline to select the RFQ for generating the quotation comparison report.
Enter the following field in the “Report Options” group box:

Report Action

Use the drop-down list box to select the report action. The system lists the following options:

§ Print – Select this option to print the quotation comparison report.

§ View Report – Select this option to view the quotation comparison report.

Select the “Generate Quotation Comparison Report” link to generate the quotation comparison report.

Note: The report displays the lowest quote for each RFQ line item in a light green background.