# Billing Documents Not Posted to Accounting Report

> A custom ALV report that lists billing documents which exist in SD but have no accounting document yet, with the reason code, age and amount. At month-end close, invoices missing from revenue are totalled by company code and error type, and every line drills down to the correction screen.

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/billing-documents-not-posted-to-accounting-report/


## Why is the standard not enough?

VFX3 lists billing documents not passed to accounting per sales organization and lets you release them one by one, but it does not calculate how long they have been waiting, does not total account determination, pricing and foreign trade errors separately and does not give the tax-inclusive total per company code. It also does not check on the accounting side whether an FI document really exists (BKPF). Answering "which revenue is missing from the books and why" at the closing meeting needs a report that combines this information.

### Closest standard alternatives

- VFX3: Lists and releases invoices not passed to accounting; no waiting time, no totals by reason and no check against the FI document.
- VF05: Lists invoices by customer and date; does not filter by posting status.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBRK | Billing header, posting status, amount and company code (driving table) | Read | - | ECC + S/4 |
| VBRP | Billing items and reference sales order | Read | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| BKPF | Check whether an accounting document exists | Read | BKPF-AWTYP = 'VBRK' AND BKPF-AWKEY = VBRK-VBELN AND BKPF-BUKRS = VBRK-BUKRS | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBRK-KUNAG | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBRK-VKORG | Yes |
| S_BUKRS | Company code | Range / multiple | VBRK-BUKRS | No |
| S_FKART | Billing type | Range / multiple | VBRK-FKART | No |
| S_FKDAT | Billing date range | Range / multiple | VBRK-FKDAT | Yes |
| S_KUNAG | Sold-to party | Range / multiple | VBRK-KUNAG | No |
| S_RFBSK | Posting status | Range / multiple | VBRK-RFBSK | No |
| P_CANC | Exclude cancelled invoices | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Billing document | VBRK-VBELN |
| Billing type | VBRK-FKART |
| Billing date | VBRK-FKDAT |
| Company code | VBRK-BUKRS |
| Sold-to | VBRK-KUNAG |
| Customer name | KNA1-NAME1 |
| Reference order | VBRP-AUBEL |
| Net value | VBRK-NETWR |
| Tax | VBRK-MWSBK |
| Currency | VBRK-WAERK |
| Posting status | VBRK-RFBSK |
| Reason group | Calculated: From RFBSK: A blocked, B account determination, F pricing, G foreign trade, H FI/CO inconsistency; RFBSK = C but no BKPF gives "document missing" |
| Waiting (days) | Calculated: Today − VBRK-FKDAT |
| Created by | VBRK-ERNAM |

## How does the report work?

1. VBRK is read with the selection criteria; invoices whose posting status (RFBSK) is not C (accounting document created) or D (not relevant for accounting) are selected. Cancelled invoices (FKSTO = X) and cancellation documents can be excluded.
2. For each invoice an accounting document is searched in BKPF with AWTYP = VBRK and AWKEY = billing number; invoices with RFBSK = C but no document found are also listed as inconsistencies.
3. The RFBSK value is translated into a reason group: A blocked for posting, B account determination error, F pricing error, G foreign trade data missing, H inconsistency with FI/CO; other values are added as text from the domain values.
4. The amount comes from VBRK-NETWR and the tax from VBRK-MWSBK; the waiting time is the number of days between today and the billing date (FKDAT).
5. The reference sales order and the number of items are added from the billing items (VBRP); the customer name is read from KNA1. The ALV gives subtotals per company code and reason group.

## Authorization objects

- V_VBRK_VKO: Billing document authorization by sales organization
- V_VBRK_FKA: Authorization by billing type

## Frequently asked questions

### Why does an invoice stay unposted?

The most common reasons are missing account determination (no revenue account found), a posting block defined on the billing type, a pricing error and missing foreign trade data on export invoices. The report puts every invoice into one of these groups.

### Can the report post the invoices to accounting itself?

The standard version only reads. A button that releases the selected lines in bulk, the way VFX3 does, can be added once the error is fixed; change authorization is then checked separately.

### Does this report work on S/4HANA?

Yes. VBRK-RFBSK and the link to BKPF are the same on S/4HANA; the accounting line items live in ACDOCA, but the document header check can still be done with BKPF.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-billing-not-posted-to-accounting
