Banking position

This report is used to print the records included into the banking position. We can filter with several criterias:

  • Company
  • Site
  • Date range
  • Currency
  • Rate type
  • Bank group
  • Bank
  • Grouping level
  • Detail level
  • Periodicity
  • Each cash forecast type available in the banking position inquiry (from Accounting to CRM contract)

This report prints the registers from the working BANKPOSD table , according to these parameters.

Prerequisites

Access to the report

This report can be accessed from the report menu of the group Treasury.

It is also called by default from the following functions :

  A/P-A/R accounting > Inquiries > Banking position

List of criteria

Parameter

Parameter title

Type

soc

Company consolidation code

CPY

site

Site

FCY

datdeb

Date range

D

cur

Currency

CUR

typrat

Rate type (Local menu Daily rate, Monthly rate, Average rate...)

M202

grpban

Bank group

BGR

ban

Bank

BAN

grplev

Grouping level (Local menu Company, Bank group, Bank, Site)

M3634

detlev

Detail level (Local menu Total, Forecast type, Document)

M3635

period

Periodicity (Local menu Day, Week, Month)

M278

typgac

Accounting (Local menu No, Yes)

M1

typdud

Due date (Local menu No, Yes)

M1

cfolea

Leasing contract (Local menu No, Yes)

M1

cfome

Manual forecasts (Local menu No, Yes)

M1

cfopq

RFQs (Local menu No, Yes)

M1

cfopo

Purchase orders (Local menu No, Yes)

M1

cfopc

Purchasing contract (Local menu No, Yes)

M1

cforn

Receipts (Local menu No, Yes)

M1

cfosq

Quotes (Local menu No, Yes)

M1

cfoso

Sales orders (Local menu No, Yes)

M1

cfosc

Sales contract (Local menu No, Yes)

M1

cfodn

Deliveries (Local menu No, Yes)

M1

cfocm

CRM contract (Local menu No, Yes)

M1

impselections

Print selections (Local menu No, Yes)

M1

Comments

In a start/end range type of parameter, not entering anything for the two values means that the report will ne be restricited to the parameter value.

The data is filtered by site according to the rights  granted to the user on the function CONSBTR (Banking position).

Description of the report

In this report, the data displayed are the following:

  • Graph
  • Company
  • Site
  • Bank group
  • Bank
  • Concept
  • Due date
  • Columns with the amounts by periods according to periodicity field (12 or 14).

The data are grouped according to the selected levels (grouping and detail levels).