Description
This report program generates a list of the open items of customers whoappear as a master tenant with customer account or a subsidizer in theselected items.
The list contains customer items that have been posted on the key date(posting date <= key date) and are still open on the key date.

Selection:
You can make selections by company code, posting date, key date andspecial G/L indicator, and customer account balance.
You can also select by:
business entity, rental unit, lease-out.
The report program searches for all customers that act as master tenantwith customer account or subsidizer in the selected Real Estateobjects.

Note:
If the contract partners also have contracts in other (not selected)Real Estate objects, the items found for these objects are alsoselected and totaled per contract number and business entity unless youhave limited the items using the following parameters:
Only selected contracts
Items without contract number
In the parameters you can also define whether or not to
display the items per collective lease-out (not per individualcontract)
also display the normal sales (sales without special G/L indicator,such as basic rent)
also consider contracts with deletion flags
print the line items and subtotals
print only the totals for the business entities and the company codes
You can also enter an additional heading to appear in the list.
In the second selection screen you can limit the selected items usingthe following selection criteria:

• Business area


• Document type


• Reference date posting key


• Currency


• Dunning level


• Payment method

Use the "Display alternative payer" indicator to display any existingalternative payers.
The account balance always refers to the selected transactions; thismeans that the program considers only those documents that were postedon the key date (posting date) and whose special G/L indicator meetsthe selection criteria for generating the balance. The balance isalways considered per customer account.
The following examples illustrate the possible entries in the accountbalance field:
Example:
Account balance 100.00 1000.00
This entry means that customers with a balance between 100.00 and1000.00 (in the local currency of the company code) are selected.
Account balance 1000.00
This entry means that customers with a balance of 1000.00 or less (inthe local currency of the company code) are selected.
If you want to select all customers with a balance of 1000.00 orgreater, make the following entry, choose the "Selection options" andselect the Greater than indicator in the dialog box thatappears:
Account balance 1000.00
To select only customers with a credit balance, do not enter a balancein the Account balance field. Instead, position the cursor on theselection option "Account balance" and choose the "Selection options".Then select the Less than indicator in the dialog box thatappears. This will give you a list of all the customers with a balanceof less than 0 (credit).
Normal sales (sales without special G/L indicator) are always selectedif the "Select normal sales" parameter is set.
If you want to select normal sales only, make the following entries inthe "Special G/L indicator" fields:
Special G/L indicator A Z
Choose the "Selection options" and select the "Excl" indicator.

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


• Account name


• All items of the selected type (unless the line item output is
suppressed by the "Line items required" parameter) sorted by contractnumber

The following is displayed at item level:

Line 1:


• Contract type, contract number


• Posting date


• Document type


• Document number


• Document date


• Business area


• Number of document item


• Posting key


• Dunning level of the document item


• Payment method of the document item


• Amount eligible for cash discount in local currency


• Payment baseline date


• Due date for net payment


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


• 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


• Special G/L indicator


• Document currency


• Debit/Credit amount in document currency

Line 3:


• Business entity, if it can be determined


• Reference document number


• Document item text

Displayed per customer contract number:


• Debit total, credit total, balance per special G/L indicator


• Total debit amount, total credit amount, Final total

The following precedes the contract number:
'3/' for lease-outs
'C/' for collective lease-outs
'8/' for management contracts

Displayed per customer:


• Debit total, credit total, balance per special G/L indicator


• Total debit amount, total credit amount, Final total

Displayed per company code:
An overview of the business entities is displayed for each companycode. For each company code it contains:


• Debit total, credit total, balance per special G/L indicator


• Total debit amount, total credit amount, Final total


• These same details also for all items that do not have an account
assignment on a Real Estate object.
Following the list of totals for the business entities, thecorresponding totals for the company code are displayed.
If you set the "Only totals BE/company code" parameter, the totals areonly displayed per business entity and company code. Here, line itemsand subtotals are not displayed.
Please note that the totals for the business entities and company codesonly comprise the selected items. For a complete overview of a businessentity you have to omit all parameters except for the business entity.
For documentation purposes, the last page of the list is an overview ofthe parameters for the selection. The selection options are documentedin the conventional way, using:

• From-value, To-value


• I for parameters included in the selection, E for parameters excluded
from the selection

• The keys for interval and single value selection:

EQ single values
NE not equal
GE greater than or equal to
LT less than
LE less than or equal to
GE greater than
BT between