Goods Received Not Invoiced Purchase Orders Report (GR/IR)
Short answer: A custom ALV report that compares received and invoiced quantity and amount per purchase order item and lists items that were received but not invoiced, or invoiced but not received. Each line shows how many days the difference has been open and which purchasing group should follow it up.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB5S shows the GR/IR balance per purchase order, but not the purchasing group, the last goods receipt date or how long the difference has been open. In ME2N the "to be delivered" and "to be invoiced" selections do not combine with the final invoice indicator into a usable difference list. Teams merge two lists in Excel. The custom report calculates both directions from the purchase order history (EKBE) on one line and ages the difference.
Who uses it? Buyers, invoice verification teams and finance teams that reconcile the GR/IR account at month end.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| EKKOPurchasing Document Header | Company code, purchasing group, vendor and document currency (driving table) | — | ECC + S/4 |
| EKPOPurchasing Document Item | Material, plant, goods receipt / invoice indicators and final invoice flag | EKPO-EBELN = EKKO-EBELN | ECC + S/4 |
| EKBEPurchasing Document History | Purchase order history: goods receipt and invoice quantities, amounts and posting dates | EKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELP | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR | ECC + S/4 |
| I_PurchaseOrderHistoryAPI01Purchase Order History (API) | In S/4HANA it can replace EKBE with a clean core approach | PurchaseOrder = EKPO-EBELN AND PurchaseOrderItem = EKPO-EBELP | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | EKKO-BUKRS | Yes | 1000 |
| S_EKORG | Purchasing organization | Range / multiple | EKKO-EKORG | No | 1000 |
| S_EKGRP | Purchasing group | Range / multiple | EKKO-EKGRP | No | 001 |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No | 100245 |
| S_WERKS | Plant | Range / multiple | EKPO-WERKS | No | 1000 |
| S_BEDAT | Order date range | Range / multiple | EKKO-BEDAT | No | 01.01.2026 – 31.10.2026 |
| R_GRNI | Received, not invoiced | Radio button | — | No | X |
| R_IRNG | Invoiced, not received | Radio button | — | No | — |
| P_KEYDT | Key date for days open | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Purchase order | EKKO-EBELN |
| 2 | Item | EKPO-EBELP |
| 3 | Purchasing group | EKKO-EKGRP |
| 4 | Vendor | EKKO-LIFNR |
| 5 | Vendor name | LFA1-NAME1 |
| 6 | Material | EKPO-MATNR |
| 7 | Short text | EKPO-TXZ01 |
| 8 | Plant | EKPO-WERKS |
| 9 | GR qty | Calculated Σ EKBE-MENGE (VGABE = 1, SHKZG = H negative) |
| 10 | Invoiced qty | Calculated Σ EKBE-MENGE (VGABE = 2, SHKZG = H negative) |
| 11 | Difference qty | Calculated GR qty − invoiced qty |
| 12 | Unit | EKPO-MEINS |
| 13 | Difference amount | Calculated Σ EKBE-WRBTR (VGABE = 1) − Σ EKBE-WRBTR (VGABE = 2) |
| 14 | Currency | EKKO-WAERS |
| 15 | Last GR date | EKBE-BUDAT |
| 16 | Days open | Calculated Key date − last GR date |
Sample output
| Purchase order | Item | Purchasing group | Vendor | Vendor name | Material | Short text | Plant | GR qty | Invoiced qty | Difference qty | Unit | Difference amount | Currency | Last GR date | Days open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4500013102 | 00010 | 001 | 100245 | Atlas Ambalaj | RM-1001 | Carton box 40x30 | 1000 | 5,000 | 3,000 | 2,000 | PC | 8,500 | TRY | 09/28/2026 | 50 |
| 4500013140 | 00020 | 002 | 100387 | Delta Metal | RM-2040 | Steel sheet 2 mm | 2000 | 1,200 | 0 | 1,200 | KG | 73,440 | TRY | 10/21/2026 | 27 |
| 4500013177 | 00010 | 001 | 100512 | Ege Kimya | RM-3105 | Solvent-based paint | 1000 | 400 | 400 | 0 | L | 3,150 | TRY | 11/03/2026 | 14 |
| 4500013190 | 00030 | 003 | 100618 | Marmara Kablo | RM-4410 | Copper cable 4 mm² | 1000 | 0 | 600 | -600 | M | -21,600 | TRY | 0 |
How does the report work?
- EKKO and EKPO are read with the selection-screen criteria; deleted items (EKPO-LOEKZ) and items that expect no goods receipt or no invoice (EKPO-WEPOS or EKPO-REPOS blank) are skipped.
- The EKBE records of each item are read: VGABE = 1 goods receipts, VGABE = 2 invoices. Records with SHKZG = H (reversals, returns) are summed with a negative sign.
- Difference quantity = goods receipt quantity − invoiced quantity; difference amount = goods receipt amount (EKBE-WRBTR) − invoice amount, in document currency.
- Depending on the radio button, only positive differences (not invoiced), only negative differences (not received) or all differences remain. Items with the final invoice flag (EKPO-EREKZ) and a zero difference are skipped.
- The last goods receipt date is the highest EKBE-BUDAT of the VGABE = 1 records; days open = key date − last goods receipt date. The vendor name is added from LFA1; the ALV shows subtotals per purchasing group and vendor.
Performance notes
Aggregate EKBE in SQL with SUM and GROUP BY (EBELN, EBELP, VGABE, SHKZG) rather than in an ABAP loop. Narrow the EKKO selection by company code and order date. At month end, run the report as a background job and email the result to each purchasing group.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The order number opens ME23N, the difference amount opens the order history.
- Export to Excel
- Runs as a background job
- Send the result by email At month end each purchasing group can receive its own open differences.
Authorization objects
- M_BEST_EKOPurchase order display authorization by purchasing organization
- M_BEST_EKGPurchase order display authorization by purchasing group
- M_BEST_WRKPurchase order display authorization by plant
Frequently asked questions
In which currency is the difference shown?
In document currency (EKBE-WRBTR and EKKO-WAERS). If company code currency is needed, a second amount column based on EKBE-DMBTR is added.
How are returns and reversals handled?
EKBE records with debit/credit indicator SHKZG = H are summed with a negative sign, so a 102 reversal or an invoice cancellation reduces the difference correctly.
Does this report work on S/4HANA?
Yes. EKKO, EKPO and EKBE keep the same structure in S/4HANA. For a clean core approach, the order history can be read from the I_PurchaseOrderHistoryAPI01 CDS view.
Packages that include this solution
Month-End Close Control Pack
A pack that lists the five topics to clean up before the close with one company code and period selection: parked documents, unmatched bank items, …
Inventory Control and GR/IR Pack
A five-report pack that tracks stock value and stock accuracy with one plant and storage location selection: stock aging, materials below safety …
Related reports
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …
Blocked Vendor Invoices with Price and Quantity Variance Report
A custom ALV report that lists vendor invoices blocked for payment in invoice verification with the block reason, the received quantity, the price …
Open Purchase Orders by Vendor Report
A custom ALV report that shows, per vendor, the quantity not yet received, the open order value and the days of delay since the delivery date in a …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.