Viewing Days Sales Outstanding

This topic discusses how to view days sales outstanding and personalize the Days Sales Outstanding pagelet.

Page Name

Definition Name

Usage

Days Sales Outstanding Pagelet

AR_PE_DSO_PAGE

View a bar graph that shows the days sales outstanding for up to five time periods.

DSO Personalization Page

AR_PE_DSO_PRS

Define default display information for the Days Sales Outstanding pagelet.

Use the Days Sales Outstanding pagelet (AR_PE_DSO_PAGE) to view a bar graph that shows the days sales outstanding for up to five time periods.

This pagelet uses a bar graph to display the days sales outstanding by time frame. The system filters the data based on the parameters on the DSO Personalization page. This table shows the calculations the system uses to display the data in the bar graph:

Calculated Amount

Calculation Method

Ending Customer Balance

Adds all customer balance amounts in the Item table (PS_ITEM) for a given time frame.

Sales in Period

Adds all entry amounts in the Item Activity table (PS_ITEM_ACTIVITY) for all entry types that make up the customer history ID of SALES for a given time frame.

Days Sales Outstanding

Multiplies the ending customer balance by 30 divided by the sales in period.

Use the DSO Personalization page (AR_PE_DSO_PRS) to define default display information for the Days Sales Outstanding pagelet.

Image: DSO Personalization page

This example illustrates the fields and controls on the DSO Personalization page. You can find definitions for the fields and controls later on this page.

DSO Personalization page

Field or Control

Definition

Number of Days

Indicate the number of days you want to see in the Time Frame axis of the bar graph on the Days Sales Outstanding pagelet.

Note: When you change any personalization options, you must run the Update Pagelet Statistics process in order for the pagelet to display the correct data.