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.
Search Formula to Determine Margin
I have created a custom record called "Products" that looks to the Customer Record as a Parent. One of the fields on this custom form is named "Fixed Cost" that determines my cost per product.
Example:
Product1 = $100 Fixed Cost
Product2 = $200 Fixed Cost
Prodcut3 = $300 Fixed Cost
Each customer has the potential to have multiple products and multiple fixed cost amounts. I want to sum these amounts as the numerator (from the products custom record) and divide them into the total sales amount (located on the customer record in a custom currency field) to determine my margin % in a Saved Search.
Whenever I attempt this, I have no problems sourcing both numbers on the search, but the amount for the total sales amount is repeated for the line items that represent the products. To explain using the example above: