Vendor Report by IO Type and Clearing Date

[Atul_Chavan]

Hello,

Is there a standard SAP report in ECC 6.0 which lists Vendor invoices/credit memos by IO/IO type and Clearing date (Payment date)?

[Jeremy_Deo]

Hello dear user,

And thank you for asking your question in the SAP Community blog.

In SAP ECC 6.0, there is no single standard report that directly lists vendor invoices and credit memos by:

• Internal Order (IO)
• IO Type
• Clearing Date (i.e., Payment Date)

However, you can get close by using or combining a few standard transactions:

1. Transaction: FBL1N – Vendor Line Item Display

• Use this report with the following filters:
• Document Type: KR (Invoice), KG (Credit Memo)
• Clearing Date: fill in your desired range
• Selection Criteria: Enter Internal Order under "Dynamic Selections" (KOSTL – Cost Center / AUFNR – Internal Order, depending on your posting)
• Status: "Cleared Items" or "All Items" (to include payment date)
• Output: Includes document number, amount, clearing document (payment), and you can add the Internal Order via the layout.

2. Transaction: KOB1 – Actual Line Items for Orders

• Filters by:
• Internal Order or Order Type
• Posting Date or Fiscal Period
• Shows all costs posted to an order, including vendor invoices
• Limitation: Does not show clearing (payment) date

3. Custom Report / SQVI Join (Recommended workaround)

If standard reports are not sufficient, you can:

• Use SQVI (QuickViewer) or SE16N/SE11 joins
• Join tables like:
• BSAK (Cleared Vendor Items) or BSIK (Open Vendor Items)
• RBKP (Invoice Document Header)
• RSEG (Invoice Document Items)
• AUFK / AUFK-AUTYP (Internal Order Type)
• BKPF / BSEG (Accounting data for clearing/payment info)
• Extract IO, IO type, Invoice/Credit Memo, and Clearing Date

I hope this will help you answer your question.

Best regards,

Jeremy

[Atul_Chavan]

Thank you Jeremy for your reply. I have been using FBL1N, KOB1 & KOK5 to get the extracts and the do a v lookup in excel.