By design, NetSuite converts a Prospect (or a Lead) to a Customer stage with default Customer status (Active), even if Sales Order total is $0.
Also, by design, if Opportunity record is associated with the SO being created for the Prospect then Opportunity status is sourced from the Customer status. (Active)
Since NetSuite converts the Prospect (or Lead) as described above, I was thinking to implement the below customizations to overcome this:
• For Sample orders (Order total = $0 and no past orders with total greater than $0 for the customer)
Revert back to the Prospect (or the Lead) status on the Customer record.
Currently, Prospects are getting converted to the default Customer status of Active because of the standard NetSuite behavior of converting Prospect to Customer status when a SO is created for the Prospect.
I tried implementing a user event script to overcome this (deployed on SO afterSubmit) - but it does not work as the Customer status reverts two times -> first to the original Prospect status and then to Customer-Active status by the system I think.
• For non-Sample orders (Order total > $0)
Update Opportunity status to C: 5. Opportunity Won
Currently, if Opportunity records are associated with the SO (meaning either the SO is created from the Opportunity record OR if Opportunity is selected on the SO while creating the SO) then the Opportunity status follows the standard NetSuite behavior of sourcing the Customer status. In our case, the default Customer status is Active so the Opportunity status gets the default value of Active, instead of “C: 5. Opportunity Won.”
So, basically, Customer record's default status should be Active but Opportunities should not assume the same status as the Customer - they should default to the other Customer status of "C: 5. Opportunity Won"- In other words, the customer and opportunity status should be independent of each other as per our sales team. I am not sure how we achieve this as I have tried creating a workflow as well as afterSubmit userevent script. But both don't work as expected. One more thing is I saw on Opportunity's entity status the following description: "If there are estimates or sales orders associated with the opportunity, the status of the opportunity is updated to match the transaction's status."
Honestly, I don't understand this statement in terms of SO. What does it mean that it will match the transaction status in terms of SO? If SO is created and its status is Pending Fulfillment, I don't see Pending Fulfillment on the Opportunity's entity status.
Overall, I have tried work