This function is used for a given reference date to reconstitute an aged balance for a date.
The reference date therefore plays an important role because the information is reconstituted to how it was on that date.

This inquiry is a useful work tool in the tracking of open items. It can be accessed in two ways:

  • via the menu < P/L and S/L accounting \ Inquiries \ Aged balance >
  • From the customer or supplier record <Tool bar \ Inquiries \ Aged balance>

SEEWARNING This function enables the retrieval of the balance to date, but does not process every case.The historization of the open items is based on the flows in the modules upstream of the Financials module.The accounting events (manual matching/unmatching) do not fall within the archiving context per se.
(i.e. an invoice manually matched with two non-posted payments of different dates will be considered as closed on the earliest date of the two, not successively and gradually on the date of the two payments).

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

This inquiry is carried out on a single tab.

Header

In the header, specify the necessary fields, this information will be displayed in the Aged balance grid. You must at least enter the BP field.

Tab Aged balance

This tab is used to view all the columns that are used to display the open items balance. Following the screen setup, the totals are displayed in either transaction currency or local currency. Only the "Total in local currency" column (or "Total in transaction currency") cannot be set up and is always displayed in the exchange value.
For instance, if the open items are displayed in "local currency" in the Aged balance screen, this column will display the amount of the open item in "transaction currency". Conversely, if the open items are displayed in "transaction currency", this column will display the amount of the open item in "local currency".

Open item display

The reference date is the date from which the BP situation should be fixed. It is the pivot date from which the amounts are dispatched into the interval columns based on their due dates.

Example:

Creation of an invoices for 01/07/04 for an amount of 1000 EUR.
Creation of a credit note matched to the invoice for : 05/07/04 for an amount of € 200.

CASE 1: Inquiry on the reference date 30/06/04

Document no.

Amount

Paid

None

-

-

 

 

 

CASE 2: Inquiry on the reference date 02/07/04

Document no.

Amount

Paid

Invoice

1000

 

 

 

 

CASE 3: Inquiry on the reference date 06/07/04

Document no.

Amount

Paid

Invoice

1000

200

 

 

 

"Total" block

This block contains:

  • a total amount,
  • a total by interval,
  • the part in %age for each interval.

Only the totals for the first seven intervals are displayed. The general total takes into account the totals from the nine interval columns set up in the general parameters STRINT1 to 9.

Criteria

This function gives access to other inquiry criteria that are in part displayed at the top of the inquiry screen:

  • the company and the site as well as the Reference date. Checkboxes are used to refine the inquiry and specify whether simulation documents and/or non-posted payments (payments entered, allocated but not posted yet) should be taken into account.
  • two sorts are submitted (by Open item date or by accounting date) as as well as the display order of the information (Ascending/Descending),
  • It is possible to call another aged balance screen via the "Screen code" field.
  • the Intervalles table is used to define or modify on the fly the interval ranges for the aged balance, expressed in numbers of days. The fields are only accessible based on the interval range number declared at the level of the setup of the inquiry screen. The ranges submitted by default are recovered from the STRINT1 to STRINT9 parameters.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation