Suggested Products
Tours & Travels Management | Tours & Travel Booking | Tours and Travels Management System | Tours & Travels software | Tour & travel crm
GRN & Vendor Performance Report brings complete visibility into your incoming goods process by automatically tracking received, passed, rejected, and returned quantities for every Purchase Order line and lot/serial number, capturing Quality Check results and rejection reasons directly from Odoo's Quality module, and seamlessly supporting multi-step (3-step) receipt workflows with Input, Quality Control, and Stock locations; alongside detailed GRN reporting, the module also calculates a weighted Vendor Performance Rating out of 100%, combining Quality (55%, based on received versus rejected and returned quantities), Fulfillment (20%, ordered versus received quantity), On-Time Delivery (20%, actual receipt date versus expected date), and Service (5%, documentation compliance), automatically classifying vendors into A, B, or C grades to help procurement teams make data-driven decisions, with both PDF and Excel-ready reports available for internal review and audit purposes.
Generate a detailed Goods Receipt Note report directly from Purchase Orders with ordered, received, approved, rejected, returned, and pending quantities, giving complete visibility into every receipt transaction.
Automatically integrate Quality Check results into the GRN report by displaying approved and rejected quantities along with inspection status and rejection details.
Track products returned to suppliers after quality failures and include returned quantities in the GRN report for complete procurement and inventory transparency.
Evaluate supplier performance automatically based on Quality, Delivery, and Service metrics to eliminate manual vendor assessments.
Calculate vendor ratings using weighted criteria, including Quality (55%), Delivery (40%), and Service (5%), to generate an overall supplier performance score.
Automatically classify vendors into performance grades such as A, B, and C, helping procurement teams identify reliable suppliers and improve sourcing decisions.
Generate GRN and Vendor Rating reports using flexible filters such as date range, vendor, purchase order, and product for faster reporting and analysis.
Export GRN and Vendor Rating reports to professionally formatted Excel files with vendor-wise grouping, merged headers, color-coded quantities, and grand totals.
Capture and display rejection reasons for failed quality inspections, making it easier to analyze defects and communicate corrective actions with suppliers.
Measure supplier delivery performance by comparing expected and actual receipt timelines, contributing to the overall vendor rating.
Generate comprehensive Goods Receipt Note (GRN) reports by consolidating data from Purchase Orders, Stock Receipts, and Quality Inspections into a single view. Track ordered, received, approved, rejected, returned, and pending quantities with complete product and vendor information for better procurement visibility.
Seamlessly integrate with Odoo Quality to automatically capture inspection results, approved and rejected quantities, rejection reasons, and lot/serial number details. Ensure complete product traceability while maintaining accurate quality records throughout the receiving process.
Automatically evaluate supplier performance using real procurement and quality data. Calculate vendor scores based on configurable weighted criteria such as Quality, Fulfillment, On-Time Delivery, and Service, then classify suppliers into performance grades to support data-driven sourcing decisions.
Analyze procurement performance using powerful filtering options including date range, vendor, purchase order, product, and company. Generate meaningful reports that help procurement and quality teams identify trends, monitor supplier performance, and improve purchasing decisions.
Export GRN and Vendor Rating reports into professionally formatted Excel spreadsheets with company details, grouped records, quantity summaries, performance indicators, vendor ratings, and grand totals, making management reporting and auditing effortless.
Built to work seamlessly with Odoo Purchase, Inventory, and Quality applications, the module automatically synchronizes receipts, multi-step warehouse operations, quality inspections, and vendor returns without disrupting standard Odoo workflows, providing a centralized procurement and supplier evaluation solution.
Path :- Purchase → Orders → Requests for Quotation
Create a Purchase Order by selecting the vendor, adding products, quantities, and pricing. Once confirmed, the purchase order initiates the incoming goods receipt workflow used for GRN generation and vendor performance evaluation.
Path :- Purchase → Orders → Purchase Orders
Review and confirm the Purchase Order to generate the incoming receipt operation. Confirmation reserves the procurement process and creates the warehouse receipt for further inventory and quality processing.
Path :- Inventory → Operations → Receipts
Open the incoming receipt generated from the Purchase Order to begin receiving products. The receipt displays product quantities and the warehouse operation before quality inspection.
Path :- Inventory → Operations → Receipts → Quality Checks
Generate quality inspections for received products. The system creates quality check records according to configured control points before products are moved into stock.
Path :- Quality → Quality Control → Quality Checks
Review all quality inspection records created for the receipt. Users can monitor inspection status, responsible team, products, and pending quality operations.
Path :- Quality → Quality Control → Quality Checks
Open an individual quality inspection to review product details and perform the required quality validation before accepting or rejecting the received products.
Path :- Quality → Quality Control → Quality Checks
Record inspection results by specifying accepted quantities, rejected quantities, and quality decisions. These results are automatically used for GRN reporting and vendor evaluation.
Path :- Inventory → Operations → Receipts
Review the receipt after completing quality inspections. The receipt reflects inspection progress and allows users to continue warehouse processing based on inspection outcomes.
Path :- Inventory → Operations → Receipts
Verify the received quantities before validating the receipt. Products that successfully pass inspection are prepared for transfer to warehouse stock.
Path :- Inventory → Operations → Receipts
Validate the incoming shipment to complete the receiving process. Approved products continue through the warehouse workflow while rejected products remain available for further processing.
Path :- Inventory → Operations → Receipts
Move rejected products to the configured Quality Rejection location for further review, vendor return processing, or corrective actions.
Path :- Inventory → Operations → Receipts
Monitor the receipt after product movement and verify approved and rejected quantities before initiating vendor return operations.
Path :- Inventory → Operations → Receipts → Return
Create a Return to Vendor operation for rejected products. Users can specify return quantities before generating the outbound return transfer.
Path :- Inventory → Operations → Returns
Process the vendor return transfer and send rejected products back to the supplier while maintaining complete inventory traceability.
Path :- Inventory → Operations → Returns
Review the generated return transfer, including returned products, quantities, and destination vendor, before validating the operation.
Path :- Inventory → Operations → Returns
Validate the vendor return transfer to complete the return process. Returned quantities are automatically considered in the GRN report.
Path :- Inventory → Operations → Receipts → Add Line (Lot/Serial Selection)
Select the appropriate Lot/Serial Number for the received product during the receipt process. The popup displays the On Hand and Available quantities for each lot in the selected location, helping users choose the correct batch while maintaining accurate inventory traceability and quality control.
Path :- Inventory → Operations → Returns → Return Transfer
Review the completed Return to Vendor transfer after validation. The transfer status changes to Done, confirming that the rejected products have been successfully returned to the supplier. The completed return is automatically considered during Goods Receipt Note (GRN) reporting and vendor performance evaluation, ensuring accurate procurement and quality records.
Path :- Purchase → Purchase Orders → Open Purchase Order → GRN Report
Open the GRN Report wizard from the Purchase Order and configure the reporting period, report type, and reporting options. Users can include Quality Rejection Details and Return to Vendor information before exporting a detailed Goods Receipt Note report in Excel format.
Path :- Purchase → Purchase Orders → GRN Report → Export GRN Report (Excel)
Review the exported Detailed Goods Receipt Note (GRN) Excel Report, which consolidates vendor information, purchase order details, product and lot/serial information, receipt dates, approved quantities, rejected quantities, return quantities, rejection reasons, and grand totals. The report provides a complete overview of goods receipt activities for procurement analysis, quality tracking, and audit purposes.
Path :- Purchase → Purchase Orders → Open Purchase Order → GRN Report
Open the GRN Report wizard and select the Vendor Rating report type to evaluate supplier performance. Specify the reporting period and export the report to Excel, where vendor ratings are calculated using configurable metrics such as Quality, Fulfillment, Expected Arrival, and Service performance.
Path :- Purchase → Purchase Orders → GRN Report → Export GRN Report (Excel)
Review the exported Vendor Rating Excel Report, which provides a comprehensive evaluation of supplier performance. The report includes vendor details, purchase orders, ordered, received, approved, rejected, and returned quantities, along with fulfillment percentage, quality score, expected arrival performance, overall vendor rating, and vendor classification. It also displays the weighted rating formula used to calculate the final performance score, enabling informed supplier assessment and procurement decisions.
Path :- Purchase → Reporting → GRN Report
Access the centralized Goods Receipt Note (GRN) Report from the Purchase Reporting menu to analyze procurement activities and supplier performance. From this menu, users can generate both Detailed GRN Reports and Vendor Rating Reports with configurable reporting options, quality inspection details, return information, and Excel export support for comprehensive procurement analysis
Path :- Purchase → Reporting → GRN Report
Configure the Goods Receipt Note (GRN) Report by selecting the reporting period and applying optional filters such as Purchase Orders, Vendors, and Products to generate targeted procurement reports. Choose between Detailed Report and Vendor Rating report types, and optionally include Quality Rejection Details and Return to Vendor information for a comprehensive analysis of goods receipt and supplier performance.
Path :- Inventory → Configuration → Settings
Configure the warehouse to use Storage Locations and Multi-Step Routes for incoming shipments. Enabling these options allows products to move through Input, Quality Control, and Stock locations, providing the foundation for quality inspection, Goods Receipt Note (GRN) tracking, and vendor return management.
Path :- Inventory → Configuration → Warehouses → Warehouse
Set the warehouse incoming shipment process to Receive Goods in Input → Quality → Stock (3 Steps). This configuration ensures every incoming product passes through the quality inspection stage before becoming available in inventory.
Path :- Inventory → Configuration → Locations
Create a dedicated Quality Rejection inventory location to temporarily store products that fail quality inspections. This location separates rejected items from available inventory and simplifies vendor return processing.
Path :- Inventory → Configuration → Operation Types
Configure a dedicated Return to Vendor operation type by defining the source location as the Quality Rejection location and the destination as the vendor location. This enables a structured workflow for returning rejected products to suppliers.
Path :- Inventory → Products
Configure product traceability by enabling Lot or Serial Number tracking. This allows the system to record inspection results and rejection details for individual batches or serialized products, ensuring complete product traceability.
Path :- Quality → Quality Control → Control Points
Create a Quality Control Point for incoming products by selecting the product, operation type, control frequency, and inspection team. Quality checks generated from this configuration are used to calculate approved and rejected quantities in the GRN report and contribute to vendor performance evaluation.
No, third-party apps can not be used on Odoo Online. Unfortunately, Odoo SaaS blocks such a possibility.
In many cases, yes. We offer Demo videos, Screenshots, Live demo links (for selected apps) If you need a personalized demo, you can contact our support team.
We request you contact our team via contact@serpentcs.com to discuss the features and customization required so that we can provide you assistance with your request.
Tours & Travels Management | Tours & Travel Booking | Tours and Travels Management System | Tours & Travels software | Tour & travel crm
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Purchase (purchase) • Quality (quality_control) • Discuss (mail) • Invoicing (account) |
| Lines of code | 1939 |
| Technical Name |
grn_report_with_quality_details |
| License | LGPL-3 |
| Website | https://www.serpentcs.com |
Please log in to comment on this module