I have a custom field on Customer records:
{creditlimit}+{depositbalance}-({balance}+{unbilledorders})
This displays the remaining available balance for a Customer
If we create a Credit Limit for a Prospect, then this field displays correctly on the Customer (prospect) record.
I am trying to use this field/value in Sales Order Approvals.
I can either put a custom field on the Sales Order as:
(({entity.creditlimit}+{entity.depositbalance}) - ({entity.balance}+{entity.unbilledorders}))
or I tried
((NVL({entity.creditlimit},0)+NVL({entity.depositbalance},0)) - (NVL({entity.balance},0)+NVL({entity.unbilledorders},0)))
Or I can reference the Customer Field in the Workflow using:
In either / both cases, this works fine with Customers. However, when a Sales Order is raised on a Prospect (to convert it to a Customer) this field is NULL (or 0 in the case where I use NVL statements).
I also had a similar problem with a custom Customer status we had created for 'Lapsing' customers where I set the Probability level to 50%. I reset this to 100% and then approvals for Lapsing Customers appear to work OK.
So I assume there is something in NetSuite that identifies the Prospect Probability as less than 100% and therefore is not applying the Financial fields correctly (but I find it strange these work OK in the Customer field?)
I can't change the probability of the Prospect Stage as this will impact the Quote Pipeline reporting. Is there any other way to overcome this limitation?