Reports > Module Financials > Report BALAGEGRP (Aged balance) 

The BALAGEGRP report categorizes BP open items that are not overdue into an aging schedule based on the open item due date or by the open item invoice date.

The aging schedule is based on three report parameters: No. of days 1, No. of days 2, and No. of days 3. The report calculates the number of days using the invoice date or the due date depending on the Age invoices by report parameter setting. The Age invoices by parameter default is due date. If you select Age invoices by invoice date, open items that exceed the Pivot date are not included.

If you select Yes for the Open item overrun report parameter, the report only includes customers who have exceeded their authorized credit limit amount.

Prerequisite

Access to the report

This report is accessible from the print management menus attached to the general accounting (Print and Print/group).

List of criteria

Parameter

Parameter title

Type

societe

Company

CPY

sitedeb

Site range

FCY

coldeb

Range of control accounts

SAC

grpcol

Control group

GSC

tiersdeb

Range of business partners

BPR

borne1

No. of days 1

C

borne2

No. of days 2

C

borne3

No. of days 3

C

regnv

Settlement not validated (Local menu No, Yes)

M1

ecrisim

Simulated entries (Local menu No, Yes)

M1

depasse

Open item overrun (Local menu No, Yes)

M1

datref

Pivot date

D

ageinvby

Aged invoices by (Local menu Age by invoice date, Age by due date)

M2809

sens

Sign (Local menu Debit, Credit)

M626

detpce

Detail by open item (Local menu No, Yes)

M1

tri

Sort order (Local menu Number, Title, Short title)

M676

typcur

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

M202

datcours

Rate reference date

D

impselections

Print selections (Local menu No, Yes)

M1

Comments

The data is filtered by site according to the rights granted to the user on the function CONSCPT (Accounts).

Description of the report

The open items included in the report depend on the Age invoices by report parameter setting. The Age invoices by parameter default is due date. If you select Age invoices by invoice date, open items that exceed the Pivot date are not included. If you select Yes for the Open item overrun report parameter, the report only includes customers who have exceeded their authorized credit limit amount.

The report header displays the following information:

  • The selected company
  • The currency used (company currency)
  • The reference date

For each BP, the report shows:

  • The BP code
  • The BP title
  • The telephone number
  • The partial balance for each open item range
  • The final total balance of the BP account

If Detail by open item is Yes, the report includes for each open item:

  • The Type/Document number
  • The date by due date or invoice date
  • The difference in days from the reference date
  • The open item amount if more than No. of days 3 + 1 day
  • The open item amount if the range is between No. of days 2 + 1 day and No. of days 3 late
  • The open item amount if the range is between No. of days 1+ 1 day and No. of days 2 late
  • The open item amount between the reference date and No. of days 1
  • The open item amount if not overdue
  • The balance

If Detail by open item is No, the report displays for each BP:

  • The open item total amount if more than No. of days 3 + 1 day
  • The open item total amount if the range is between No. of days 2 + 1 day and No. of days 3 late
  • The open item total amount if the range is between No. of days 1+ 1 day and No. of days 2 late
  • The open item total amount between the reference date and No. of days 1
  • The open item total amount not overdue
  • The open item total balance

The report also displays the following information at the company level:

  • A general total amount by open item
  • Company balance