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

- Type: Report, Custom development, ALV report
- Module: FI
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/customer-receivables-aging-report/


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

### Closest standard alternatives

- FBL5N: Lists open items; does not total them into age buckets and selects down payments separately.
- S_ALR_87012173: Gives a customer open item list; does not offer an aging with profit center breakdown and adjustable buckets.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| BSID | Customer open items, due-date data, special G/L indicator and amounts (driving table) | Read | - | ECC + S/4 |
| BSAD | Items cleared after a past key date | Read | BSAD-BUKRS = BSID-BUKRS AND BSAD-KUNNR = BSID-KUNNR | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = BSID-KUNNR | ECC + S/4 |
| KNB1 | Accounting clerk, reconciliation account and payment terms | Read | KNB1-KUNNR = BSID-KUNNR AND KNB1-BUKRS = BSID-BUKRS | ECC + S/4 |
| T001 | Company code local currency | Read | T001-BUKRS = BSID-BUKRS | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | BSID-BUKRS | Yes |
| S_KUNNR | Customer | Range / multiple | BSID-KUNNR | No |
| S_AKONT | Reconciliation account | Range / multiple | KNB1-AKONT | No |
| S_PRCTR | Profit center | Range / multiple | BSID-PRCTR | No |
| S_BUSAB | Accounting clerk | Range / multiple | KNB1-BUSAB | No |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes |
| P_BKTS | Bucket limits (days, comma-separated) | Single value | - | No |
| P_SPGL | Include special G/L items (down payments, bills) | Checkbox | - | No |
| P_NOTDUE | Also show items not yet due | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Company code | BSID-BUKRS |
| Customer | BSID-KUNNR |
| Customer name | KNA1-NAME1 |
| Accounting clerk | KNB1-BUSAB |
| Profit center | BSID-PRCTR |
| Document | BSID-BELNR |
| Special G/L indicator | BSID-UMSKZ |
| Posting date | BSID-BUDAT |
| Net due date | Calculated: BSID-ZFBDT + payment-term days (ZBD1T/ZBD2T/ZBD3T) |
| Days overdue | Calculated: Key date − net due date |
| Amount | Calculated: BSID-DMBTR, negative when SHKZG = H |
| Currency | T001-WAERS |
| Age bucket | Calculated: Bucket of the days overdue by the P_BKTS limits; "Down payment" for down payments received |
| Dunning level | BSID-MANST |

## How does the report work?

1. 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.
2. 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.
3. Days overdue = key date − net due date; negative values are items not yet due. Bucket limits are read from the P_BKTS parameter.
4. 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.
5. 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.

## Authorization objects

- F_BKPF_BUK: Accounting document authorization by company code
- F_KNA1_BUK: Customer 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=fi-customer-receivables-aging
