Loading...
 

Summary and balance list for representatives (commission accounts)

Totals and balance list for representatives (commission accounts)

Description

This module is used to call up the summary, balance list (for the commission account) of representatives. 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.
Accounts without period values
issued
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 the substitute accounts that are subsumed via this control account are output. If no control account is selected, all the substitute 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 selected, then at the end of the expansion of the list, a check is made to ensure that the balance of the total of all the substitute accounts 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 a change of a representative account to the control account during the year. (A change of a control account and any necessary transfer between control accounts is carried out in the"Change control account" module)

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)
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 substitute account is invalid for the selected posting period and 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, balance list representatives (commission accounts) module

Module name

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