Accounts Receivable: DSO Analysis, Current Period

Technical name: 0FIAR_C02_Q0001

Based on InfoCube: 0FIAR_C02

Use

DSO stands for Days Sales Outstanding. The day sales outstanding (DSO) analysis is concerned with the customer payment history. This analysis is always made within a specific period. The DSO analysis delivers general information using the customer’s outstanding debts based on the average daily sales of this customer. DSO is measured in days and represents the daily sales value owed by the customer in DSO days.

For calculating the DSO days, the balance (= debts outstanding (open customer items) for the current period) is set against the sales (= average sales for the previous period) according to the following formula:

DSO = balance/sales for the previous period * 30

Filters

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0FISCVARNT

Fiscal year variant

0CURTYPE

Currency type (10 = company code currency)

User-Defined Characteristics

InfoObject

Description

0COMP_CODE

Company code

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0DEBITOR

Customer number

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Current balance

Accumulated balance of current period

Sales previous period

Sales of the previous period

DSO

Current balance/sales of previous period * 30