Set Document Status on Estimates
Published on
September 15, 2023 at 5:15:44 AM PDT September 15, 2023 at 5:15:44 AM PDTth, September 15, 2023 at 5:15:44 AM PDT
Scenario
User wants to set the Document Status of Estimates based on their Probability.
Solution
For Stand-alone Estimates (No Opportunity Linked)
Upon creation, theDocument Statuswill depend on the default customer status (Proposal) set for Estimates underSetup>Sales>Sales Preferencesunless the user manually changes theStatusandProbabilitybefore saving
If Probability is0%, then Document Status isClosed
If Probability is1-99%, then Document Status isOpen
If Probability is100%, then Document Status isProcessed
However, ifExpiresfield date has passed, then theDocumentStatuswill be set toExpired
Also, the basis of theDocument Statuson an Estimate is theProbability
If aSales Order/Cash Sales/Invoiceis created or associated to theEstimate, theDocumentStatusis automatically set toProcessed; even if the Probability and the Status of the Estimate is edited to less than 100%, theDocument Statuswill remain to beProcessed
If theSales Orderis deleted or canceled and theEstimateis not yet expired, theDocument Statusof theEstimateis set fromProcessedtoOpen
If theSales Orderis deleted and the Estimate is expired, theDocument Statusof theEstimateis set fromProcessedtoExpired
For Estimates that are linked to Opportunities
If theOpportunitylinked to theEstimateis edited and status is changed:
toClosed Won(Probability is equal to 100%)
Estimate Document Statuswill beProcessed
Opportunity Document Statuswill beClosed-Won
toQualifiedor any status (Probability is 1-99%)
Estimate Document Statuswill beProcessed
Opportunity Document Statuswill beIssued Estimate
toClosed-Lost(Probability is equal to 0%)
Estimate Document Statuswill beProcessed
Opportunity Document Statuswill beClosed-Lost
However, ifExpected Close Dateof theOpportunityis a past date (expired) and theStatusis changed toClosed Lost
Estimate Document Statuswill beOpen
Opportunity Document Statuswill beClosed-Lost
Below are the conditions that will result in an Estimate Document Status of Processed
When aSales Orderis created from theEstimaterecord
When anOpportunityfrom which theEstimateis created is set toClosed-Won
When anOpportunityfrom which theEstimateis created is set toClosed-WonorClosed-Lostand theOpportunityhas expired
When theEstimatehas aProbabilityof100%with or without an Opportunity attached