You’re offline. This is a read only version of the page.
30
Can RMS Generate a sales report for 2012 showing total sales by shipping address country, and then, total sales by brand for each of the top 5 countries, excluding the U.S. ? I'm guessing not as the reporting capabilities have always been really disappointing from a strategic business intelligence analytics side of things. I typically just spend an hour trying to come up with a SQL query to get what I need.
Anyone want to throw me a bone on a query or an add-on product that will do this?
Thanks
RMS 2.0.x
*This post is locked for comments
I have the same question (0)
The shipping address part should be fairly straight forward custom report or sql query. The field you would want to use is Shipto.Country, which is linked to Customer by Customer.PrimaryShipToID, which in turn is linked to Transactionentry by Transactionentry.CustomerID.
As for the top 5 brands, it's going to depend on how you have brands set up in your database. Do you use one of the subdescription fields for brand, or is each brand its own supplier? Or are you just trying to parse the brand out of the item description?
Share
Report
All responses (
Answers (
