This topic contains 4 replies, has 0 voices, and was last updated by kmcbride@miovision.com 14 years, 8 months ago.

  • Author
    Posts
  • #7379

    lnanji

    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.

  • #7380

    evan_goldberg

    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

  • #7381

    kmcbride@miovision.com

    RE: Days Sales Outstanding (DSO) by Sales Rep

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

  • #7382

    evan_goldberg

    RE: Days Sales Outstanding (DSO) by Sales Rep

    Probably would need to be done in SuiteScript

  • #7383

    kmcbride@miovision.com

    RE: Days Sales Outstanding (DSO) by Sales Rep

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

You must be logged in to reply to this topic.