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!
Search Criteria Formula to find Line Items on Sales Order
I'm trying to create a search to find line items on Sales Orders where the Committed Quantity divided by the Casepack Quantity (this is a custom field we have setup on the item record) is not a Whole Number. So in other words, Netsuite is committing a number that is not an even casepack quantity. For example the casepack is 4 pieces and NS committed 3 pieces or 5 pieces.
Here is what I have tried using the MOD function in the search criteria of a transaction search using a numeric formula field
Is Greater then 0
REMAINDER({quantitycommitted}, {item.custitem_casepackqty})
I have also tried the MOD function using