Margin Analysis by Inventory

Margin Analysis by Inventory

Has anyone produced anything similar to the above report in NAV

Report Filters:
Global Dim 1
Global Dim 2


Report fields:
Item No.
Customer Name
Sales Value (taken from range of GL accounts)
Cost of Sales (taken from range of GL accounts)
Cost of Sales Adjustments (taken from range of GL accounts)
Other (taken from range of GL accounts)
Margin - excel formula
Margin % - excel formula

Thank you!
Wilz