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.
In a Summary Saved Search, is it possible to Highlight comparing a Sum field with a Max field?
We have a Saved Item Search to calculate the inventory sell value for inventory in a given project. We achieve this by grouping on the Related Project custom field, and we Sum the {quantityavailable}*{price} to get the total inventory sell value. We also have an Inventory Cap on each Project record, so the search joins that field, and the summary displays it as a Maximum (since it is the same for all items in a given project, obviously).
We want to have highlighting based on comparing the Sum of {quantityavailable}*{price} with the Inventory Cap on the Project (Maximum of Related Project : Inventory Cap). Specifically, we want the line to highlight in yellow if the Inventory Sell Value is 80% or more of the Inventory Cap, and in red if over the Inventory Cap.
Pierre J.-L. Plourde
IT Manager/NetSuite Administrator
Peak Performance Products Inc.
e: pierre@pppinc.ca
t: 416-674-7325 ext. 1029
c: 905-439-7645
f: 416-674-7326
w: www.pppinc.ca
6956 Columbus Road, Mississauga, Ontario L5T 2G1
Oracle NetSuite Certified—ERP Consultant
Oracle NetSuite Certified—SuiteCloud Developer II
Oracle NetSuite Certified—Administrator
Oracle NetSuite Certified—SuiteFoundation
Oracle NetSuite Certified—Financial User
Oracle NetSuite Certified—SutieAnalytics User