Difference between revisions of "Aftersales reporting"
(Bulk update) |
Katy Kitchen (talk | contribs) (→Labour Hours Sold) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
== Summary == | == Summary == | ||
Your manufacturer may ask for specific reports regarding your aftersales business. Platinum has a range of reports which can be used to provide this information. | Your manufacturer may ask for specific reports regarding your aftersales business. Platinum has a range of reports which can be used to provide this information. | ||
| Line 44: | Line 43: | ||
* At {{DataPrompt|Search on}} enter {{DataValue|ROS}} and click {{Button|Search}}. | * At {{DataPrompt|Search on}} enter {{DataValue|ROS}} and click {{Button|Search}}. | ||
* At {{DataValue|Repair Order Summary}} click {{Button|Edit}}. | * At {{DataValue|Repair Order Summary}} click {{Button|Edit}}. | ||
| − | * Select Option 6 - {{Button|Range Filter | + | * Select Option 6 - {{Button|Range Filter (3)}}. |
* Press {{KeyPress|ENTER}}Type {{DataValue|S86}} and press {{KeyPress|Down}} arrow twice to the next free line. | * Press {{KeyPress|ENTER}}Type {{DataValue|S86}} and press {{KeyPress|Down}} arrow twice to the next free line. | ||
* Enter {{DataValue|T33}} then press {{KeyPress|ENTER}}. | * Enter {{DataValue|T33}} then press {{KeyPress|ENTER}}. | ||
| Line 77: | Line 76: | ||
{{Tip|text=If you have multiple manufacturers you may wish to modify this report to allow you to specify a supplier when running the report.}} | {{Tip|text=If you have multiple manufacturers you may wish to modify this report to allow you to specify a supplier when running the report.}} | ||
* Prior to clicking {{Button|Start}} click {{Button|Edit}}. | * Prior to clicking {{Button|Start}} click {{Button|Edit}}. | ||
| − | * Select Option 6 - {{Button|Range Filter | + | * Select Option 6 - {{Button|Range Filter (3)}}. |
* Type {{DataValue|S86}} and press {{KeyPress|ENTER}}. | * Type {{DataValue|S86}} and press {{KeyPress|ENTER}}. | ||
* Press {{KeyPress|F8}} and set {{DataPrompt|Blank means all}} to {{DataValue|Y}}. | * Press {{KeyPress|F8}} and set {{DataPrompt|Blank means all}} to {{DataValue|Y}}. | ||
Latest revision as of 10:08, 20 April 2022
Contents
Summary
Your manufacturer may ask for specific reports regarding your aftersales business. Platinum has a range of reports which can be used to provide this information.
 | If you find you do not have any of the report codes specified below or require assistance please Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page for advice. |
If you require custom reports to your specification please contact our sales team to discuss your requirements.
More Information
Common requests for data and the reports you may use to obtain the information are detailed in the sections below.
If you intend on running the reports on a regular basis you may wish to create a custom menu to allow you to access the reports from a single menu. See Adding options to custom menus.
Workshop Reports
Number of Repair Orders
To output the number of jobcards you have raised in a period per manufacturer:
Go to " Workshop Job Reports Workshop Report Generator".
- At "Search on" enter '~J1' and click [Search].
- At report 'Jobs Created in Period' click [Start].
- You may specify a manufacturer or leave blank for all.
- Enter the date range to report on jobs received in the period.
- You may specify up to 3 specific current job statuses to exclude from the report. Please note you need to enter the exact status codes in the correct case e.g. 'CRE' to exclude jobs created in error.
- If you have multiple sites specify the "Job depot" to report on or blank the field to report on all depots.
- Click [Start].
 | As the report contains a lot of detail you may wish to output the results to excel. At the bottom left of your report screen, change "Document" to "Table". Press <Ctrl+P> or click the [Table] icon at the top of your screen then choose [Excel]. Once opened use the "File - Save As" option to save the data as an Excel Workbook in a location of your choice. |
 | If you choose to print the report to PDF or Printer please be aware the job notes will not be printed unless you choose your landscape print record and have a printer set to print landscape orientation. |
To run the summary version to show total jobs only, please follow the above steps to run report '~J2 - Jobs Created in Period-Summary'.
Labour Hours Sold
To report on the number of hours invoiced in a period:
Go to " Workshop Job Reports Repair Order Summary"
- Enter your "Date Range" and click [Start].
- The report will split workshop invoices by type i.e. Retail, Internal and Warranty.
- Hours sold is under the column headed 'Hrs'.
| If you have multiple sites you may wish to modify this report to allow you to specify a site when running the report. See the steps below: |
- Go to " Reports & Settings Reports Accounts Report Generator".
- At "Search on" enter 'ROS' and click [Search].
- At 'Repair Order Summary' click [Edit].
- Select Option 6 - [Range Filter (3)].
- Press <Enter>Type 'S86' and press <Down Arrow> arrow twice to the next free line.
- Enter 'T33' then press <Enter>.
- Press <Shift+F8> and an asterix will appear on screen.
- Press <Esc> twice then click [Done] and [Accept].
Technician Productivity
The most suitable report/reports will depend on the method your workshop is using to record technicians time.
- See How do I run a workshop productivity report? for the options depending on how you are logging time.
| Productivity reports are based on hours booked to jobs in the period. The work may not have been invoiced in the period. |
Additional Activities
If you are using Real Time Labour recording/Platinum Online you may wish to see a split of the different activities logged per technician, including those not logged to a jobcard e.g. workshop cleaning:
- Go to " Workshop Job Reports Job Reports Labour Activity Report".
- You may specify a "Depot", "Technician", "Date range" and "Activity".
- Click [Display] to view the data.
- All time recorded will be listed along with a summary per technician and a total summary for the report.
Parts Reports
Retail Parts Sold
To report on parts sold in a period, split by Type and Group:
Go to " Stock Control Stock Reports Stock Report Generator".
- At "Search on" enter 'MB1' and click [Search].
- At report 'Invoiced Stock Profit - Summary' click [Start].
- Enter the date range to report on items invoiced in the period.
- If you have multiple sites specify the "Stock depot" or range of depots to report on.
- Click [Start] to run the report.
| If you have multiple manufacturers you may wish to modify this report to allow you to specify a supplier when running the report. |
- Prior to clicking [Start] click [Edit].
- Select Option 6 - [Range Filter (3)].
- Type 'S86' and press <Enter>.
- Press <F8> and set "Blank means all" to 'Y'.
- Press <Esc> three times then click [Done] and [Accept].
| As the report contains a lot of detail you may wish to output the results to excel. At the bottom left of your report screen, change "Document" to "Table". Press <Ctrl+P> or click the [Table] icon at the top of your screen then choose [Excel]. Once opened use the "File - Save As" option to save the data as an Excel Workbook in a location of your choice. |
To run the detailed version to show individual sales per item, please follow the above steps to run report 'MB2' - Invoiced Stock Profit - Detailed. If you modified the summary report to output for a specific supplier please repeat these steps to modify the detailed report.
Parts Purchases
To report on purchases in a period:
Go to " Stock Control Stock Reports History Reports Stock History"
- Change "Movement Type" to 'Purchases'.
- Specify your ranges i.e. "Depot or Depots", "Date range" and "Stock Groups".
- If you have multiple manufacturers you may wish to specify the "Supplier" to report on.
- Click [Start].
- The report will output to screen all purchases of items in the range specified. The total number of items and total nett value will be shown in the [Details] section at the top of your screen.
| As the report contains a lot of detail you may wish to output the results to excel. Press <Ctrl+P> or click the [Table] icon at the top of your screen then choose [Excel]. Once opened use the "File - Save As" option to save the data as an Excel Workbook in a location of your choice. |
Unit Reports
Units Registered
To report on units sold in a period:
Go to " Unit Sales Unit Reports Unit Sales Report Generator".
- At "Search on" enter 'VC1' and click [Search].
- Click [Start].
- Set your ranges i.e. select New units only and specify the Make and sales period.
- Click [Start].
| As the report contains a lot of detail you may wish to output the results to excel. At the bottom left of your report screen, change "Document" to "Table". Press <Ctrl+P> or click the [Table] icon at the top of your screen then choose [Excel]. Once opened use the "File - Save As" option to save the data as an Excel Workbook in a location of your choice. |
Alternative reports
The way you use your system will influence how the information is stored then presented to you. If you have any queries over the reports described above or would like to discuss custom report requirements please Contact your Platinum dealer or our support team on 0116 230 1500 or by using our website support contact page or Contact your Platinum dealer or our sales team on 0116 230 1500 or by using our website sales contact page.
See also
