How is dso calculated in sap




















In this example, this would be the total sales for November, December, January. Example 2: This example shows the DSO calculation for all periods in a month period where 12 months are taken into account for each period. Adds the open receivables for the first month in the month period, for the number of months specified by P1 12 ending on that month. In this example, this would be the total open receivables for February to January Adds the sales for the first month in the month period, for the number of months specified by P2 12 ending on that month.

In this example, this would be the total sales for February to January Example Example 1: This example shows the DSO calculation for all periods in a month period where 3 months are taken into account for each period. The system calculates the DSO figures for a month period ending today in December as follows: Adds the open receivables for the first month in the month period, for the number of months specified by P1 3 ending on that month.

Repeats Step 1 for each month until the end of the month period. In this example, this would be for February, March, Adds all 12 results for open receivables Divides this sum by P1 3. Multiplies this total by The app warns you if the KPI figure exceeds predefined thresholds. For example, a warning could be set at 30 days, and critical could be set at 90 days. You configure these values in the KPI Modeler. If your company uses SAP Jam, you can post comments there.

You can also send emails from this app. The DSO app measures the time frame from the issue date of the invoice to the date you receive payment from the customer. For example, you can set the period for 1, 3, or 12 months. For more information, see the following documents:. You can also customize the display currency into which all amounts are converted and an exchange rate type for the conversion.

These linked apps must either already be available in your system landscape, or you need to implement them along with this app. The app consists of front-end components and back-end components.

When setting the P2 value, you need to consider whether sales take place sporadically or seasonally. As a rough guideline, if sales and payments are homogenous and frequent, the two parameters could be small and have the same value. The smaller P1 is, the more the DSO figures fluctuate. To calculate the DSO figures, the system takes into account open receivables items that have been invoiced but not yet paid or cleared and sales items that have been invoiced, and may or may not have been paid.

Partial payments are not taken into account. Items must be cleared completely. The following examples show the DSO calculation for the following situation:. In March, a customer orders goods worth USD 1,, and an invoice is issued. The total monthly sales in March is 1, USD.



0コメント

  • 1000 / 1000