How to Track Offsetting Accounts Through Interim Accounts (e.g., Payables → GR/IR → Inventory) in S/

[byd]

Hi SAP Community,

I have a question about tracking offsetting accounts through interim accounts in SAP S/4HANA Cloud Public Edition.

Scenario:
In the procurement process with GR/IR clearing account, the accounting flow is:

1. Goods Receipt:
DR: Inventory 100
CR: GR/IR Clearing Account 100

2. Invoice Receipt:
DR: GR/IR Clearing Account 100
CR: Accounts Payable 100

Question:
When reviewing Accounts Payable line items, the offsetting account shows "GR/IR Clearing Account." However, we need to trace back to the original offsetting account (Inventory) that was posted when the goods were received.

In other words: Accounts Payable → GR/IR → **Inventory**

Is there a standard way in Public Edition to:
1. Display this multi-level offsetting account relationship in a single report?
2. Download a list showing the complete flow (AP → GR/IR → Inventory)?
3. Automatically link the invoice document to the original goods receipt accounting document?

Current Understanding:
- FI documents only show direct offsetting accounts (1-to-1 relationship)
- Standard reports like "Display Journal Entries" show GR/IR details but don't automatically link to the original inventory posting

Questions:
1. Is there a standard Fiori app or report that can trace through interim accounts?
2. Does the "Manage GR/IR Clearing Account" app (if available) provide this functionality?
3. Would we need to use custom queries via BTP/SAC to achieve this?
4. Are there any best practices for this requirement in Public Edition?

Any insights from actual implementation experience would be greatly appreciated!

Thank you in advance!

[HenrikeGrtecke]

Hello, thank you for your question. It has been forwarded to the experts. Kind regards, Henrike

[BobShen · Accepted solution]

Hi byd,

Your requirement to trace offsetting accounts through interim accounts (AP → GR/IR → Inventory) is a common challenge in SAP S/4HANA Cloud Public Edition. The standard FI documents only display direct offsetting account relationships, making it difficult to trace back through clearing accounts to the original postings.

Standard Fiori Apps for Document Traceability

Display Line Items in General Ledger App This app can show offsetting account information when configured properly. In the Settings, enable the 'Offsetting Account' column to make it visible [1]. However, this still shows only the direct offsetting relationship (AP to GR/IR), not the complete chain.

Clear GR/IR Clearing Account App (MR11) This app helps manage GR/IR clearing account balances and can show the relationship between goods receipts and invoice receipts [2]. It provides visibility into:

• Quantity differences between GR and IR
• Outstanding balances on clearing accounts
• Purchase order history with GR/IR assignments

Display Purchase Order Advanced App (ME23N) Navigate to Purchase Order History and select "Change View" → "GR/IR Assgt" to see the relationship between goods receipt quantities and invoice receipt quantities [2].

Document Flow and Linking Capabilities

Three-Way Matching Reports For comprehensive document tracking, consider using:

• My Purchasing Documents items app for connected documents with various filter criteria
• Monitor Purchasing Documents by Material app showing PO, pending quantities, and values [3]

Custom CDS View Approach You can create custom reports joining relevant CDS views :

• I_PurchaseOrderAPI01 for Purchase Orders
• I_MaterialDocumentItem for GR material documents
• I_SupplierInvoiceAPI01 for invoices
• I_JournalEntry for accounting documents

Recommended Solution Approach

Option 1: Enhanced Standard Reporting

1. Use the Reconcile GR/IR Accounts app to identify clearing account relationships
2. Combine with Display Line Items in General Ledger for offsetting account visibility
3. Cross-reference with purchase order history for complete traceability

Option 2: Custom Query Development Since Public Edition has limitations on direct customization, consider:

1. BTP integration with custom analytics
2. SAC queries connecting the relevant CDS views
3. API-based solutions for data extraction and analysis

Option 3: Process Enhancement

1. Implement systematic document referencing in posting descriptions
2. Use additional reference fields to maintain traceability links
3. Create periodic reconciliation procedures

Technical Implementation Notes

The offsetting account derivation logic follows SAP Note 39955, which displays "the offsetting account with the highest amount" when multiple accounts are involved [4]. This explains why you see GR/IR as the offsetting account rather than the original inventory account.

Best Practices

1. Automatic Clearing Jobs: Use "Automatic Clearing" or "GR/IR Automatic Clearing" jobs in the "Schedule General Ledger Jobs" app to maintain clean clearing accounts [2]
2. Document Flow Maintenance: Ensure proper document referencing throughout the procurement process
3. Regular Monitoring: Implement periodic reviews using the available GR/IR monitoring apps

While there isn't a single standard report that provides the complete multi-level offsetting account flow you're seeking, combining the available Fiori apps with custom CDS view queries offers the most practical solution for SAP S/4HANA Cloud Public Edition.

Would you like me to elaborate on any specific implementation approach or provide more details about configuring the available standard apps for your traceability requirements?

If you find my response helpful, kindly accept the answer and award a Kudo. This motivates me to serve you better

Br.Bob

[byd · Accepted solution]

thanks a lot! Your answer was very helpful for us!