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!
Need field defaulting formula help
For a custom field, I am trying to do a simple formula:
For the default value, I have the following:
{quantityavailable}+{quantityonorder}-{quantitybackordered}
But the field in the form shows, "ERROR: Field Not Found"
We have multiple locations, but we only use one/1. I tried doing a simple script and the best I can muster is a "0" as follows:
function qtytoworkwith()
{
nlapiSetFieldValue('custitemqtytoworkwith',nlapiGetFieldValue('quantityonorder')+nlapiGetFieldValue('quantityavailable')-nlapiGetFieldValue('quantitybackordered'),true,true);
}
Any help or guidance would be much appreciated!
Pete