logo

Are you need IT Support Engineer? Free Consultant

How to calculate the DSO in FSCM – SAP S/4HANA Cloud Public Edition

  • By Sanjay
  • 20/11/2026
  • 14 Views



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:

 Brant1_0-1795079527010.Png

Step 1: Retrieve Customer Balance in Fiori App

Brant1_2-1795080741959.Png

Use the app “Display Customer Balance” in Fiori to get the required financial details.

  1. Posting Period: The current posting period is November (Period 11).

  2. Current Balance: The balance displayed for this period is 70,801.57 EUR.

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Chat with us on WhatsApp!