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!
Custom Item Field Formula or Script
Hello everybody.
I'm trying to create a custom Item Field with a formula to hold the result of:
{memberquantity}*{memberitem.averagecost}+{vendorcost}
This is working properly on a Saved Search:
{memberquantity}*{memberitem.averagecost}
but if I try to +{vendorcost} it will sum the vendorcost everytime it calculate the (member quantity * memberitem average cost) which is not right because the only vendor cost would be at the Assembly level.
Since the custom Item Fields cant use as sourcing a Saved Search, I'm wondering is someone have an example SuiteScript to do something similar?
Kind Regards
Alien.