按日期客户帐龄余额

The selection criteria is used to query:

by Control account or Group of control accounts: in order to have useful information, the Aged balance screen must present at line level the information for invoiced BPs and paying BPs. The cases of compensation between customers and suppliers are excluded from the functional fields of this enquiry.

by Invoices BP and Paying BP: the entry of the Invoiced BP fills by default the Paying BP following the parameterisation of the customer or supplier record.

as a minimum, one of the previously mentioned criteria (control account / control account group, BP) must be assigned.

by Company/Site or for a Company all the sites taken together (site = ), or for a group of sites (Enquiry for a folder for example).

with respect to a Reference Date that is considered as a pivot date (or a date 0) displayed in groups of days. Example : the aged balance presented in 4 interval ranges:

-Interval start 1: 60

-Interval start 2: 30

-Interval start 3: 0

-Interval start 4: -20

The corresponding aged balance will have 5 columns:

-Column 1: Invoices overdue for payment by more than 60 days with respect to the reference date;

-Column 2: Invoices overdue for payment by 30 - 59 days with respect to the reference date;

-Column 3: Invoices overdue for payment by 0 - 29 days with respect to the reference date;

-Column 4: Invoices not overdue for payment in the next 20 days with respect to the reference date;

-Column 5: Invoices not overdue for payment for more than 20 days

Finally, a facility exists that is used to display the contact details by choosing the ContactFunction concerned. Simultaneously the Contact title as well as their Name and their Telephone number

This tab is used to view all the columns that are used to display the open items balance. Following the screen parameterisation, 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 parameterised and is always displayed in the exchange value. For example, for a Aged balance screen where the open items are presented in local currency, this column will display the open item total in transaction currency; conversely, the Aged balance screen where the open items are presented in transaction currency, will display this column the open item total 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 as a function of their due dates the amounts are dispatched into the interval columns.

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

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

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

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

Total display

This block contains:

a total amount

a total by interval

the part in % 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 parameterised in the general parameters STRINT1 to 9.

凭证

Displayed in the dialogue box are the contents of the Original document column. The use of this right click is to make available the information without scrolling or without integrating the Original document column to the enquiry.

发票查询

It is possible to pass to the original invoice: BP, sales or purchasing invoices.

日记账查询

This right click makes it possible to zoom to the associated accounting document.

付款查询

This click choice only appears if the open item has been the object of a payment. Makes it possible to zoom to the original payment.