Modified Report - Sales by Supplier by Individual Product
My Boss would like to access or print off a Modified Report for our listed inventory items that show Sales by Supplier (by Inventory).
Ideally, this report would be able to immediately show the greatest number of sales per product for each of our suppliers.
Is this request possible via the current available reporting selections?
Comments
-
Hi Vanessa
Just to clarify ... You're wanting to report on the sales of your Inventory Items but grouped by Supplier ?
Are your Items set up as grouped that way in your Item List ?
eg
Supplier 1
Item A
Item B
Item C
There are many default reports for Sales, Customers, Suppliers & Items but Sales are usually associated with Customers rather than Suppliers so I'm just trying to determine exactly what you're wanting to see.
1 -
Thanks for your reply, Shaz.
Our inventory list has been set up with the stock listed under product headers (eg. grouping of similar product items/purposes together) but each item is individually linked to the specific Supplier in the details on that product.
We are wanting the report to identify which of our stock lines have the most orders / turnover but also list which supplier these items were sourced from.
Can one of the Sales Reports be modified to include Supplier information or is there an Inventory Report that has the Supplier linked to it that can be modified to produce what is required?
0 -
Hi Vanessa
The Supplier field in the Item is database-specific rather than transactional so will only display in List-type reports.
The Sales by Item Summary sorted by Total would show what you need (minus the Supplier) displayed in order from highest to lowest (or vice versa):
This report contains other columns which I've unticked to not show but the Qty & Avg Price columns aren't able to be removed (although if necessary, you could export it to Excel to do that though)
Is that one any help ?
1 -
Thanks for the explanation, Shaz.
I have passed your information on to my employer for their attention and actioning.
1
