There is a Help portal – How the DSO Is Calculated (https://help.sap.com/docs/SAP_S4HANA_CLOUD/918bca53037f408f91a2295d04ac16bc/30759d54da6e420ba745718ef5cfa970.html?version=LATEST&ai=true&locale=en-US) of Public Cloud, and how can we retrieve the parameters in a Fiori App?
If you're wondering how to calculate Days Sales Outstanding (DSO) using the Public Cloud platform, here's an approach you can follow based on a practical example:
Example: Calculating DSO on November 19th
Today is November 19th, and the DSO is 110. Let’s break down the calculation step-by-step:
Step 1: Retrieve Customer Balance in Fiori App
Use the app “Display Customer Balance” in Fiori to get the required financial details.
Posting Period: The current posting period is November (Period 11).
Current Balance: The balance displayed for this period is 70,801.57 EUR.
Sales of the Period: The total sales for the last three periods need to be calculated as follows:
- September sales: 70,035.63 EUR
- October sales: -19.94 EUR
- November sales: 0 EUR
Total Sales for the Period = 70,035.63 + (-19.94) + 0 = 70,015.69 EUR
Step 2: Determine the Sales Period
The sales period is calculated as the sum of the sales days in the last three months, plus the sales days in the current month (up to today). For this example:
- September: 31 days
- October: 30 days
- November: 31 days
- Current Month Days until November 19th: 18 or 19 days
Note: Due to time zone differences, the value for the current month's sales days can sometimes vary between the actual number of days passed and one less day. In this example, we are using 18 days.
Therefore, the total Sales Period = 31 days + 30 days + 31 days + 18 days = 110 days.
Step 3: Calculate DSO
:The DSO = Currently Balance / (Sales of the Period * period) = 70801.57/ (70,015.69 * 110)= 111.2346775415625 = 111
Hopefully it is helpful for your doubt about calculating the DSO of FSCM.
Best Regards,
Brant
Source link

