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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
save search - item availability today formulas help
Hi.
I have this Item save search that provided me open sales orders committed and not committed and work orders. This image is just as a reference to try to explain what I am looking for to do.
I am looking the following formulas:
1- To Sum all the Sales Orders that are not Committed that are minor of the date of the Work Order. For example: The first WO date is on 10/28 so I would like to Sum the Sales Orders containing 0 committed, the one from 9/28 and the two of 10/03. Will sum the quantities. 25+41+15=81.
2- If there is not WO to Substract Qty in Inventory Now - the previous result: 415 - 81 = 334. But if there is a WO to sum the (Qty in Inventory Now + WO) - the previous result: (415+72)-81 = 406.