Description
This program is used to analyze and post deposits and loans entered aspayment advices, displaying only the payment advices that are notarchived and that are not interest advices (compare statisticsindicator).
The statistics indicator describes the status of a payment advicewithin deposit and loan management. The status specifies, for example,whether the investment amount is already posted, whether the interestadvice is planned or the reverse entry is made. The indicators aredefined internally in the program as follows and must not be changed.
" ": Interest not planned; investment amount not posted.
"1": Interest planned; investment amount not posted.
"2": Investment amount posted; interest still not planned yet.
"3": Interest planned; investment amount posted.
"4": End of deposit or loan was posted.
"Z": Interest planning.
You can sort by settlement accounts or by asset accounts. Sorting bysettlement accounts occurs by default.
The program calculates and displays the maturity term and the expectedinterest for payment advices. The program does not take leap year intoconsideration when calculating days to maturity, and does not calculatewithholding tax for the interest amount.
If during selection you enter a key date to calculate foreign currency,payment advices in foreign currency are translated into the localcurrency at the key date. In addition to the translated amounts, theprogram displays any exchange rate losses or gains resulting from thetranslation in the payment advice.
The program carries out totaling separated by currency using theplanning level, account, business area and company code. At the end ofa company code, the program outputs an accounts overview listing theindividual account totals of the company code.

Display Mode
You can access the report in individual display mode (advice display)or totals display mode.
Payment advices you select are displayed in the individual displaymode. Here you can carry out editing functions. Totals are displayed atthe end of a company code (representing the totals display). You canbranch from the individual display mode to the totals display mode.
Only totals of the company code are displayed in the totals displaymode. Individual payment advices are no longer displayed. The programlists the following totals:
- sum total in the company code per currency
- account totals in the company code
- business area totals
You can branch from the totals display mode to the individual displaymode.

Functions
The program offers the following functions:
1. Displaying payment advice data
2. Analyzing accounts
3. Planning interest
4. Posting the opening of deposits/loans
5. Posting the closing of deposits/loans

Displaying Payment Advice Data
You can display detailed payment advice data by clicking the displayfunction or double-clicking the payment advice.

Analyzing Accounts
In accounts analysis, payment advices are displayed in condensed format the planning level. Additionally, the program calculates theaverage maturity days and the average interest rate. When determiningthe average, the system carries out a weighting based on the investmentamount.
Since the program carries out interest rate averaging at the planninglevel, you should separate cash invested and cash borrowed intodifferent planning levels in order to ensure that a meaningful averageis produced.

Planning Interest
If interest advices have not already been created (compare statisticsindicator), you can create them for selected payment advices by usingthe "Plan interest" function. The system then transfers the calculatedinterest and the data from the original payment advice to the interestadvice. The interest advice is assigned the statistics indicator Z andthe number of the deposit or loan advice. In the deposit/loan advice,the system records that an interest advice has been created. Aninterest advice is only created if the interest amount calculated isnot zero.
You can create the interest advice after already having made thebeginning posting for the deposit or loan, since the advice is onlytaken into account during the closing posting.

Posting the Start of Deposits or Loans
For all payment advices you select, the program carries outcorresponding postings to open the deposits or loans in FinancialAccounting. If you also enter a posting period, the program uses thisperiod when posting, otherwise it posts to the current posting period.In addition, the program checks that the investment amount has notalready been posted (compare statistics indicator) and that the assetaccount (offsetting account) has been entered in the payment advice.Using account determination in FI, the program determines the postingkeys and the accounts depending on whether you are investing orborrowing cash.

Posting the End of Deposits or Loans
For all payment advices you select, the program makes the correspondingpostings to mature the deposits or loans, checking that the postingshave not already been made (compare statistics code). Using FI accountdetermination, the program posts the repayment of cash invested orborrowed and the interest received or paid. It archives thedeposit/loan advice and, if one exists, the interest advice with thearchiving category of the planning type.

Filling the Posting Date and Value Date:
If the posting date is already defined, the program enters it as theposting date in the documents; otherwise the planning date is enteredas the posting date.
If the value date (by foreign currency) is predefined, the program usesit for the value date and the translation date with foreign currencies.Otherwise, the program fills these dates with the planning date aswell.

Special Features
The program assumes that the settlement account and the asset accountare defined in the same company code. The statistics indicator is tobe set and changed only by the program. It cannot be modified by userentries. Displayed exchange rate gains or losses are not posted duringthe posting process. If you create a beginning advice for thedeposit/loan advice, it must be archived manually.
Note that during account determination, the system does not replace thedeposit/loan account (Offsetting account field in the advice), butreplaces only the settlement accounts.