SAP FBL1N — Vendor Line Item Display
A vendor in SAP is a supplier you buy from. Every invoice you receive from them and every payment you make to them creates a line item on their account. FBL1N is the report that lists those line items.
The single most important control on the screen is the three-way choice between Open items, Cleared items and All items. Open means still outstanding. Cleared means matched to something — usually paid. Get this wrong and the report is not wrong exactly, it is just answering a different question than the one you asked.
FBL1N has two siblings that work identically: FBL5N for customers (money owed to you) and FBL3N for G/L accounts. Learn one screen and you have learned all three.
When you would actually use FBL1N
- A supplier chases payment and you need to see what is genuinely still open.
- Checking whether a specific invoice was posted, and whether it has been paid.
- Reconciling a supplier statement against your own records.
- Investigating why the accounts payable balance moved.
What the screen looks like
Vendor selection
Line item selection
| St | Document | Type | Doc. Date | Net due dt | Amount EUR | Clrng doc. |
|---|---|---|---|---|---|---|
| ○ | 1800000123 | KR | 13.06.2026 | 13.07.2026 | 1,190.00- | |
| ○ | 1800000188 | KR | 02.07.2026 | 01.08.2026 | 480.00- | |
| ● | 1800000090 | KR | 11.05.2026 | 10.06.2026 | 2,300.00- | 1400000891 |
The fields, in plain English
LFA1-LIFNRThe supplier number. Leave it blank and fill in a range, or a different selection such as a search term, to report on many vendors at once.
Watch out: A vendor exists centrally but must also be extended to the company code you are reporting on. If the account "does not exist" it often exists in another entity.
Open shows what is still outstanding. Cleared shows what has been settled. All shows both, which is what you want when reconciling a full statement.
Watch out: The default is Open items. Someone asking "why is this invoice missing?" has usually paid it already — switch to All items before concluding it was never posted.
BSID/BSIK selectionRecreates the open-item position AS AT that date. Setting 31.07.2026 shows what was outstanding at the end of July, even if it was paid in August.
Watch out: This is what makes the report agree with a month-end balance. Reporting with today's date and comparing to a July balance sheet will never tie out.
computed from BSEG-ZFBDT + payment termsWhen the invoice actually falls due, derived from the baseline date plus the payment terms. This is the column to sort by when deciding what to pay next.
A saved column arrangement. Layouts starting with / are shared across all users; without the slash they are yours only. Building a good layout once saves rebuilding the report every time.
Step by step
- 1Enter the vendor account and company code.
- 2Choose the status: Open items for what is outstanding, All items for a full reconciliation.
- 3Set the key date. Use a month-end date when tying back to reported figures.
- 4Execute (F8).
- 5Sort by net due date to see what is overdue, or by amount to find a specific value.
- 6Double-click any line to open the document itself in FB03.
- 7Save your column arrangement as a layout so you do not rebuild it next time.
Errors you will hit, and what they mean
No items selected
Why: Usually the status filter, not an absence of data — the items exist but are cleared and you asked for open ones.
Fix: Switch to All items and re-run before concluding anything is missing.
Account 100214 not created in company code 1000
Why: The vendor exists centrally but has never been extended to that company code.
Fix: Check which company codes the vendor is set up in. If it genuinely needs to be extended, that is a master-data request, not something to fix in the report.
Report runs for a very long time or times out
Why: Selecting all vendors with All items across several years reads an enormous volume.
Fix: Narrow by company code, date range and status. Reporting on cleared items across all vendors is rarely what anyone actually needs.
Common questions
What is the difference between FBL1N and FK10N?
FBL1N lists individual LINE ITEMS — every invoice and payment. FK10N shows BALANCES summarised by period. Use FK10N to see that June moved, then FBL1N to see which documents moved it.
Why does my total not match the vendor statement?
Almost always the key date or the status filter. Set the key date to the statement date and choose All items, then compare. Documents posted after the statement date are the usual difference.
What do special G/L items mean here?
The Type selection includes special G/L transactions — down payments and guarantees, held on separate reconciliation accounts. They are excluded from "Normal items", so a down payment can look missing until you tick them.
Transactions that go with FBL1N
Reading about it only gets you so far
Practise SAP transactions in a safe simulated environment and keep what you learn.
Practise SAP transactions hands-on
Interactive modules, games, and an AI tutor — free to start.
Get started free →