Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Purchase
  3. GRN Report With Quality Details | Vendor Rating Report | GRN with Rejected and Return QTY Details v 19.0
  4. Sales Conditions FAQ

GRN Report With Quality Details | Vendor Rating Report | GRN with Rejected and Return QTY Details

by Serpent Consulting Services Pvt. Ltd. https://www.serpentcs.com
Odoo

$ 184.21

v 19.0 Third Party
This module requires Odoo Enterprise Edition.
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Versions 18.0 19.0
You bought this module and need support? Click here!
Versions 18.0 19.0
  • Description
  • Manifest
Product Logo
SerpentCS Logo

GRN Report With Quality Details | Vendor Rating Report | GRN with Rejected and Return QTY Details

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.

  • Features
  • Screenshots
  • User Guide
  • FAQs

Highlighted Features

Comprehensive GRN Report

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.

Quality Inspection Tracking

Automatically integrate Quality Check results into the GRN report by displaying approved and rejected quantities along with inspection status and rejection details.

Return to Vendor Analysis

Track products returned to suppliers after quality failures and include returned quantities in the GRN report for complete procurement and inventory transparency.

Automated Vendor Rating

Evaluate supplier performance automatically based on Quality, Delivery, and Service metrics to eliminate manual vendor assessments.

Configurable Performance Score

Calculate vendor ratings using weighted criteria, including Quality (55%), Delivery (40%), and Service (5%), to generate an overall supplier performance score.

Vendor Performance Classification

Automatically classify vendors into performance grades such as A, B, and C, helping procurement teams identify reliable suppliers and improve sourcing decisions.

Advanced Report Filters

Generate GRN and Vendor Rating reports using flexible filters such as date range, vendor, purchase order, and product for faster reporting and analysis.

Professional Excel Reports

Export GRN and Vendor Rating reports to professionally formatted Excel files with vendor-wise grouping, merged headers, color-coded quantities, and grand totals.

Rejection Reason Tracking

Capture and display rejection reasons for failed quality inspections, making it easier to analyze defects and communicate corrective actions with suppliers.

Delivery Performance Monitoring

Measure supplier delivery performance by comparing expected and actual receipt timelines, contributing to the overall vendor rating.

Detailed Features

Comprehensive Goods Receipt Note (GRN) Reporting

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.

Integrated Quality Inspection & Traceability

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.

Intelligent Vendor Performance Rating

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.

Advanced Analytics & Flexible Reporting

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.

Professional Excel Report Export

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.

Seamless Purchase, Inventory & Quality Integration

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.

Screenshots

Create Purchase Order

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.

Confirm Purchase Order

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.

Process Incoming Receipt

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.

Generate Quality Checks

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.

Review Quality Check Records

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.

Open Quality Inspection

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.

Record Quality Inspection Result

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.

View Receipt After Quality Inspection

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.

Validate Product Quantities

Path :- Inventory → Operations → Receipts

Verify the received quantities before validating the receipt. Products that successfully pass inspection are prepared for transfer to warehouse stock.

Complete Receipt Validation

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.

Transfer Rejected Products

Path :- Inventory → Operations → Receipts

Move rejected products to the configured Quality Rejection location for further review, vendor return processing, or corrective actions.

Review Receipt Status

Path :- Inventory → Operations → Receipts

Monitor the receipt after product movement and verify approved and rejected quantities before initiating vendor return operations.

Create Return to Vendor

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.

Return Products to Vendor

Path :- Inventory → Operations → Returns

Process the vendor return transfer and send rejected products back to the supplier while maintaining complete inventory traceability.

Review Vendor Return Transfer

Path :- Inventory → Operations → Returns

Review the generated return transfer, including returned products, quantities, and destination vendor, before validating the operation.

Validate Vendor Return

Path :- Inventory → Operations → Returns

Validate the vendor return transfer to complete the return process. Returned quantities are automatically considered in the GRN report.

Select Lot/Serial Number for Product Receipt

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.

Complete Return to Vendor Transfer

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.

Generate Detailed GRN Report

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.

View Detailed GRN Excel Report

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.

Generate Vendor Rating Report

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.

View Vendor Rating Excel Report

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.

Access Goods Receipt Note (GRN) Reports

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

Configure Goods Receipt Note (GRN) Report Filters

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.


User Guide

Enable Multi-Step Receipts & Storage Locations

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.

Configure Warehouse Incoming Shipment Flow

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.

Create Quality Rejection Location

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.

Configure Return to Vendor Operation Type

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.

Enable Product Traceability

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.

Create Quality Control Point

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.

FAQ

May I install the app on my Odoo Online (SaaS) database?

No, third-party apps can not be used on Odoo Online. Unfortunately, Odoo SaaS blocks such a possibility.

Can I try the app before purchasing?

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.

What if I need any additional customization or extra feature with this addon?

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.

Suggested Products

Pricelist - Product Catalog XLS Report

Go to store

Purchase Tender Management

Go to store

Smart Product Catch Weight (Inventory)

Go to store

Eway Payment Gateway Integration

Go to store

Tours & Travels Ticket Management

Go to store

Tours & Travels Management | Tours & Travel Booking | Tours and Travels Management System | Tours & Travels software | Tour & travel crm

Go to store

Instant Purchase Order From Sale Order

Go to store

Web Auto Refresh and Reload

Go to store

Stock Lot Recall Report

Go to store

Web Widget Font

Go to store

Web Widget Icon

Go to store

Fruit Crate Management

Go to store

Business Solutions

Education Management

Education Management

Property Management

Property Management

Singapore Localization

Singapore Localization

Gym Management

Gym Management

Visa Management

Visa Management

Biometrics

Biometrics

HR Management

HR Management

Salon and Spa Management

Salon and Spa Management

Fleet Management

Fleet Management

Hotel Management

Hotel Management

Ring Central

Ring Central

Payment Provider

Payment Provider

Our Odoo Services

Odoo Customization

Odoo Consulting

Odoo Customization

Odoo Implementation

Odoo Customization

Odoo Development

Odoo Implementation

Odoo Testing

Odoo Integration

Odoo Data Migration

Odoo Support

Odoo Training

Odoo Support

Odoo Support

Hire Odoo Developer

Hire Odoo Developers

Help And Support

Ask for Query For any Query
Apps Checkout our Apps
Odoo Demo Check App Demo

rec  WhatsApp
rec (+91) 74860-40227
rec  Email
rec contact@serpentcs.com
rec  Website
rec www.serpentcs.com
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
LicenseLGPL-3
Websitehttps://www.serpentcs.com

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with