Follow

How to get Detailed Reports on Product Lists inc Sales of Parts by Group

The purpose of this guide is to show you how you can run a report to give you the GP of what you are making on your Parts by the Parts Groups you have setup in the system. NOTE: For the guide on how to create Part Groups http://service.autosoft.com.au/entries/21903580-How-to-Create-New-Part-Categories-and-or-Groups

 

There are a few different reports and queries available depending on what you wish to review. See the following on some of the currently available reports in the reports console, there is also an additional module called 'Key numbers' which allows you to get even more information. Contact us for further info. 

 

Reports

  • Go to Reports - Reports Console - Sales Under the Sales Reports, there are a few available
  • Pick your report as applicable 
  • Select Filters
  • Run

sales_by_group_reports.png

 

e.g  If I want see all Item Sales grouped by Part Groups

  • Sales - Item Sales Report

Item_Sales_Report_Path.png

  • Select the Date Range you want to report on
  • Select the Group Selection Option 'Group'
  • Tick Options for Summary and Don't Print item Subtotal (as necessary)
  • Run

Report_by_Group.png

  • You can then Export the report to excell or other formats if you need to analyse/filter further OR Print it as necessary. 

exsport.png

 

 

Queries

There is also Stock Master File Queries available and as with reports you can export or print. 

  • Go to Parts OR Workshop - Stock - Stock Master File
  • Query tab
  • Drop down to select applicable query

stock_master_file_query.png

e.g if I want to see Sales Last 12 Months All Products with more info than the Item sales report

  • Select Sales Last 12 Months All Products
  • Export or Print as applicable

stock_master_file_query.png

 

 For a full list of product info;

 all_products.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.