Hi,
Not sure whether to post this in reporting or in customisation. Our SLT wish to measure the time it takes from the creation of an opportunity record to the issue of a quote. All internet searching I have done on this suggests that I may need to create custom fields to do the time calculation and then present those fields on the report.
Netsuite knows when these actions occur, so I'm sure it must be possible to report on it, and ultimately measure it against a KPI as a key business analytic (avg enquiry to proposal time). Access to this sort of data was one of the reasons we bought NetSuite.
To use an example - this opportunity record was created on 28th October 2022 at 2:32pm:
The record was set to Proposal Issued Status on 22nd December 2022 at 8:03am.
So NetSuite knows that it took 54days, 17hours and 31 minutes, or 54.74 days from creation of the record to the Issuing of the proposal/quote to the customer.
The way I see it, my options to access and report this data are either:
- Create 3 custom fields to calculate this, one to display {createdate}, one to display {lastproposalissuedate} then a third which goes {proposalissuetime}={lastproposalissuedate}-{createdate}. Presumably if {lastproposalissuedate} is blank, this formula would return some sort of error?
- Create a saved search which reports those dates and does this calculation for me in the search. (if advice here is that this is the best option, perhaps I would be better moving my post to the Reports and Searches section of the forum rather than in this Customization section?)
I can't get my head around how I would handle the fact that the opportunity might cycle back round and move to the proposal issued status more than once, but I've got to start somewhere!
Has anybody else achieved this or something like it? Or is there anything part built in NetSuite that I could work with. It strikes me as one of the most important metrics for a growing professional services & solutions business, how long it takes us to get a complex design & proposal to a customer.
Thanks,
Chris