Accounts Receivable: Overdue Analysis

Technical name: 0FIAR_C03_Q0005

Based on InfoCube: 0FIAR_C03

Use

You can use this evaluation to determine those customers whose credit limits need to be monitored intensively as a result of considerable arrears.

The overdue amounts of each customer are sorted by the number of days overdue:

0 days | 1 - 30 days | 31 - 60 days | 61 - 180 days | 181 - 365 days | > 365 days

You can change the query if you wish to use a different sorting method.

Filters

InfoObject

Description of the Info Object (and restriction or calculation formula)

0COMP_CODE

Company code (single value entry, mandatory)

User-Defined Characteristics

InfoObject

Description

0ACCT_TYPE

Account type

0SP_GL_IND

Special G/L indicator

0POST_KEY

Posting key

0AC_DOC_TYP

Document type

0C_CTR_AREA

Control area

Rows

InfoObject

Description of the Info Object (and restriction or calculation formula)

0DEBITOR

Customer (selection options, optional)

Columns

The sorting that is defaulted in these columns is a proposal. You can use other sorting methods.

InfoObject

Description of the Info Object (and restriction or calculation formula)

0DEB_CRE_LC

Balance in company code currency

0 days

for all items:
Posting date < = key date, and
for cleared items:
Clearing date > key date

1 -30 days

As above

31 -180 days

As above

181 -365 days

As above

> 365 days

As above

Report/Report Interface

From this query, you can branch to the ODS object 0FIAR_O03 (Accounts Receivable Line Items). Using this ODS object as a basis, you can create evaluations of the Accounts Receivable line items.