[lnanji Contributions: 0Level 1☆]

Has anyone tried calculating this? The financial ratio is great, it would be cool if I could filter by Sales Rep – any ideas on how to do this?
This is a cached copy. Click here to see the original post.

[evan_goldberg Contributions: 0Level 1☆]

RE: Days Sales Outstanding (DSO) by Sales Rep

Not sure how to do it in a single search. You basically need to do a transaction search over the period grouped by sales rep to find the sales, then a transaction search for all time before the end of the period grouped by sales rep to find the balances, then merge the two.

Thanks,

-e

[kmcbride@miovision.com Contributions: 0Level 1☆]

RE: Days Sales Outstanding (DSO) by Sales Rep

How do you actually go about “merging” the two?

[evan_goldberg Contributions: 0Level 1☆]

RE: Days Sales Outstanding (DSO) by Sales Rep

Probably would need to be done in SuiteScript

[kmcbride@miovision.com Contributions: 0Level 1☆]

RE: Days Sales Outstanding (DSO) by Sales Rep

Is there any enhancement request in to be able to do it inline?

[Author]

Posts