13 Replies Latest reply on Feb 16, 2018 2:44 PM by Aaron Delaup

    Calculating DSO from Sales History and current Aging-AR snapshot (Summarized)

    Aaron Delaup

      I am trying to link a current snapshot of total amount AR due by customer to sales history data in order to calculate a depleting DSO. I am having an issue with not adding the AR total. The amount due is being placed in the table when 1 record is due instead of rolling them all up into 1 sum at the current time. Ideally we would have sales history invoice data by month by customer Jan2017-Jan2018 and then 1 total AR amount due at the end. This would allow us to calculate DSO based on that current total amount due.