On-Hand Stock (QTY 1)
Physical units currently in the warehouse, DC, or store
EDIFACT Inventory Report Message
Inventory Report INVRPT
The electronic inventory report — providing real-time or scheduled visibility into stock levels, movements, and location data across warehouses, DCs, and stores for informed replenishment decisions.
Key Segments & Structure
| Segment | Description | Status |
|---|---|---|
| UNH | Message header | M |
| BGM | Report number & type code | M |
| DTM | Report date / snapshot timestamp | M |
| NAD | Reporting party, recipient | M |
| LOC | Location (warehouse / store) | M |
| LIN | Product line (GTIN / article) | M |
| QTY | On-hand, on-order, reserved qty | M |
| INV | Inventory type qualifier | C |
| UNT | Message trailer | M |
M
Mandatory segment
C
Conditional segment
Message Overview
What is an INVRPT message?
The INVRPT (Inventory Report) is an EDI message that communicates stock levels, inventory movements, and warehouse data between trading partners. Unlike the other four messages which follow a strict buyer-to-supplier or supplier-to-buyer direction, INVRPT can flow in both directions — for example, a retailer sending stock-on-hand data to a supplier to trigger VMI replenishment, or a 3PL sending a warehouse stock report to the brand owner.
In Vendor Managed Inventory (VMI) programmes, INVRPT is the primary input: the supplier receives daily or weekly stock and sales data via INVRPT and uses it to proactively generate replenishment orders on behalf of the retailer — removing the need for the buyer to issue ORDERS manually.
Information commonly included
- On-hand stock
- On-order quantities
- In-transit quantities
- Available quantities
- Warehouse and store locations
- Reserved or blocked stock
- GTIN and article references
- Snapshot date and time
Inventory Visibility
Inventory Types Reported
On-Order (QTY 83)
Units expected from open purchase orders not yet received
In-Transit (QTY 68)
Units shipped but not yet received at destination
Available (QTY 85)
On-hand minus reserved or blocked stock — what can be sold/allocated
Common Applications
Use Cases
VMI — Vendor Managed Inventory
Supplier receives daily INVRPT and auto-generates replenishment orders when stock falls below min level
3PL to Brand Owner
Third-party logistics provider reports real-time stock held on behalf of the brand
Scan-Based Trading (SBT)
Retailer sends INVRPT with POS sell-through to trigger consignment stock invoicing
Pharma Batch Tracking
INVRPT includes batch numbers and expiry dates for regulated cold chain inventory
INVRPT Message FAQ
Frequently Asked Questions
How often is INVRPT typically sent?
Frequency depends on the trading agreement. In VMI programmes, retailers typically send INVRPT daily (sometimes twice daily for fast-moving categories). For 3PL reporting to brand owners, weekly is common. High-frequency INVRPT is also possible — some retailers send real-time or near-real-time stock updates for critical categories.
What is the difference between INVRPT and SLSRPT?
INVRPT reports current stock on hand (inventory levels), while SLSRPT (Sales Report) reports sales velocity and throughput. In VMI, both are often used together: SLSRPT tells the supplier how fast items are selling, and INVRPT tells them how much stock is left. Together they allow accurate replenishment forecasting.
Can INVRPT include batch and expiry date information?
Yes. The PIA segment captures batch numbers and lot IDs, and DTM with qualifier 36 (expiry date) can be added at the line level. This is particularly important in pharmaceutical, food, and cosmetics supply chains where FEFO (First Expiry, First Out) rotation and batch traceability are regulatory requirements.
What is the ANSI X12 equivalent of INVRPT?
In ANSI X12, the equivalent transaction set is 846 (Inventory Inquiry/Advice). It is widely used in North American retail and grocery, especially in VMI programmes between suppliers and distributors or large retail chains.
Odoo EDI Inventory Automation
