Banking position

This function is used to analyze the banking position for a bank or a bank group. You can see the initial balance, the previous open items and all forecast types present into the cash forecast management in a defined period.

Furthermore, you can see the data of a line in a graphic representation. This graphic representation displays the evolution of the data in the different periods of this inquiry.

Prerequisites

Refer to documentation Implementation

Screen management

This funcionality is devided into three parts.

The header

In the header, enter the values to build the inquiry.

Details

This part displays the results of the inquiry in a grid.

Graph

The graphic representation displays the data of one line of the details grid.

Company range

Company (field CPY)
Site (field FCY)
Bank group (field GRPBAN)
Bank (field BANK)

Grouping level

Grouping level (field LEVELA)
Detail level (field LEVELD)

Frequency

Start date (field INIDAT)
End date (field ENDDAT)
Periodic processing (field PERCOD)

Currency

Currency (field CUR)
Rate type (field TYPRAT)

Accounting cash forecasts

Accounting (field TYPGAC)
Open items (field TYPDUD)
Leasing contracts (field CFOLEA)
Manual forecasts (field CFOME)

Purchasing cash forecasts

Purchase requests (field CFOPQ)
Purchase order (field CFOPO)
Purchasing open orders (field CFOPC)
Receipts (field CFORN)

Sales cash forecasts

Quotes (field CFOSQ)
Sales orders (field CFOSO)
Sales open orders (field CFOSC)
Deliveries (field CFODN)
CRM contracts (field CFOCM)

Tab Details

Grid listing the results obtained from the criteria entered in the differend fields. You can see the detail by BP and by document thanks to the zoom in each amount present in the grid.

Grid

Graph (field LEVELG)
Company (field CPY)
Site (field FCY)
Bank group (field GRPBAN)
Bank (field BAN)
Concept (field TYPFRT)
Due date (field DUDDAT)
field AMTCUR1
field AMTCUR2
field AMTCUR3
field AMTCUR4
field AMTCUR5
field AMTCUR6
field AMTCUR7
field AMTCUR8
field AMTCUR9
field AMTCUR10
field AMTCUR11
field AMTCUR12
field AMTCUR13
field AMTCUR14
field AMTCUR15

Tab Graph

Graphical representation of a line that has been flagged as 'graph' in the first column of the grid.

Grid Totals

field LIBTOT
Amount (field AMTTOT)

Reports

By default, the following reports are associated with this function :

Bullet point  BANPOSANY : Banking position

This can be changed using a different setup.

Specific buttons

Criteria

The fields of the Banking position criteria screen are used to build an additional filter to select the record you want to process.

Currency

To select the movements done in a determinate currency.

BP

Enter the formula to create a BPs filter, in order to obtain the movements made by the selected BPs only.

Bank

Enter the formula to create a banks filter, in order to obtain the movements made by the selected banks only.

Forecast types

In each forecast type field, enter the formula to create the forecast type filter, in order to obtain the movements of this forecast type only.

Note:

 Only the main table, acording to its type, is allowed into the formula.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

BANK: Mandatory Field

If the Bank group field is empty, the Bank field is mandatory.

You must select at least one origin

You need to select at least one kind of information type to obtain some results in the inquiry.

Selection criterion error

This message is displayed when you have any error in the formula(s) entered into the Banking position criteria screen.

Bank group incompatible with company

The Bank group is not compatible with the company entered.

Tables used

Refer to documentation Implementation