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.
Analytics - Customer Profitability Report
I am trying to create a custom customer profitability report in Analytics.
We have some custom fields and columns on an invoice & invoice line that calculate the values for warehousing / delivery and another that calculates the rebate percentage per item for that customer.
I'm trying to build a dataset that will give me the cogs from the item fulfilment and the revenue from the invoices or credit memos.
Where I am struggling is to calculate the COGs from an item fulfilment in it's own column. When I grab QTY x Transaction line Rate this gives me the values for the item fulfilment as COGs but because I need revenue in it's own column this way isn't working as in an analytics report it is bundling the rate x QTY values from the item fulfilment in with the invoices value.