Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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.