Billing Milestones Reached but Not Invoiced Report
Short answer: A custom ALV report that lists completed project milestones, those with an actual date, whose billing plan date in the sales order is still not invoiced, with customer, amount, billing block and days since completion. It shows project and sales teams together where delayed collections come from.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The VF04 billing due list shows SD billing plan dates, but it does not show items whose milestone is completed while the billing block is still set or the billing date is still in the future, together with the WBS element and project responsible. CN53N lists milestones without billing status or amount. As a result, completed work can stay uninvoiced for weeks.
Who uses it? Project managers, sales operations and billing teams, finance teams that monitor cash flow.
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 |
|---|---|---|---|
| MLSTMilestone | Milestone: number, WBS element and actual date (driving table) | — | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element and responsible person | PRPS-PSPNR = MLST-PSPNR | ECC + S/4 |
| FPLTBilling Plan Dates | Billing plan date: value, percentage, billing date, status and block | FPLT-MLSTN = MLST-MLSTN | ECC + S/4 |
| FPLABilling Plan | Billing plan header and sales document | FPLA-FPLNR = FPLT-FPLNR | ECC + S/4 |
| VBAKSales Document Header | Sales order: customer and sales organization | VBAK-VBELN = FPLA-VBELN | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | No | 1000 |
| S_KUNNR | Customer | Range / multiple | VBAK-KUNNR | No | 200310 |
| S_VBELN | Sales document | Range / multiple | VBAK-VBELN | No | 0000012045 |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No | P-26-0012-* |
| S_ACTDT | Milestone actual date | Range / multiple | MLST-LST_ACTDT | No | 01.01.2026 – 17.11.2026 |
| P_BLOCK | Billing block only | Checkbox | — | No | — |
| P_KEYDT | Key date | Single value | SY-DATUM | Yes | 17.11.2026 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | WBS element | PRPS-POSID |
| 2 | Milestone | MLST-MLSTN |
| 3 | Actual date | MLST-LST_ACTDT |
| 4 | Sales document | VBAK-VBELN |
| 5 | Customer | VBAK-KUNNR |
| 6 | Customer name | KNA1-NAME1 |
| 7 | Billing plan item | FPLT-FPLTR |
| 8 | Billing date | FPLT-AFDAT |
| 9 | Percentage | FPLT-FPROZ |
| 10 | Value to bill | FPLT-FAKWR |
| 11 | Currency | FPLT-WAERS |
| 12 | Billing block | FPLT-FAKSP |
| 13 | Billing status | FPLT-FKSAF |
| 14 | Days since completion | Calculated Key date − MLST-LST_ACTDT |
| 15 | Status | Calculated Block set / billing date not reached / due, not invoiced |
Sample output
| WBS element | Milestone | Actual date | Sales document | Customer | Customer name | Billing plan item | Billing date | Percentage | Value to bill | Currency | Billing block | Billing status | Days since completion | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P-26-0012-01 | 00000412 | 06/20/2026 | 0000012045 | 200310 | Kartal Enerji | 000002 | 06/20/2026 | 20 | 2,400,000 | TRY | Z1 | A | 150 | Block set |
| P-26-0012-02 | 00000415 | 10/28/2026 | 0000012045 | 200310 | Kartal Enerji | 000003 | 10/31/2026 | 40 | 4,800,000 | TRY | A | 20 | Due, not invoiced | |
| P-26-0015-01 | 00000431 | 09/26/2026 | 0000012190 | 200455 | Boğaziçi Altyapı | 000004 | 12/01/2026 | 30 | 1,950,000 | TRY | A | 52 | Billing date not reached |
How does the report work?
- Milestones with an actual date (LST_ACTDT) in the selected range and before the key date, not deleted (LOEKZ), are read from MLST; the WBS element is added from PRPS.
- Billing plan dates are found in FPLT by milestone number (FPLT-MLSTN = MLST-MLSTN); dates whose billing status (FKSAF) is fully processed are skipped.
- The sales document comes from FPLA, the customer and sales organization from VBAK and the customer name from KNA1.
- The billing value FPLT-FAKWR, percentage FPLT-FPROZ, billing date FPLT-AFDAT and block FPLT-FAKSP are shown. Days since = key date − LST_ACTDT.
- Status: “block set” (FAKSP filled), “billing date not reached” (AFDAT > key date) or “due, not invoiced”.
Performance notes
MLST and FPLT are small tables, so the report runs fast online. The selection order is set to read VBAK/FPLA first when a sales organization is given, and MLST first otherwise. A background job with email is recommended for the weekly collections meeting.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The sales document opens VA03 (billing plan), the WBS element opens CJ20N.
- Export to Excel
- Runs as a background job
- Send the result by email Can be sent to project and sales owners for the weekly collections meeting.
Authorization objects
- V_VBAK_VKOSales document display authorization by sales organization
- V_VBAK_AATDisplay authorization by sales document type
- C_PRPS_VNRWBS element authorization by responsible person
Frequently asked questions
Does the report create the invoice or remove the block?
No, it only reads. Billing is done with VF04 or VF01. If automatic block removal is wanted, it is assessed as a separate program.
Is resource-related billing covered as well?
No. The report covers billing plan dates linked to milestones. Resource-related billing with DP91 is tracked with a different logic.
Does this report work on S/4HANA?
Yes. MLST, FPLA and FPLT are used in S/4HANA as well; VBAK and KNA1 are read with the same fields.
Packages that include this solution
Project Budget and Schedule Controlling Pack
A pack that combines five reports for the project review meeting with one project definition and WBS selection: budget vs actual vs commitment, …
Related reports
Project WBS Schedule Slippage Report (Basic, Forecast and Actual Dates)
A custom ALV report that compares the basic start and finish dates of each WBS element with the forecast and actual dates, calculates the slip in days …
Sales Order – Delivery – Invoice Status Report
A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …
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.