Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to specify Invoice Date Closed in a Saved Search Formula?
We have a report that generates results for commission to pay our sales people. Our commission calculation is customized for use. We now need to enhance this report to use Date Closed in a formula on the Results.
The result field labelled Commission Amount needs to use the Date Closed field. What is the field id for Date Closed. When I try "dateclosed", it results in "field not found". I have provided an example of the formula(date) that we want to implement using the Date Closed.
Any help would be greatly appreciated.
NVL(CASE WHEN {custbody_gsl_1099_reps} ='F' and