Report type |
to create the report from the selected data you may select two reports, which are preset. They are displayed by double-clicking the report type name or by clicking the report icon:
|
Report date |
by default the current date |
Include prepayments |
the field should be selected, if we want to consider all prepayments, received or paid to the report date |
Revenue Account |
you enter the account or more than one account by using multi select key , to which the inflows are posted. If want also the inflow report, the field "Report" should be selected. |
Expense Account |
you enter the account or more than one account by using multi select key , to which the outflows are posted. If want also the outflow report, the field "Report" should be selected. |
Supplier Type |
the overview may be restricted by individual supplier type |
Customer Type |
the overview may be restricted by individual customer type |
Subject |
the overview may be restricted by individual subject |
Department |
the overview may be restricted by individual department, to which the outstanding items are related |
Cost Center |
he overview may be restricted by individual cost driver, to which the outstanding items are related |
Due from |
the report may be restricted by the period start date, to which the due date of documents (from journal entry items) that we want to include in the report |
Due to |
the report may be restricted by the period end date, to which the due date of documents (from journal entry items) that we want to include in the report |
Document from |
the report may be restricted by the period start date, to which belong documents (from journal entry items) that we want to include in the report |
Document to |
the report may be restricted by the period end date, to which belong documents (from journal entry items) that we want to include in the report |
Posting per. from |
the report may be restricted by the period start date, to which belongs the posting date (from journal entry header) of documents that we want to include in the report. |
Posting per. to |
the report may be restricted by the period end date, to which belongs the posting date (from journal entry header) of documents that we want to include in the report. |
Due date |
thsi option has an effect on the way partial payments of claims and liabilities are displayed. It does not affect the balance of the outstanding items (it is always the same), but it does have an effect on the way document values and its subsequent payment are sorted in the individual date columns. We select:
- Payments - the value of the partial payment of the document is made out in that date column, to which the payment belongs, for partially closed items
- From documents- the value of the partial payment of the document is made out in that date column, to which the document belongs which is closed by the payment, for partially closed items
For example see Debt structure - document and payment due.
|
Status |
we may select on of the options of how the debt structure is represented:
- Overdue – in this report the summary of due items is made in the "Overdue" column, items which are not due are displayed by dates till the due date.
- Non-due - the summary for this items, which are not yet due, is made in the report's "Non-due" column, due items are displayed by dates when payment was due.
Foe example see Debt structure detailed in Debt structure summary.
|
Overdue thresholds |
five items are available where we can enter the number of days, forming margins, in which outstanding items are made due. Predefined margins are 1, 7, 15, 30 and 60 days, which can optionally be changed, of course. Changes are stored by the individual user and also affect the presentation of financial data (Supplier, Customer) |
Document |
the report may be restricted by individual internal document ID. By using wildcard characters the report may also be restricted to a set of documents. |
Linked document |
the report may be restricted by individua linked document ID. By using wildcard characters the report may also be restricted to a set of documents. |