Loading...
 

Totals and balance list of debtors (customers)

Totals and balance list of debtors (customers)

Description

This module is used to call up the totals and balance list for customer accounts. The debit and credit values are displayed for the selected posting period (the so-called period values), cumulated from the beginning of the fiscal year belonging to the posting period up to the specified accrual period or optionally up to the end of the corresponding fiscal year.

Totals of debit, credit and balance values are output across all accounts and additionally separated into debit and credit balances.

Functionality

Toolbar
Symbol Description
 CX_AMOUNT_calculation.png When all the presettings have been set as desired, the summary, balance list is created.
 copytoclipboard.png Copy the list to the clipboard.
 CX_PRINTER_hardcopy.png Easy printing of the list.
Fields
Field Description
Posting period The first time the mask is opened, the posting periods of the current fiscal year are displayed. The current posting period is pre-selected. By pressing the "Posting period" button you can select previous financial years.
Issue accounts without period values Accounts that do not show any values for the selected posting period are also displayed. Otherwise, a list of only the accounts that were posted to in the selected posting period is displayed. (default setting)
Control account If a control account is selected here, only those customer accounts are output that are subsumed via this control account. If no reconciliation account is selected, all customer accounts (posted to in the selected fiscal year) are output.

With the right mouse button you can display the period balances of the reconciliation account in the selected fiscal year.

If the option "Output accounts without period values" has been selected and a control account has been chosen, then at the end of the expansion of the list, the system checks whether the balance of the total of all customers assigned to the selected control account matches the balance of the control account itself. If this is not the case, a warning message is issued: The reason for this would be if a customer account were to change to a reconciliation account during the year. (A change of a control account and a possibly necessary transfer posting between control accounts is made in the module"Change control account")

If a control account with balance exchange is selected, all account types assigned to this control account (customers, vendors, expenses, commissions) are displayed, since otherwise a difference in the balances could also occur. Control accounts with balance exchange can be selected simultaneously from all partner functions (customers, vendors, employees, representatives) as a totaling account (for example, in the case of affiliated companies)

If a control account that is also defined as a down payment account is selected, all down payment accounts of customers, vendors, employees or representatives assigned to this control account are also issued, otherwise a difference in balances could also occur.
Accumulated values -
: End of period Cumulation of values from the beginning of the financial year to the end of the selected accounting period.
: End of financial year Accumulation of values over the entire financial year.
List
Column Description
Account Account number
Designation Name of the person holding account
Invalid A stop sign is displayed here if the account/customer is invalid for the selected posting period but was nevertheless posted to.
Target period Output of the target values posted in the selected period.
Have period Output of the credit values posted in the selected period.
Balance period Output of the balance of the debit and credit values posted in the selected period.
Opening balance Issue of the opening balance. Although an opening balance can be posted in different periods, the total balance of all opening values is always output here.
Shall kum. Output of the target values accumulated in the accumulated target values.
Have kum. Output of the cumulated credit values.
Total balance Output of the balance of "opening balance" plus "accumulated debit" minus "accumulated credit".
Totals

Totals of debit, credit and balance values are output across all accounts and additionally separated into debit and credit balances.

Related topics


Technical documentation

Totals and balance list for debtors (customers) Module

Module name

deacbals.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.

Received messages
Message Parameters Function Security

Sent messages
Message Parameters Function Receiver module

Operational business