A/P-A/R accounting > Inquiries > 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

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

    Header

    Fields

    The following fields are present on this tab :

    Company range

     

     

     

     

    Grouping level

    • Grouping level (field LEVELA)

     

    • Detail level (field LEVELD)

     

    Frequency

    • Start date (field INIDAT)

     

    • End date (field ENDDAT)

     

    • Periodic processing (field PERCOD)

     

    Currency

     

    • 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)

     

    Close

     

    Tab Details

    Presentation

    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.

    Close

     

    Fields

    The following fields are present on this tab :

    Grid

    • Graph (field LEVELG)

     

     

     

     

     

    • 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

     

    Close

     

    Tab Graph

    Presentation

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

     

    Fields

    The following fields are present on this tab :

    Grid Totals

    • field LIBTOT

     

    • Amount (field AMTTOT)

     

     

    Reports

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

     BANPOSANY : Banking position

    This can be changed using a different setup.

    Specific buttons

    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.

    SEEINFO 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

    SEEREFERTTO Refer to documentation Implementation