Customer–Vendor Netting Open Items Report
Short answer: A custom ALV report that puts open receivables and payables side by side for business partners that exist both as a customer and as a vendor, and calculates the amount that can be netted. It also shows whether the clearing-with-vendor/customer indicator is set in the master data.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 7
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
FBL5N and FBL1N show receivables and payables on separate screens. F.13 clears automatically, but it does not first report how much can be netted per partner, and it never sees the items when the master data link or the clearing indicator is missing. The netting decision and the confirmation letter to the partner need the net position of both sides in one list.
Who uses it? Accounts receivable and payable teams, treasury and accountants who reconcile partner balances.
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 |
|---|---|---|---|
| KNA1Customer Master (General Section) | Customer name and linked vendor number (driving table) | — | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name and linked customer number | LFA1-LIFNR = KNA1-LIFNR OR LFA1-KUNNR = KNA1-KUNNR | ECC + S/4 |
| BSIDCustomer Open Items | Customer open items | BSID-KUNNR = KNA1-KUNNR AND BSID-BUKRS IN S_BUKRS | ECC + S/4 |
| BSIKVendor Open Items | Vendor open items | BSIK-LIFNR = LFA1-LIFNR AND BSIK-BUKRS = BSID-BUKRS | ECC + S/4 |
| KNB1Customer Master (Company Code) | Clearing-with-vendor indicator on the customer | KNB1-KUNNR = KNA1-KUNNR AND KNB1-BUKRS = BSID-BUKRS | ECC + S/4 |
| LFB1Vendor Master (Company Code) | Clearing-with-customer indicator on the vendor | LFB1-LIFNR = LFA1-LIFNR AND LFB1-BUKRS = BSIK-BUKRS | ECC + S/4 |
| T001Company Codes | Company code currency | T001-BUKRS = BSID-BUKRS | ECC + S/4 |
S/4HANA notes
- BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
- BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes | 1000 |
| S_KUNNR | Customer | Range / multiple | KNA1-KUNNR | No | 200118 |
| S_LIFNR | Vendor | Range / multiple | LFA1-LIFNR | No | 100245 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 31.10.2026 |
| P_SPGL | Include special G/L items (down payments, guarantees) | Checkbox | — | No | — |
| P_MINNET | Minimum nettable amount | Single value | — | No | 1000 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | BSID-BUKRS |
| 2 | Customer | KNA1-KUNNR |
| 3 | Customer name | KNA1-NAME1 |
| 4 | Vendor | LFA1-LIFNR |
| 5 | Vendor name | LFA1-NAME1 |
| 6 | Open receivables | Calculated Sum of BSID-DMBTR, positive when SHKZG = S |
| 7 | Open payables | Calculated Sum of BSIK-DMBTR, positive when SHKZG = H |
| 8 | Net balance | Calculated Open receivables − open payables |
| 9 | Nettable amount | Calculated The smaller of open receivables and open payables |
| 10 | Oldest receivable date | Calculated Smallest BSID-BUDAT among the pair's open receivables |
| 11 | Clearing set on customer | KNB1-XVERR |
| 12 | Clearing set on vendor | LFB1-XVERR |
| 13 | Currency | T001-WAERS |
| 14 | Suggestion | Calculated "Net with F.13" when both indicators are set, otherwise "fix master data" |
Sample output
| Company code | Customer | Customer name | Vendor | Vendor name | Open receivables | Open payables | Net balance | Nettable amount | Oldest receivable date | Clearing set on customer | Clearing set on vendor | Currency | Suggestion |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 200118 | Kuzey Yapı Market | 100733 | Kuzey Yapı Market | 412,500 | 186,300 | 226,200 | 186,300 | 07/14/2026 | X | X | TRY | Net with F.13 |
| 1000 | 200245 | Anadolu Gıda Dağıtım | 100812 | Anadolu Gıda Dağıtım | 95,400 | 132,000 | -36,600 | 95,400 | 09/02/2026 | X | TRY | Fix master data | |
| 1000 | 200390 | Ege Kimya | 100512 | Ege Kimya | 18,200 | 25,560 | -7,360 | 18,200 | 10/05/2026 | TRY | Fix master data |
How does the report work?
- Customer–vendor pairs are found: customers with KNA1-LIFNR filled and vendors with LFA1-KUNNR filled are merged; one-way links are taken as well.
- For every pair, open items posted up to the key date are read per company code from BSID (customer) and BSIK (vendor); unless P_SPGL is set, special G/L items (UMSKZ filled) are skipped.
- Amounts are signed by the debit/credit indicator (SHKZG) and totalled in the company code currency (T001-WAERS).
- Nettable amount = the smaller absolute value of the receivable and payable totals; net balance = receivable − payable.
- KNB1-XVERR and LFB1-XVERR are read; when the indicator is off, the suggestion “fix master data” is added. Pairs below P_MINNET are not listed.
Performance notes
Build the pair list (KNA1/LFA1) first, then read BSID and BSIK only for those customers and vendors with the company code. On S/4HANA both sides can be aggregated in one query on I_OperationalAcctgDocItem.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the customer opens FBL5N; double-clicking the vendor opens FBL1N.
- Export to Excel
- Runs as a background job Can be scheduled with the month-end key date.
Authorization objects
- F_KNA1_BUKCustomer master authorization by company code
- F_LFA1_BUKVendor master authorization by company code
- F_BKPF_BUKAccounting document display authorization by company code
Frequently asked questions
What if the customer and vendor are not linked in the master data?
The link comes from KNA1-LIFNR or LFA1-KUNNR. Optionally, an extra selection that finds unlinked pairs by matching the tax number can be added.
How are items in different currencies totalled?
Totals use the company code currency amount (DMBTR). A breakdown by document currency can be added as a second view.
Does the report post the netting?
No, the report only reads. Netting is done with F.13 or manual clearing; the report shows which pairs are ready.
Related reports
Customer Receivables Aging Report
A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …
Intercompany Open Items Reconciliation Report
A custom ALV report that matches receivable and payable open items between group companies by trading partner and reference number. Before the …
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.