Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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
0