Open item list for personal accounts
- Peter Schöll
Calling up the form
The form is started by clicking on Receivables → Open items debtors or Payables → Open items creditors under Finance.
Worklists in the open items list
The open item list opens with a worklist header, whereby Scopevisio offers three worklists as standard. More on working with and without worklists.
Two of these are classic views (all items, only the open items), the third is a list without grouping with which the lines can be sorted by (absolute) amounts, among other things. We recommend that you do not change the prepared lists, but save your adjustments under a new name.
Most of the filters in the worklist are self-explanatory; we explain the special features here.
You can use the Status and "Open items" field to hide all items with a remaining amount of zero. The "All items" setting is therefore not an open item list in the literal sense.
When you click on "Show individually", the form with its filters is retained; functionally, the "Person account from ... to" fields are filled with the person account and emptied again when you click again (All...).
With the new procedure, the grouping is retained, which means that some searches (e.g. sorted by absolute amount) are not possible. Please use a non-grouped open item list and then filter on the desired person account.
Alphanumeric account numbers (K72000) can also be entered in the Personal account from ... to fields, but only the digits are taken into account, as alphanumeric values do not form a unique range.
Grouping data
To group, right-click (RMB) on the header of the desired column and use "Group by" in the context menu. If necessary, the column with the criterion is removed, the criterion is listed in the grouping header and highlighted in bold.
It is now possible to group the data according to the following five columns.
Account number (personal account number)
Account name (personal account name)
Contact name (contact name in OP <> personal account name, e.g. for CpD accounts)
Collective account (Ford./Verb. from L+L, for the separation of e.g. intercompany OP)
Invoice area (the invoice area feature must be activated, an invoice area is in practice = 1 business premises)
A grouped table is always opened with "extended grouping".
Depending on the grouping, different information is displayed in the header of the grouping. The following data is listed in the header:
Personal account number
Personal account name
Total balance (does not take filters into account)
Current account (the corresponding debtor/creditor account)
If you view the open items without grouping, you can sort by almost any column (e.g. absolute total amount). The extended table filter is still available.
Display of the correspondence account with balance
A "Current account debtor" or "Current account creditor" can be assigned in the personal account master. Its number and account balance are displayed in the header of the grouping; you can branch to this account (account sheet) by clicking on the account number.
Clearing functions
There are several buttons below the table. You can find more information on this in the general explanations on clearing.
Further functions
You can use the three dots at the top right to start the clearing assistant and the Open items form on a key date; the old open items list can be called up here until the beginning of 2024 at the latest.
The number of items on a page can be increased to up to 500 lines.