Settlements and interest — list, data sources, rights
The queries of the settlement list, the data sources of the expanded row, the content scope and the auxiliary endpoints.
The finance/settlement module shows the financial status of each invoice (receivable/payable, due date, settlement history, days of delay, interest), and the interest, recovery fee, statement and refund actions start here. Models: finance/settlement, finance/interest (admin adapter) + the dlbtinterest library, finance/transaction, finance/invoice, masterdata/baserate.
Data sources (read)
Table names carry the installation's own prefix in the database.
| Table | Role in the list |
|---|---|
invoice | base document, due date, balance, interest_rule_id |
transaction, transaction_item, transaction_settlement | bank and cash settlements |
compensation, compensation_item | offsets |
settlement_waiver | waivers |
interest_rule, interest_period, base_rate | interest rule, daily interest periods, base rate rows |
Behaviour
- Filters: company group, company, invoice type, only open / open with linked / overdue / on time, date type and range, search, partner, cut-off date, currency, include drafts.
- The expanded row shows settlements, daily interest periods and base rate rows.
- Totals up to 3,000 rows.
- Links to
masterdata/baserate,finance/invoiceandfinance/transactiononly withcanSee.
Permissions
- Layer 2:
list(seed “Settlement — list”,UNMAPPED); without it the index redirects to the dashboard. Thedebugkey opens the filter's SQL toggle and the details of the interest generation error list. - Layer 3: content scope in
filterScope(), based ongetCompanyGroupFilter.
Auxiliary endpoints
finance/settlement.statement— partner account HTML (printable detail); right:list+ coreaccess, scope on the client list. No admin template calls it.companysearch— partner search (at most 15 hits);list+ scope.filtercompanies— the shared company picker.