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:

  1. Select RFQ > RFQ Export.
  2. 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.
  3. Click Continue. The Export Result section displays the export count for the defined search criteria.
  4. 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