Customer Receivables Aging Report
Short answer: 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. Amounts are spread into not-due, 0–30, 31–60, 61–90 and 90+ day buckets, with profit center, accounting clerk and dunning level on every row.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
FBL5N lists open items but does not total them into age buckets; special G/L items (down payments received, bills of exchange) are selected separately, so the customer's net exposure is not visible in one list. S_ALR_87012173 produces an open item list, but it does not offer an Excel-ready aging with profit center and accounting clerk breakdown and adjustable bucket limits.
Who uses it? Accounts receivable and collections teams, credit control, finance managers and sales managers.
Closest standard alternatives
- FBL5N Customer Line Items. Lists open items; does not total them into age buckets and selects down payments separately.
- S_ALR_87012173 List of Customer Open Items. Gives a customer open item list; does not offer an aging with profit center breakdown and adjustable buckets.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BSIDCustomer Open Items | Customer open items, due-date data, special G/L indicator and amounts (driving table) | — | ECC + S/4 |
| BSADCustomer Cleared Items | Items cleared after a past key date | BSAD-BUKRS = BSID-BUKRS AND BSAD-KUNNR = BSID-KUNNR | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| KNB1Customer Master (Company Code) | Accounting clerk, reconciliation account and payment terms | KNB1-KUNNR = BSID-KUNNR AND KNB1-BUKRS = BSID-BUKRS | ECC + S/4 |
| T001Company Codes | Company code local 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.
- BSAD → I_OperationalAcctgDocItem: In S/4HANA BSAD is not filled as a separate table; it is read through a compatibility view of the same name. 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 | BSID-KUNNR | No | 200118 |
| S_AKONT | Reconciliation account | Range / multiple | KNB1-AKONT | No | 120000 |
| S_PRCTR | Profit center | Range / multiple | BSID-PRCTR | No | PC1100 |
| S_BUSAB | Accounting clerk | Range / multiple | KNB1-BUSAB | No | T1 |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
| P_BKTS | Bucket limits (days, comma-separated) | Single value | — | No | 30,60,90 |
| P_SPGL | Include special G/L items (down payments, bills) | Checkbox | — | No | X |
| P_NOTDUE | Also show items not yet due | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Company code | BSID-BUKRS |
| 2 | Customer | BSID-KUNNR |
| 3 | Customer name | KNA1-NAME1 |
| 4 | Accounting clerk | KNB1-BUSAB |
| 5 | Profit center | BSID-PRCTR |
| 6 | Document | BSID-BELNR |
| 7 | Special G/L indicator | BSID-UMSKZ |
| 8 | Posting date | BSID-BUDAT |
| 9 | Net due date | Calculated BSID-ZFBDT + payment-term days (ZBD1T/ZBD2T/ZBD3T) |
| 10 | Days overdue | Calculated Key date − net due date |
| 11 | Amount | Calculated BSID-DMBTR, negative when SHKZG = H |
| 12 | Currency | T001-WAERS |
| 13 | Age bucket | Calculated Bucket of the days overdue by the P_BKTS limits; "Down payment" for down payments received |
| 14 | Dunning level | BSID-MANST |
Sample output
| Company code | Customer | Customer name | Accounting clerk | Profit center | Document | Special G/L indicator | Posting date | Net due date | Days overdue | Amount | Currency | Age bucket | Dunning level |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 200118 | Bereket Tarım Ürünleri | T1 | PC1100 | 1800012044 | 08/20/2026 | 09/19/2026 | 59 | 184,500 | TRY | 31–60 | 2 | |
| 1000 | 200118 | Bereket Tarım Ürünleri | T1 | PC1100 | 1400003117 | A | 10/05/2026 | 10/05/2026 | 43 | -50,000 | TRY | Down payment | 0 |
| 1000 | 200245 | Kuzey Yapı Market | T2 | PC1200 | 1800012390 | 10/28/2026 | 11/27/2026 | -10 | 96,320 | TRY | Not due | 0 | |
| 1000 | 200377 | Selin Kozmetik | T2 | PC1300 | 1800011208 | 06/02/2026 | 07/02/2026 | 138 | 41,780 | TRY | 90+ | 3 |
How does the report work?
- Open items posted up to the key date are read from BSID for the selection. With a past key date, items cleared after that date (AUGDT > key date) are added from BSAD.
- The net due date is derived from the baseline date (ZFBDT) and the payment-term days (ZBD1T, ZBD2T, ZBD3T) using the standard due-date logic.
- Days overdue = key date − net due date; negative values are items not yet due. Bucket limits are read from the P_BKTS parameter.
- When P_SPGL is set, special G/L items (UMSKZ filled) are included; down payments received (UMSKS = A) are shown on their own row in a “Down payment” bucket and deducted from the customer total.
- The amount is signed by the debit/credit indicator (SHKZG) and shown in local currency (T001-WAERS). The customer name comes from KNA1, the accounting clerk and reconciliation account from KNB1, and the dunning level from BSID-MANST.
Performance notes
Read BSID by company code and customer range; read BSAD only for a past key date and with the AUGDT condition. In S/4HANA, for high volumes, push the aggregation down to the database on I_OperationalAcctgDocItem.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants Variants with subtotals by customer or profit center can be saved.
- Double-click drill-down to the document Double-clicking the document opens FB03; double-clicking the customer opens FBL5N.
- Export to Excel
- Runs as a background job Can run automatically with the month-end key date.
- Send the result by email The result can be sent to each accounting clerk with their own customers.
Authorization objects
- F_BKPF_BUKAccounting document authorization by company code
- F_KNA1_BUKCustomer master authorization by company code
Frequently asked questions
How are down payments received shown in the aging?
Down payments (special G/L indicator such as A) are shown on their own row in a "Down payment" bucket with a negative amount. The customer subtotal deducts them from invoices to give the net exposure; down payments can also be excluded.
Why is the profit center empty on some items?
The profit center is carried to the customer item when document splitting is active in the new G/L. Without document splitting the field can stay empty; the report can then be extended to read the profit center from the FAGLFLEXA line item.
Does it work on S/4HANA?
Yes. BSID and BSAD can still be read as compatibility views on S/4HANA. For new developments, the I_OperationalAcctgDocItem CDS view, which already provides the net due date, is preferred.
Packages that include this solution
Customer Receivables Collection Pack
A pack that brings together four solutions a collection team needs, with one customer and company code selection: receivables aging, the customer's …
Order-to-Cash Control Pack
A five-report pack that shows every point where a sales order gets stuck, with one sales organization selection: missing data, credit blocks, picked …
Related reports
Customer Payment Behavior and Days-to-Pay Report
A custom ALV report that uses customer invoices cleared in the selected period to calculate each customer's average days to pay, amount-weighted days …
Customer Account Statement and Balance Confirmation Email Program
A custom program that prepares a customer account statement as PDF, with opening balance, period movements, open items and closing balance, and sends …
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. 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.