Defining the Search Criteria for RFQ Excel Export
Use this page to define the search criteria to export the RFQ lines assigned to the supplier to an Excel sheet.
To specify the search criteria:
- Select RFQ > RFQ Export.
-
Specify this information:
- Tenant/Customer
- The name of the customer who sends the RFQ.
- Facility
- The name of the facility from where the RFQ is floated.
- RFQ
- The code of the RFQ.
- Auction Type
- The RFQ lines with these
auction types are exported. Possible values:
- Traditional
- Reverse
- Sealed
- Line Type (P/A)
- The type of the RFQ line. Possible values:
- Primary: The RFQ line is related to the primary part.
- Alternate: The RFQ line is related to an alternate part.
- Part Group
- The code of the part group. The parts linked to the part group for which RFQ request is raised are displayed.
- Part
- The code of the part.
- MPN
- The manufacturer defined code of the part.
- Manufacturer
- The name of the manufacturer linked to the part.
- Buyer
- The name of the user (customer) who creates the RFQ.
- Status
- The status of the RFQ line. Possible values:
- Open: The RFQ submission date is open for suppliers to send bid responses.
- Submitted: A bid is submitted.
- You can export the RFQs that are set
to open and submitted status only if the following conditions are met:
- Bid date is not expired.
- No further processing is done in LN.
- Create Date
- The date range for the search criteria. The RFQs created in this range are exported.
- Expiry Date
- The date range for the search criteria. The RFQs for which the expiry date is in this range, are exported.
- Click Continue. The Export Result section displays the export count for the defined search criteria.
-
Click
Export to export the RFQ
line details to an Excel sheet. The supplier can specify this data for the
required RFQ lines in the Excel:
- Planned delivery date
- Bid quantity
- Unit Price
- Discount and Discount type
- Landed cost code and landed cost amount