Description
This report generates a list of open items for customers in the role ofmaster tenants with customer accounts or subsidizers in the selectedobjects or lease-outs, or in the role of contractual partners withcustomer accounts in general contracts.
The list contains customer items that have been posted up to the keydate entered (posting date <= key date) and that are still open on thekey date.

Selections:
You can select according to company code, posting date, key date,special G/L indicator, and account balance.
You can also choose:

• Business entity, rental unit, lease-out, sets for business entities,
buildings properties, rental units and lease-outs for the selection oflease-outs

• General contracts or sets of general contracts for the selection of
general contracts.
The "Selection contracts" parameter determines whether a search is runfor customers only for lease-outs, only for general contracts, or forboth lease-outs and general contracts.
Please note that the selection according to objects is only active forlease-outs. If you want to select general contracts according toobjects you first have to create a set of general contracts; there youcan also take the object reference into account.

Note:
If the contractual parties have contracts in other (not selected) RealEstate objects, the items found for these objects are also selected andtotalled by contract number and business entity, unless you restrictthe items selection using the parameters
only selected contracts
items without contract numbers
You can also specify using the parameters
that the items should be displayed by collective lease-out or by maincontract (and not by individual contract)
whether normal sales (sales without special G/L indicator, for instancebasic rent) should be displayed
whether contracts with a deletion indicator should be considered
whether line items and subtotals are to be printed
whether only totals sheets for the business entities and company codesare to be printed
You can define an additional heading that will appear in the list.
On the second page of the selection screen, you can restrict the itemsto be selected using the selection conditions:


• business area


• document type


• posting key document date


• currency


• dunning level


• payment method

The "Display alternative payer" parameter outputs the data of thealternative payer, if applicable.
The "Account balance" always refers to the selected activities; thatmeans, only those documents are considered in the balance that werealready posted up to the key date (posting date) and whose special G/Lindicator lies within the selection. The balance is always assessed foreach customer account.
When entering total balances, you have to take account of the way theselection conditions are handled.
Example:
The entry
Account balance 100.00 1000.00
means that all customers are selected where the balance is smaller thanor equal to 1000.00 (in the local currency of the company code).
If you want to select all customers where the balance is greater than1000.00, you enter
Account balance 1000.00
select the Selection options function and enter in the popupthat appears the Greater than selection.
If you want to select only customers with a credit balance, you do notenter any account balance, but position the cursor on the selectionoption "Account balance" and choose the Selection optionsfunction and finally Less than in the dialog box.
Consequently, all the customers that appear in the list have a balanceless than 0 (credit balance).
Normal sales (sales without special C/L indicator) are always selectedwhen the "Select normal sales" parameter is set.
If you want to select normal sales only, you enter the following forthe "Sales indicator" selection condition:
Sales indicator A Z
You have to specify "Excl" via the function "Selection options".

Output
The following is output for each account with selected postings:


• Account name


• All items of the chosen type (as long as the line item output was not
suppressed by means of the parameter 'line items required'), sorted bycontract number
The following is displayed for the items level:

Line 1:


• Contract type, contract number


• Posting date


• Document type


• Document number


• Document date


• Business area


• Number of line item


• Posting key


• Dunning level of line item


• Payment method of line item


• Amount eligible for cash discount in local currency


• Baseline date for payment


• Due date for net payment


• Clearing date, if the item was cleared after the key date


• Sales indicator (special G/L indicator)


• Document currency


• Document currency


• Debit/credit amount in document currency

Line 2:


• Due date for net payment


• Clearing date, if the item was cleared after the key date


• Sales indicator (special G/L indicator)


• Document currency


• Debit/credit amount in document currency

Line 2:


• Business entity, if this was determined


• Reference document number


• Text of document item

Ouput per contract number of customer:


• Debit total, credit total, balance per sales indicator


• Total debit balance, total credit balance, total balance

The following appears in front of the contract:
'3/' for lease-outs
'C/' for collective lease-outs
'M/' for main contracts
'8/' for management contracts

Output per customer:


• Debit total, credit total, balance per sales indicator


• Total debit balance, total credit balance, total balance

Output per company code:
For every company code, an overview of the business entities is ouput.This overview contains for each business entity:


• Debit total, credit total, balance per sales indicator


• Total debit balance, total credit balance, total balance


• These details as well for all items without Real Estate account
assignment
After the totals are listed for the business entities, thecorresponding totals for the company code are displayed.
If the "Only totals BE/company code" switch is set, only the totals foreach business entity and the totals for each company code aredisplayed. The output of line items and subtotals is suppressed in thiscase.
Note that the totals for the business entities and company codes arederived from the selected items. For a complete overview of aparticular business entity, you should not make any other selectionsapart from the business entity.
For documentation purposes, the last sheet of the list is an overviewof the selections. The selection options are documented for you in thenormal way:

• from-value and to-value


• I for inclusive (included in the selection), E for exclusive (excluded
from the selection)

• as well as the abbreviations for the interval selection or single value
selection:
EQ Single value
NE Not equal to
GE Greater than or equal to
LT Less than
LE Less than or equal to
GE Greater than
BT Between