I have two landed cost categories (Ocean Freight and Duties).
I need to create a report that shows the item, its overall average cost, its total quantity on hand, its total value, the average duty based on the related landed cost template and the average freight based on the related landed cost template.
I tried to do this via item and landed cost template saved searches but they are not BOTH accessible in a single saved search.
So, I tried SuiteAnalytics. If I have 2 landed cost templates for an item and both have 2 cost categories, this results to 4 lines. When I average the duty, it is divided by 4 lines instead of 2 landed cost Templates. Same goes for freight. I'm fairly new to SuiteAnalytics, so excuse my ignorance here.