I need to create some custom reports off data that will be collected from two modules, one called Sales Representative Pro and another called Advanced Custom Fields.
I know that we need to see sales by rep by date and be able to see the details of each order that the rep is getting credit for (so that we can see the categories, selling price and not have shipping and tax included).
- Revenue by Zip Code
- Revenue (w/order detail) by group (ie: wholesale / retail/ international)
- A full report with all the fields below and totals at the bottom:
Sales Rep (from custom extension Sales Representative Pro)
Referred By/New Referral: (Custom field from Advanced Custom Fields extension)
(And all numeric fields total at the bottom of the report)