Accounts Receivable: Due Date for Net Payment Analysis

Technical name: 0FIAR_C03_Q0002

Based on InfoCube: 0FIAR_C03

Use

This evaluation sorts open items by due date for each company code. Cumulative totals are displayed for all customers selected. The evaluation is a preview, and overdue items are therefore not sorted.

The due date for net payment is calculated as follows:

Due date for net payment – key date

Grace days are not taken into account.

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

0C_CTR_AREA

Control area

0AC_DOC_TYP

Document type

0POST_KEY

Posting key

0SP_GL_IND

Special G/L indicator

   

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 - 15 days

As above

16 -30 days

As above

31 -45 days

As above

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