Report Name: Open Items Receivables By Posting Date
Report Number: REP-5020-INT-S
Report Category: Pro
Report Type: Interactive
Why this report is useful:
This report provides a consolidated view of receivables transactions filtered by posting date, helping users track open and closed items for accurate receivables management. With filters for Year/Month, Customer, Due Sign/Due Band, and Open/Closed Status, teams can quickly isolate overdue payments, monitor aging, and reconcile accounts.
Customer benefits:
- Clear aging analysis by due date status (e.g., due, overdue, or custom aging buckets).
- Flexible period filtering to focus on specific posting months/years.
- Open vs. Closed item tracking to distinguish between active and resolved receivables.
- Comprehensive transaction details including debits, credits, and totals for reconciliation.
- Supports cash flow forecasting and prioritization of collections.
Who might be interested in this report:
- Accounts Receivable Teams – Monitor and reconcile customer payments.
- Finance Managers – Assess liquidity and outstanding receivables exposure.
- Auditors – Verify transaction accuracy and aging compliance.
What data does it contain?
The report displays all receivables transactions in a single table with these columns:
- Posting Date
- Customer
- Document Number
- Document Type
- Description
- Status (Open/Closed)
- Due Date
- Debit Amount
- Credit Amount
- Total Amount
All values are in PLN. No hierarchical totals (flat table view).
Available filters:
- Year/Month – Filter by posting period.
- Customer – Isolate specific customers.
- Due Sign / Due Band – Categorize by due status (e.g., "Overdue 30+ days").
-
Open/Closed Item – Toggle to show:
- Open: Unpaid or partially paid items.
- Closed: Fully settled items (e.g., paid invoices).
Available views:
- Standard Table View (all columns visible).