FI Report Custom development ALV report

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

  • F.13 Automatic Clearing without Currency. Clears automatically; does not report the nettable amount beforehand.
  • FBL5N Customer Line Items. Lists customer items; does not show the vendor side in the same list.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
KNA1Customer Master (General Section)Customer name and linked vendor number (driving table)—ECC + S/4
LFA1Vendor Master (General Section)Vendor name and linked customer numberLFA1-LIFNR = KNA1-LIFNR OR LFA1-KUNNR = KNA1-KUNNRECC + S/4
BSIDCustomer Open ItemsCustomer open itemsBSID-KUNNR = KNA1-KUNNR AND BSID-BUKRS IN S_BUKRSECC + S/4
BSIKVendor Open ItemsVendor open itemsBSIK-LIFNR = LFA1-LIFNR AND BSIK-BUKRS = BSID-BUKRSECC + S/4
KNB1Customer Master (Company Code)Clearing-with-vendor indicator on the customerKNB1-KUNNR = KNA1-KUNNR AND KNB1-BUKRS = BSID-BUKRSECC + S/4
LFB1Vendor Master (Company Code)Clearing-with-customer indicator on the vendorLFB1-LIFNR = LFA1-LIFNR AND LFB1-BUKRS = BSIK-BUKRSECC + S/4
T001Company CodesCompany code currencyT001-BUKRS = BSID-BUKRSECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_BUKRSCompany codeRange / multipleBSID-BUKRSYes1000
S_KUNNRCustomerRange / multipleKNA1-KUNNRNo200118
S_LIFNRVendorRange / multipleLFA1-LIFNRNo100245
P_KEYDTKey dateSingle valueSY-DATUMYes31.10.2026
P_SPGLInclude special G/L items (down payments, guarantees)Checkbox—No—
P_MINNETMinimum nettable amountSingle value—No1000

Output columns

#ColumnSource
1Company codeBSID-BUKRS
2CustomerKNA1-KUNNR
3Customer nameKNA1-NAME1
4VendorLFA1-LIFNR
5Vendor nameLFA1-NAME1
6Open receivablesCalculated Sum of BSID-DMBTR, positive when SHKZG = S
7Open payablesCalculated Sum of BSIK-DMBTR, positive when SHKZG = H
8Net balanceCalculated Open receivables − open payables
9Nettable amountCalculated The smaller of open receivables and open payables
10Oldest receivable dateCalculated Smallest BSID-BUDAT among the pair's open receivables
11Clearing set on customerKNB1-XVERR
12Clearing set on vendorLFB1-XVERR
13CurrencyT001-WAERS
14SuggestionCalculated "Net with F.13" when both indicators are set, otherwise "fix master data"

Sample output

Company codeCustomerCustomer nameVendorVendor nameOpen receivablesOpen payablesNet balanceNettable amountOldest receivable dateClearing set on customerClearing set on vendorCurrencySuggestion
1000200118Kuzey Yapı Market100733Kuzey Yapı Market412,500186,300226,200186,30007/14/2026XXTRYNet with F.13
1000200245Anadolu Gıda Dağıtım100812Anadolu Gıda Dağıtım95,400132,000-36,60095,40009/02/2026XTRYFix master data
1000200390Ege Kimya100512Ege Kimya18,20025,560-7,36018,20010/05/2026TRYFix master data
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. Amounts are signed by the debit/credit indicator (SHKZG) and totalled in the company code currency (T001-WAERS).
  4. Nettable amount = the smaller absolute value of the receivable and payable totals; net balance = receivable − payable.
  5. 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

FI Report Custom ALV report

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. …

BSID · BSAD · KNA1 · KNB1

FI Report Custom ALV report

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 …

BSID · BSIK · KNA1 · LFA1

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.

Related report: Customer–Vendor Netting Open Items Report