Open item lists
Description
Here you can list the open items for customers, vendors and employees and, if necessary, branch to the processing of the individual open item, account, etc. (In the list context menu via right mouse button).
Functionality
Selection window
This window is used to select open items.
| Menu item | Description |
|---|---|
| Edit | - |
| : Check OP accounts | - |
| : : Check balances OP <-> Personal account | The balance of each person holding account is compared with the balance of their OP account. Different accounts are displayed in the list for checking purposes. |
| : : Display balanced OPs | Cleared but not cleared open items are searched for and displayed in the list. Such open items can arise in the accounts payable area, for example, if a payment run has not been completed in full (missing printing of transfers/checks or missing generation of the DTAUS bank data exchange file). |
| : : : Check changes to control account | With this selection it can be checked for which person holding accounts of the control account selected in the mask postings to another control account were made within the registered business year. The subledger account with the postings to a different reconciliation account are displayed in the list, multiple selection of the postings is possible to be displayed in the journal (right mouse button) |
| Close | Close window |
The menu is used to check open items and subledger accounts and is thus part of the quality assurance within financial accounting.
| Field | Description |
|---|---|
| Account selection | |
| : Accounts | - |
| : : Control account | A pre-selection according to the reconciliation account of the person holding accounts can be made here. If this field remains empty, no preselection takes place. |
| : : sales territory | Preselection of the sales area (only for OP list debtors) |
| : : Accounts from - to | Depending on the type of list, you can select the accounts here with "from - to number". |
| : : Country | Selection of the country (only for OP list debtors) |
| : Demarcation | - |
| : : per | Accrual of open items by date. Today" is offered as standard, i.e. the current balances and postings of the open items are displayed. If a current date is specified, the day is accrued exactly according to the posting date; if a period is specified (e.g. February 2015), the accrual is calculated per period Note: If, for example, "31.3.2015" is entered as the accrual date, the day is accrued exactly according to the posting date, in order to accrue according to the period March 2015, "March 2015" must be entered |
| : : amount | Differentiation of open item accounts based on their balances. This enables you to select, for example, customers with credit balances or vendors with debit balances |
| : Listing | - |
| : : Individual listing | If this checkbox is selected, all open line items of the respective account are displayed, otherwise only the balance of the OP account is displayed. Furthermore, in the case of individual listings, the line items to be listed can be restricted according to amounts. Hereby, debit-side line items from vendors or credit-side line items from customers can be filtered out |
| : Sums | This group is only displayed if single listing = yes has been selected |
| : : Total per account | One subtotal line is displayed per subledger account. |
| : : Coupling OP's | Any coupled open items should remain coupled in the list. If this selection is made, you can also select to output only coupled open items (see next field) |
| : : only remaining stock | Only coupled OPs are listed |
| : : New construction | If this field is selected, any open items already displayed in the list are deleted beforehand. If this field is not selected, you can add further open items to the same open item list one after the other according to various selection criteria. |
| List options | |
| : Output | - |
| : : zero accounts | Click only if all accounts are to be displayed, i.e. also those whose open items have a zero balance. |
| : : Intermediate lines | Blank lines are inserted between different accounts in the list, thus providing a clearer list. |
| : : Total sum | A final total line is displayed at the end of the list. |
| : : Currency conversion | A specific output currency can be specified for all open items. A corresponding currency table must be registered in advance. |
| down payments | - |
| : : yes | The open items that were marked as "down payment" are also listed. |
| : : : : only | Only the open items marked as down payments are output. |
| : : no | No open items that have been marked as "down payment" are listed. |
| Maturity structure | |
| In this window, the desired maturity structure can be specified. By using the right mouse button you can insert further maturity structure nodes, edit the "age" or remove a maturity structure node. The debit/credit values are automatically inserted when the open item list is created. Once this is done, you can select the relevant open items in the list by double-clicking on an entry in the due date structure. | |
:  | Print due date structure list |
:  | Copy a due date structure list to the clipboard |
Finally, by pressing the "List" button, you can start the search for open items.
| button | Description |
|---|---|
| Lists | Call up list window The search for the open items is started according to the specified options |
List window
Used to list the open items. Navigation is possible via the context menu (see below: right mouse button in the list). If you navigate to the open item account, you can, if necessary, subsequently clear the open items there by selecting the cleared items and then clicking on the 'Clear' button.
| Menu item | Description |
|---|---|
| Edit | - |
| : Selection window | The selection window is opened/foregrounded. |
| : Remove selected line | The entries selected in the list are removed from the list (see also the next selection). This option makes sense if you want to remove a few lines before creating a report, a copy to Excel, etc. |
| : Remove NOT selected line | The entries NOT selected in the list are removed from the list (see also the previous selection). This option makes sense if you want to remove a few lines before creating a report, a copy to Excel, etc. |
| : Redetermine maturity structure | This selection is only possible if the option "Single listing = Yes" has been selected. If, for example, you have previously removed some lines from the list or changed the due date of an open item, the due date structure can be redetermined with this selection |
| : Totals rows | - |
| : : : Reset totals rows | If the list contains totals lines, these are sorted "incorrectly" with each sorting. With this selection, the totals rows are sorted correctly again after sorting the list (at each end of a subledger account) |
| : : : Create a grand total | An end total line is added to the list |
| : revaluation of foreign currency operations | - |
| : : All foreign currency operations | All foreign currency OPs (whether or not they are listed with the individual listing "yes") are transferred to the booking module for revaluation |
| : : Only the selected foreign currency OPs | Only the foreign currency OPs selected in the list are transferred to the booking module for revaluation (only possible with individual listing "yes") |
| Close | Close window |
| Menu item | Description |
|---|---|
| Personal account | - |
| : Edit OP account | The OP account for the selected entry is called up. |
| : Edit financial account | The financial account for the selected entry is called up. |
| : Edit account holder | The account holder of the selected entry is called up for editing. |
| : Set selection | Here you can transfer the account number of a selected open item into the "from" or "to" account number field of the selection mask. This is practical if you want to select a subset of accounts from an already called up open item list and display them again. |
| Open position | - |
| : Edit open item | The selected open item can be edited. |
| Call up the journal | The journal for the selected entry is called up. |
| Symbol | Description |
|---|---|
 | Rebuild OP list |
 | Display document history |
| Call Print open item list/copy to clipboard |
Related topics
Technical documentation
Open item lists
Module name
openlist.mod
Classes
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
| Message | Parameters | Function | Security |
|---|---|---|---|
| LIST_OPEN_ITEM | Collection Open item objects or NULL | Call up list window for open items | |
| OPEN_ITEM_CHANGED | Open item object | Open items were changed | |
| SELECT_OPEN_ITEM | Collection Open item objects or NULL, recipient of the response | Call up selection window for open items |
| Message | Parameters | Function | Receiver module |
|---|---|---|---|
| LIST_OPEN_ITEM | Call up list window for open items | Open item list module |
;){kind=link}
;){kind=link}
;){kind=link}