Reg one preconfigured metrics not calculating as documented in the Advanced Collections Module
The Advanced Collections Module comes with preconfigured metrics documented here:
My organization enabled "True DSO" and reviewed the source code in IEX_COLL_IND.pkb. Contrary to the implementation guide which defined True DSO as:
True DSO per invoice = Number of days from invoice date to reporting date * (invoice amount / net credit sales for the month in which sale occurred)
The source code in IEX_COLL_IND.pkb follows this formula:
True DSO = Avg Open Balance / Daily Sales
Where daily sales = past 12-month receivables / 365, and
Avg Open Balance = (Current open balance + Open balance 12-mo ago)/2
This seems like a big misalignment to me, as with the current code True DSO will not represent actual days unpaid; instead, it's basically calculating a conventional DSO based on past 12-month. Can this be patched?