How RFQ Response Report Works in iDempiere
The RFQ response report provides a consolidated view of all vendor responses for an RFQ. It presents prices, quantities, delivery terms, and rankings in one place, enabling quick and consistent evaluation without modifying transactions or opening individual responses.
Report Purpose and Scope
The RFQ response report exists to compare vendor quotations side by side for the same RFQ, across products and quantities. It ensures transparency in supplier evaluation and reduces decision risk caused by fragmented or partial information.
It is typically used after vendors have submitted responses and before selecting a winner or converting the RFQ into a purchase order.
Data Flow and Internal Logic
When the report is executed, the system scans all active RFQs that match the selected parameters. It pulls data only from completed RFQ responses, ensuring that incomplete or draft vendor entries are excluded.
Each response line is joined with its corresponding RFQ line and quantity, preserving the original request context while overlaying vendor-provided values such as price, discount, delivery days, and ranking.
The report then calculates comparison metrics like benchmark difference and displays ranking order if it has been defined.
Key Configuration and Controls
- RFQ Topic limits the report to a specific procurement campaign.
- RFQ Number narrows the output to a single RFQ document.
- Summary option controls whether results are aggregated or shown line-by-line.
- Only responses marked as complete are included.
Output Structure and Interpretation
The report displays, per vendor and product:
- Requested quantity vs quoted quantity
- Quoted price and benchmark price difference
- Delivery days and work dates
- Vendor ranking and response status
Business Use Cases and Outcomes
This report is used during supplier evaluation, price negotiation, and internal approvals. It enables faster decisions, fair vendor comparison, and clear audit trails.
The outcome is a confident selection of the best vendor based on price, delivery, and commercial fit, ready for conversion into the next procurement document.