Days Sales Outstanding

Summary

Days Sales Outstanding summary consist of days outs outstanding payment ratios calculated for one, three and 6 months by customer. We helps to compute Key KPI’s like Open Balance, Total sales and Average days of payment pending.

Dynamics 365 Menu Item(s)

• Accounts receivable > Customers > All customers > Related Information fact box > credit statistics

New data model’s data entities

• FNBI_CustSettlementEntity

Synapse link approach tables

• CustSettlement
  

Field level functional description

• AccountNum: The unique identifier for the customer account associated with the Days Sales * Outstanding (DSO) calculation.
• CurrencyCode: The currency in which the DSO and related financial values are measured.
• DSORatio_OneMonths: The DSO ratio calculated over the most recent one-month period, indicating the average number of days it takes to collect receivables.
• DSORatio_SixMonths: The DSO ratio calculated over the most recent six-month period.
• DSORatio_ThreeMonths: The DSO ratio calculated over the most recent three-month period.
• OneMonthsTotalSales: The total sales amount for the most recent one-month period.
• OpenBalance: The outstanding receivables balance that is yet to be collected.
• SixMonthsTotalSales: The total sales amount for the most recent six-month period.
• ThreeMonthsTotalSales: The total sales amount for the most recent three-month period.
• TotalSales: The cumulative total sales amount considered in the DSO calculation.