Use this report to view detailed information about the current status on open items for a customer or supplier. The amount due is listed by aging categories to provide an overall picture of invoices that are open on the customer or supplier’s account.

  • Print the report by customer to view an overview of outstanding receivables balances. This report is useful for managing collections and achieving an efficient receivables turnaround.
  • Print the report grouped by supplier to view an overview of paid and outstanding open items. This report is useful to make payment decisions.

Prerequisites

List of criteria

Parameter

Parameter title

Type

asofdate

As of Date

D

societe

Company

CPY

ledger

Ledger (Local menu Legal, Analytical, IAS, Gen. ledger 4...)

M2644

sitedeb

Site range

FCY

coldeb

Range of collective account

SAC

tiersdeb

BP range

BPR

datebase

Date basis for aging (Local menu Age by invoice date, Age by due date)

M2809

bprtype

BP type (Local menu Customer, Supplier)

M644

summary

Summary (Local menu No, Yes)

M1

namesort

Sort by name (Local menu No, Yes)

M1

txncur

Transaction currency (Local menu No, Yes)

M1

Comments

The data is filtered by site according to the rights  granted to the user on the function RPT09 (Print/group/acct ).

Description of the report

The report details include business partner, type, references, days old, base date, and not due. The report totals by business partner and aging totals based on the 0-30, 31-60, 61-90, and over 91 days buckets.

The report filters include the as-of date, site, collective, business partner, date basis for aging (invoice or due date), summary, sort option, and transaction currency.