Finding Open GR/IR Items

Finding Open GR/IR Items in SAP

Table of Contents

1. Introduction
2. Using FBL3N (G/L Account Line Item Display)
3. Using FAGLL03 (G/L Line Item Display - New G/L)
4. Using MB5S (GR/IR Balances for Purchase Orders)
5. Using FBL1N (Vendor Line Item Display) for Vendor-Specific GR/IR
6. Refining Reports
7. Summary

1. Introduction

Open Goods Receipt/Invoice Receipt (GR/IR) items represent discrepancies between goods received and invoices processed, indicating potential financial inaccuracies. This document outlines how to find these open items in SAP using various standard transactions.

2. Using FBL3N (G/L Account Line Item Display)

• Purpose: To directly view open GR/IR items within the relevant G/L clearing account.
• Steps:
  • Go to transaction code FBL3N.
  • Enter the GR/IR clearing G/L account number (e.g., 191000).
  • Filter by relevant document types (e.g., WE for Goods Receipt, RE for Invoice Receipt) if needed.
  • Select "Open Items" under the "Status" filter.
  • Execute the report.
• Result: Displays all open GR/IR line items for the specified G/L account.

3. Using FAGLL03 (G/L Line Item Display - New G/L)

• Purpose: Similar to FBL3N, but for systems using the New General Ledger.
• Steps:
  • Go to transaction code FAGLL03.
  • Enter the GR/IR G/L account.
  • Enter the relevant company code and fiscal year.
  • Select "Open Items" and specify a "Key Date."
  • Execute the report.
• Result: Shows open GR/IR items based on the New G/L configuration.

4. Using MB5S (GR/IR Balances for Purchase Orders)

• Purpose: To identify GR/IR discrepancies at the purchase order level.
• Steps:
  • Go to transaction code MB5S.
  • Enter the company code.
  • Optionally, enter a vendor code for vendor-specific results.
  • Execute the report.
• Result: Provides a list of unmatched GR/IR transactions related to purchase orders, highlighting potential discrepancies.

5. Using FBL1N (Vendor Line Item Display) for Vendor-Specific GR/IR

• Purpose: To find GR/IR items associated with a specific vendor.
• Steps:
  • Go to transaction code FBL1N.
  • Enter the vendor account number.
  • Select "Open Items."
  • Execute the report.
• Result: Displays pending GR/IR items linked to the specified vendor.

6. Refining Reports

You can refine these reports further using various filters:

• Purchasing Document: Filter by specific purchase order numbers.
• Material: filter by material numbers.
• Date Ranges: Restrict results to specific posting or document dates.
• Company Code: Limit the search to a particular company code.
• Vendor: Limit the search to a specific Vendor.
• Document Type: Limit to specific document types (GR, IR).

7. Summary

Finding open GR/IR items in SAP is crucial for maintaining accurate financial records. This document has outlined four key transaction codes—FBL3N, FAGLL03, MB5S, and FBL1N—that can be used to identify these discrepancies. FBL3N and FAGLL03 provide a direct view of open items in the GR/IR G/L account, while MB5S focuses on purchase order-level discrepancies, and FBL1N shows vendor related GR/IR items. Furthermore, reports can be refined using various filters like purchasing document, material, and date ranges to pinpoint specific issues. By leveraging these tools, users can efficiently manage and reconcile GR/IR balances, ensuring financial integrity.