RFQ Excel Integration

The RFQs that are created in LN are published to SE. RFQ Excel integration functionality allows suppliers to export/import a set of RFQ lines, to an Excel sheet thereby saving considerable time. The supplier can decide not to bid for a specific RFQ line by setting No bid in the excel sheet. The supplier can specify this data for the required RFQ lines in the excel and import:

• Planned delivery date
• Bid quantity
• Unit Price

Optionally, supplier can specify:

• Discount and Discount type
• Landed cost code and landed cost amount

The landed cost details are exported only if the Allow Landed Cost Entry checkbox is selected on the Customer Profiles page.

During the import process, the bid data is validated. The error messages are generated for the RFQ lines that fail the validation process. For example, if the unit price is not specified for an RFQ line in the exported Excel, an error message is generated. The supplier can refer to these error messages to rectify the data in the excel sheet. The sheet is imported after all the errors are rectified.

Supplier can use the existing RFQ functionality to specify additional information such as - Price Book, Delivery Schedule, payment term, delivery term, carrier, warranty, end of life and so on.