Advanced Reporting
I am looking to run a quantity sold & total revenue, report for a single customer based on my Item Sales Description that has the past 12 months/4Qrts/3Years in separate tables on the same report. When we upgraded to Enterprise we changed our item types/numbers, but kept the description the same. Old items were Inventory Items, new items are Assembly Items. I need to be able to merge the qty's into one line item per the Sales Description. Can anyone help me with this?