Editing Reporting

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 1: Line 1:
 +
Report Builder Overview:
 +
 
Report Builder is the reporting component used in SME for creating and customizing reports. To access Report Builder:
 
Report Builder is the reporting component used in SME for creating and customizing reports. To access Report Builder:
  
 +
Go to Reports> Customize Reports
  
−
== Report Builder Module ==
+
[[Report Builder Module]]
−
 
 
−
 
 
−
To access Report Builder in SME go to the Reports module> Customize Reports> Open Report Designer.
 
−
 
 
−
If the report you are editing is a Standard Report you will be asked to create a custom report. Refer to Duplicating a Report for Custom Use.
 
−
 
 
−
To become familiar with the report builder module and user interface refer to the Report Builder Tutorial.
 
−
 
 
−
Some SME reports use SQL queries to extract data. If you are editing a report with the report file name starting with "qry" contact High5 Support for assistance modifying the report.
 
−
 
 
−
 
 
−
 
 
−
== How to Duplicate Standard Reports for Custom Use ==
 
−
 
 
−
 
 
−
*          Go to the ‘Report Center> Customize Reports’
 
−
 
 
−
*          [[File:1 Image(1).png]]
 
−
 
 
−
*          Retrieve the report you want to duplicate from ‘Search Standard’.
 
−
 
 
−
*          [[File:2 Image(1).png]]
 
−
 
 
−
*          After the report loads click on the ‘Duplicate Report’ button.
 
−
 
 
−
*          [[File:3 Image(1).png]]
 
−
 
 
−
*          SME will auto fill the fields with the word ‘Custom’ and ‘Copy of’. At this time it is recommended that you rename the report to a name unique for your company or use.
 
−
 
 
−
*          [[File:4 Image(1).png]]
 
−
 
 
−
*          Similar to this:
 
−
 
 
−
*          [[File:5 Image(1).png]]
 
−
 
 
−
*          Save the report.
 
−
 
 
−
*          Click on the ‘Open Report Designer’ button.
 
−
 
 
−
*          [[File:6 Image(1).png]]       
 
−
 
 
−
*          When the report designer opens click on ‘File> Save As’ and rename the report.
 
−
 
 
−
*          Note: It is recommended that you add a prefix or suffix to the current report name as this will enable High5 support to readily assist with troubleshooting should an issue arise.
 
−
 
 
−
*          [[File:88 Image(1).png]]
 
−
 
 
−
*          Click ‘Save’ and close the report designer.
 
−
 
 
−
*          Click on the browse ellipsis to the right of the ‘Filename’ field and select the file you saved in the step above.:
 
−
 
 
−
*          [[File:7 Image(3).png]]
 
−
 
 
−
*          Click on Open:
 
−
 
 
−
*          [[File:8 Image(2).png]]
 
−
 
 
−
*          Click on Save and the custom report will now be unique and ready for further editing.
 
−
 
 
−
*          [[File:9 Image(1).png]]
 
−
 
 
−
 
 
−
 
 
−
<div align="center"><b><span>Reports </span></b><b><span>Center</span></b></div>
 
−
 
 
−
'''Purpose'''
 
−
<br>The purpose of this document is to further explain the different options under the Customize Reports section of SME. Most reports can be run from their respective modules. While other details reports, like the Aging and Tax Reports are actually ran from the Reports Module.
 
−
 
−
 
−
'''Document Center Overview Main Screen'''
 
−
<br>The main function of the document center is that of a central repository which will allow you to keep track of external documents you deem important, as well as any reports templates you want to create for SME.
 
−
 
 
−
 
 
−
'''Option Found on the Main Screen (Details and Settings)'''
 
−
 
 
−
 
 
−
<table>
 
−
<tr>
 
−
<td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">'''Short Name'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 71pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="95">
 
−
<p><font color="black">Short Name is internal name of the document for SME.</font>
 
−
 
 
−
</p>
 
−
 
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''Title'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">In some reports it is possible to generate a title on the fly. Which will be explained in detail later in this document.</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''File Name'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">This is the physical name of the file.</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''Description'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">General description of what the file is used for.</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''Is Restricted'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">Checking this makes it so only an administrator can view this report.</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''File Name'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">This is the physical name of the file.</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''Is External'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">Used to determine if this is an SME report builder report, or an external report or document.</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''Duplicate Report'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">This creates a new entry in the Docs table, with all same information as above. (Used for making a custom aging report).</font>
 
−
 
 
−
</p>
 
−
</td></tr>
 
−
<tr style="height: 15pt;">
 
−
<td style="padding: 0in 5.4pt; width: 123pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="164">
 
−
<p><font color="black">'''Report Designer'''</font>
 
−
</p>
 
−
</td><td style="padding: 0in 5.4pt; width: 65pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="87">
 
−
<p><font color="black">Used to Launch Report Designer.</font>
 
−
</p>
 
−
</td></tr></table>
 
−
<br>'''Availability'''
 
−
<br>The Availability tab allows you to allow you to choose where a report will be located when you want to print the report, as well as its location under the Reports Module.
 
−
 
−
'''Reports Specifiers'''
 
−
<br>The Report Specifiers tab function is your main options in setting up Reports for SME to use. This includes filters, Main table, as well other options as explained below.
 
−
 
 
−
 
 
−
<table border=1>
 
−
 
−
    <tr>
 
−
      <td>Master Table</td>
 
−
      <td>This is the main table from which data will be pulled from. Also note that all filters <br />applied are against the master table.<br /> <br />Another thing to note about master table, is that certain tables, such as Service Orders, <br />Install Orders, Invoices, and Proposals will bring in all the other related tables.<br /> <br /> </td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Date Specifier</td>
 
−
      <td>This option is to be used when you want to apply filter on reports by a date range. Now <br />this can be either a single date range, or Beginning and Ending Date range. Date field<br />will be determined by what you pick as your master table. Note: Running the report with <br />filters is done though the Reports Module.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Status Specifier</td>
 
−
      <td>Just like the Date Specifier the status specifier acts as a filter true or false <br />fields. Example of this would be the Active vs Inactive Customer.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Alternative Column Format</td>
 
−
      <td>Currently not in use.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Email Option Available</td>
 
−
      <td>This will give you the option to email report both in the Reports Module as well as<br /> report specific module when active.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Show on Module Print Menu</td>
 
−
      <td>When enabled it will, and you have the security clearance you will see the report under<br />the Print button found in any module. Note to determine which module a report will be <br />printed in is set by the Availability tab.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>This is a Service and Install<br /> Ticket</td>
 
−
      <td>Currently not used</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Allow Queries for this Report</td>
 
−
      <td>This allows you to setup your own query. This is always against the Master Table. This <br />also needs to be run in the Reports Module.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Allow Indexes Change</td>
 
−
      <td>In report where you are using grouping. You will be able to change what is the original <br />index to something else. Visible in Reports Module.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Allow Save Query</td>
 
−
      <td>This will allow you to save a query after its run. Note that you can run the query once,<br /> then uncheck it so that the query always exist.Done in Reports Module.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Allow on Print Package</td>
 
−
      <td>This will enable the report to show on Print Package for the module it is in.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Index Name</td>
 
−
      <td>The default index used when Printing a report that is using groups.</td>
 
−
    </tr>
 
−
</table>
 
−
 
 
−
 
 
−
 
 
−
<br>'''Details Specifiers'''
 
−
<br>The purpose of the detail specifier tab is to setup the pipes to other tables. This is done by connecting the Primary Key of the Master table, with the Foreign Key of Detail Table. As well as connect Details Detail table to the Detail table. Note: In report designer each table you choose will show up under the Data Pipes.
 
−
 
−
<br>'''Details -> Master'''
 
−
<br><table border=1>
 
−
    <tr>
 
−
      <td>Details Table</td>
 
−
      <td>This is where you set the table you will be adding to addition to the master table.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Details Index</td>
 
−
      <td>This is the Foreign Key inside the Details table that relates back to the master table.</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Master Table Linking Field</td>
 
−
      <td>This is the Index from the Master table you are using.</td>
 
−
    </tr>
 
−
</table>
 
−
 
 
−
<br>'''Details Detail-> Details Link'''
 
−
<br><table border=1>
 
−
    <tr>
 
−
      <td>Details Table</td>
 
−
      <td>This is the table that will be linked to the Details Table</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Details Index</td>
 
−
      <td>This Foreign Key found within the Details Detail table</td>
 
−
    </tr>
 
−
    <tr>
 
−
      <td>Detail Linking Field</td>
 
−
      <td>This is the field in the Details table that will be link from the Details Index.</td>
 
−
    </tr>
 
−
</table>
 
−
 
 
−
<br>'''Specified Links'''
 
−
<br>Once accept your link the new link will show up in the Specified links in the following format.
 
−
Details Table, Details Detail Table, Details Index, Master Index, Details Detail Index, Detail Linking Field.
 
−
 
−
'''Hints to Linking Reports'''
 
−
<br>One thing to know about linking reports is that you can bring in as many reports as possible. You are not limited one Details and Details Detail. Each entry will show up in the Specified Links.
 
−
 
−
Try to use the highest level table as the master table in relation to what you are looking for in your data. If your report is based off Service Orders, the master table should then be ServiceOrders. Also to note any filters applied to a report before processing is based off the Master table.
 
−
 
−
All tables have a UID attribute. This is the primary key for that table. Many tables have one than more foreign key. All Foreign key will have the word UID in there name. Example of this is that CustUID can be found in the ServiceOrders, thus you can connect Customers with ServiceOrders. When linking tables you will always want do this by UIDs.
 
−
 
−
The Master Table by default is the whole of the Report Document. Any reports with multiple entries in details table will need placed in a sub report. Good example of this with ServiceOrder and ServiceOrderMaterials. To see all your materials you will need to place your materials in a sub report.
 
−
 
−
Few tables can be linked in the details detail table. If you are unable to access any drop down, it is because this table is not a secondary table.
 
−
 
−
 
−
'''Titles'''
 
−
<br>To set up a report where you can change the title all you will need to do is make sure that label used in SME is pulling from the SystemsDefaults> ReportTitle. SME will always use the Default time unless it is changed in the '''Reports Module'''.
 
−
 
−
 
−
 
−
See ReportBuilder for information on the Report Builder tool.
 
−
You can also download a pdf called "Learn Report Builder" from here:
 
−
<br>http://www.digital-metaphors.com/download/pdf/RBuilder.pdf
 
−
 
 
−
== Report Builder Tutorial ==
 
−
 
 
−
SME uses a tool called Report Builder to customize the report/document forms.
 
−
 
 
−
<br>The tutorial, available from the following link will familiarize you with the Custom Report UI, form controls, data links, etc. The version implemented into SME does not include the entire range of functionality that is found in the tutorial. It will introduce you to the reporting controls, design user interface, and basic report modification functionality. Creating, duplicating, and/or modifying SQL queries to pull data for reports in SME is not covered in this tutorial.
 
−
 
 
−
<br><span>&nbsp;</span>"http://www.digital-metaphors.com/download/pdf/RBuilder.pdf"<span><span>
 
−
 
 
−
== Customizing Reports with Report Builder ==
 
−
 
 
−
 
 
−
This tutorial assumes that you are modifying an existing report, where the settings under Customize Report are correctly set. If you wish to modify those details, read Customizing Reports.
 
−
 
 
−
 
 
−
To access the Report Builder, go to Customize Reports under the Reports tab in SME and click the Open Report Designer button.
 
−
 
 
−
 
 
−
'''Adding New Text Fields'''
 
−
 
 
−
In this tutorial, the Standard Purchase Order report will have phone, fax, and due date fields added to it.
 
−
 
 
−
Step 1: making room for the new fields. Phone and fax information are only listed once per page, so they belong in the Header or Group Header. Drag the Group Header down to free up space. To move the headings for the details down, drag a box around them and drag them down to be right above the Group Header ribbon.
 
−
 
 
−
 
 
−
Step 2: adding new non-repeating fields. Phone and fax information can be found under the Customer table, in the Data Tree on the right side of the screen. Select the Customer table, then the Phone and Fax fields, and drag them onto an empty spot on the report.
 
−
 
 
−
 
 
−
Step 3: adding repeating fields. Because Due Dates show up on every item, that field belongs in the Detail tab. In this report, the details are in a SubReport. Click on the tabs on the bottom of the screen to move between the main report and subreports. The DueDate field is in the PurchaseOrders table, so select it then drag DueDate to where you want it.
 
−
 
 
−
Once you're finished arranging the text fields, save the report and make sure the Filename is specified as the new report file in the Details and Settings section of Customize Report.
 
−
 
 
−
 
 
−
'''Formatting: Page Breaks'''
 
−
 
 
−
This tutorial is useful for if you only want to print one item or one customer per page, and the report is not set to page break on a change in that field. Placing a field in either the header or group header space will result in only one value being displayed. Placing the field in the details space will display all values in the table.
 
−
 
 
−
To print one main field (customer, item, location, etc) per page:
 
−
 
 
−
#    Move the field you want to page break on to the Group Header. Right-click the Group Header ribbon and select Groups, or go to Report tab and click Groups.
 
−
#    Change Break On to the data field you want to page break on.
 
−
#    Check “Start new page” under On Group Change.
 
−
#    Click Ok.
 
−
 
 
−
 
 
−
 
 
−
 
 
−
== Company Reports ==
 
−
 
 
−
 
 
−
There are over 144 standard reports in SME.
 
−
 
 
−
To Access the entire list go to Reports> Print Reports.
 
−
 
 
−
Reports are listed by module.
 
−
 
 
−
 
 
−
 
 
−
== All standard reports in SME, listed by type==
 
−
 
 
−
'''Computer'''
 
−
 
 
−
None
 
−
 
 
−
'''Customer'''
 
−
 
 
−
<br>Standard Accrued Balance Report/Billing
 
−
<br>Standard Aging Report by Date Range
 
−
<br>Standard Batch Invoice
 
−
<br>Standard Billable Customer Report
 
−
<br>Standard Credit Report
 
−
<br>Standard Customer Contact List
 
−
<br>Standard Customer Equipment List
 
−
<br>Standard Customer Install History
 
−
<br>Standard Customer Label 5160-Billing
 
−
<br>Standard Customer Label 5160-Site
 
−
<br>Standard Customer Maintenance Expired
 
−
<br>Standard Customer Message Center
 
−
<br>Standard Customer Notes Report
 
−
<br>Standard Customer Open Deposits
 
−
<br>Standard Customer Report
 
−
<br>Standard Customer Service History
 
−
<br>Standard Customer SnapShot Report
 
−
<br>Standard Customer Statement
 
−
<br>Standard Customer Statement/Due Date
 
−
<br>Standard Customer SubContractor Report
 
−
<br>Standard Customer System Report Detailed
 
−
<br>Standard Customer System Report Summary
 
−
<br>Standard Customer Trunk Report
 
−
<br>Standard Customers By Name
 
−
<br>Standard Customers By Sales Person
 
−
<br>Standard Directions Report
 
−
<br>Standard Envelope Window Location
 
−
<br>Standard Labor Report, By Order
 
−
<br>Standard Maintenance Contracts Report
 
−
<br>Standard Open Invoice Reports
 
−
<br>Standard Order Material List
 
−
<br>Standard Past Due Notice
 
−
<br>Standard Payment Receipt
 
−
<br>Standard PM Planning List
 
−
<br>Standard Prepaid Hours Balance Report
 
−
<br>Standard Prepaid Hours Balance Summary
 
−
<br>Standard Prepaid Service Balance Report
 
−
<br>Standard Undistributed Payments
 
−
<br>Standard Warranty Expired
 
−
 
 
−
'''Direct Sales'''
 
−
 
 
−
None
 
−
 
 
−
'''Equipment'''
 
−
 
 
−
<br>Standard Equipment List by Site
 
−
<br>Standard Equipment List Excel
 
−
<br>Standard Equipment Spares by Site
 
−
 
 
−
'''Fixed Assets'''
 
−
 
 
−
Standard Fixed Assets
 
−
 
 
−
'''Install Order'''
 
−
 
 
−
<br>Standard Closed Order List
 
−
<br>Standard Closed Order Report
 
−
<br>Standard Install - Dot Matrix
 
−
<br>Standard Install Ticket
 
−
<br>Standard Report, by Order
 
−
<br>Standard Material Request, Install Order
 
−
<br>Standard Open Order List
 
−
<br>Standard Open Order Report
 
−
<br>Standard Open Order Report, No Due Date
 
−
<br>Standard Order Material List
 
−
<br>Standard Order Profit/Loss Report
 
−
<br>Standard Order Ticket
 
−
<br>Standard Order Ticket - Dot Matrix
 
−
<br>Standard Order Ticket - Order Item
 
−
<br>Standard Order Ticket - Summary
 
−
<br>Standard Order Ticket 1
 
−
<br>Standard Order Ticket Detailed
 
−
<br>Standard Order with Mat/Service
 
−
<br>Standard Packing List
 
−
<br>Standard Packing List Order Items
 
−
<br>Standard Sub Ticket - Order Item
 
−
<br>Standard Tech Order Report
 
−
 
 
−
'''Inventory'''
 
−
 
 
−
<br>Standard Inventory by Location Serial #
 
−
<br>Standard Horizontal Barcode
 
−
<br>Standard Inventory by Location QTF
 
−
<br>Standard Inventory Count Sheet
 
−
<br>Standard Inventory Items
 
−
<br>Standard Inventory Report
 
−
<br>Standard Inventory Summary Report
 
−
<br>Standard Inventory with Location Details
 
−
<br>Standard Vertical Barcode
 
−
 
 
−
'''Inventory Services'''
 
−
 
 
−
None
 
−
 
 
−
'''Inventory Transfer'''
 
−
 
 
−
None
 
−
 
 
−
'''Invoice'''
 
−
 
 
−
<br>Standard Accrued Balance Report/Billing
 
−
<br>Standard Accrued Balance Report/Site
 
−
<br>Standard Accrued Sales Tax Report
 
−
<br>Standard Aging Report by Date Range
 
−
<br>Standard All Cash Sales Tax Report
 
−
<br>Standard All Invoiced Orders-Compressed
 
−
<br>Standard All Invoiced Orders=Suppressed
 
−
<br>Standard All Invoiced Orders Detailed
 
−
<br>Standard All Invoiced Orders Summary
 
−
<br>Standard Batch Invoice
 
−
<br>Standard Bill History By Sales Person
 
−
<br>Standard Bill History By Service Code
 
−
<br>Standard Billing History Column
 
−
<br>Standard Cash Excise Tax Report
 
−
<br>Standard Cash Sales Tax By Codes
 
−
<br>Standard Cash Sales Tax Report
 
−
<br>Standard Credit Report
 
−
<br>Standard Customer Maintenance Expired
 
−
<br>Standard Customer Statement
 
−
<br>Standard Customer Statement/Due Date
 
−
<br>Standard Incurred Charges Report
 
−
<br>Standard Invoice - Order Items
 
−
<br>Standard Invoice Profit/Loss Report
 
−
<br>Standard Invoice Registry
 
−
<br>Standard Invoices Breakdown
 
−
<br>Standard Itemized Invoice
 
−
<br>Standard Job Cost Report
 
−
<br>Standard Labor Report, by Order
 
−
<br>Standard Open Invoice Report
 
−
<br>Standard Open Invoices Summary
 
−
<br>Standard Open Order List
 
−
<br>Standard Open Order Report
 
−
<br>Standard Open Order Report, No Due Date
 
−
<br>Standard Order Materials List
 
−
<br>Standard Order Profit/Loss Report
 
−
<br>Standard Order Ticket
 
−
<br>Standard Order Ticket - Dot Matrix
 
−
<br>Standard Order Ticket - Summary
 
−
<br>Standard Past Due Invoice Date Cutoff
 
−
<br>Standard Past Due Notice
 
−
<br>Standard Past Due Summary
 
−
<br>Standard Payment Receipt
 
−
<br>Standard Prepaid Services Applied, Inv
 
−
<br>Standard Sales History Report
 
−
<br>Standard Sales Tax Liability-Accrued
 
−
<br>Standard Sales Tax Liability-Cash
 
−
<br>Standard Services Sold
 
−
 
 
−
'''Issues'''
 
−
 
 
−
<br>Standard Issues Report Summary
 
−
 
 
−
'''Maintenance Contracts'''
 
−
 
 
−
<br>Standard Maintenance Contracts Report
 
−
 
 
−
'''Package'''
 
−
 
 
−
<br>Standard Package List
 
−
 
 
−
'''Parts'''
 
−
 
 
−
<br>Standard Parts Report
 
−
 
 
−
'''Payment'''
 
−
 
 
−
<br>Standard Credit Report
 
−
<br>Standard Payment by PayType
 
−
<br>Standard Payment Receipt
 
−
<br>Standard Payments
 
−
<br>Standard Payments by Sales Person
 
−
<br>Standard Prepaid Services Applied, Inv
 
−
<br>Standard Undistributed Payments
 
−
 
 
−
'''Projects'''
 
−
 
 
−
None
 
−
 
 
−
'''Proposal'''
 
−
 
 
−
<br>Standard Bid and Quotes
 
−
<br>Standard Open Proposal Activity by Cust
 
−
<br>Standard Open Proposal Activity by Date
 
−
<br>Standard Order Item Proposal
 
−
<br>Standard Proposal Profit/Loss Report
 
−
 
 
−
'''Purchase Orders'''
 
−
 
 
−
<br>Standard Order JIT Report
 
−
<br>Standard Order JIT Report by Order
 
−
<br>Standard Purchase Order
 
−
 
 
−
'''Recurring Invoices'''
 
−
 
 
−
<br>Standard Recurring Billing Report
 
−
<br>Standard Recurring Invoice Profit/Loss
 
−
 
 
−
'''Recurring Orders'''
 
−
 
 
−
None
 
−
 
 
−
'''Returns'''
 
−
 
 
−
<br>Standard Return Ticket by Vendor
 
−
<br>Standard Return Ticket by Ship From
 
−
 
 
−
'''Rolodex'''
 
−
 
 
−
Standard Contact List
 
−
 
 
−
'''Sales'''
 
−
 
 
−
<br>Standard Payments by Sales Person
 
−
<br>Standard Sales Leads
 
−
 
 
−
'''Sales Help Desk'''
 
−
<br>'''Standard Sales Knowledge Base'''
 
−
 
 
−
<br>'''Scheduled Services'''
 
−
 
 
−
<br>'''None'''
 
−
 
 
−
<br>'''Service Order'''
 
−
 
 
−
<br>'''Standard Closed Order List'''
 
−
<br>'''Standard Closed Order Report'''
 
−
<br>'''Standard Customer Maintenance Expired'''
 
−
<br>'''Standard Job Cost Report'''
 
−
<br>'''Standard Labor Report, by Order'''
 
−
<br>'''Standard Material Request, Service Order'''
 
−
<br>'''Standard Open Order List'''
 
−
<br>'''Standard Open Order Report'''
 
−
<br>'''Standard Open Order Report, No Due Date'''
 
−
<br>'''Standard Order calls - Summary Format'''
 
−
<br>'''Standard Order Material List'''
 
−
<br>'''Standard Order Profit/Loss Report'''
 
−
<br>'''Standard Order Ticket'''
 
−
<br>'''Standard Order Ticket - Dot Matrix'''
 
−
<br>'''Standard Order Ticket - Order Item'''
 
−
<br>'''Standard Order Ticket - Summary'''
 
−
<br>'''Standard Order Ticket 1'''
 
−
<br>'''Standard Order Ticket Detailed'''
 
−
<br>'''Standard Order with Mat/Service'''
 
−
<br>'''Standard Packing List'''
 
−
<br>'''Standard Prepaid Service, Service'''
 
−
<br>'''Standard Service - Dot Matrix'''
 
−
<br>'''Standard Service Ticket'''
 
−
<br>'''Standard Sub Ticket - Order Item'''
 
−
<br>'''Standard Tech Order Report'''
 
−
 
 
−
<br>'''Tech Help Desk'''
 
−
 
 
−
<br>'''Standard Tech Knowledge Base'''
 
−
 
 
−
<br>'''Technician'''
 
−
 
 
−
<br>'''Standard Closed Order Report'''
 
−
<br>'''Standard Labor Report, by Tech'''
 
−
<br>'''Standard Labor Utilization - Actual'''
 
−
<br>'''Standard Labor Utilization - Estimated'''
 
−
<br>'''Standard Open Order Report'''
 
−
<br>'''Standard Open Order Report, No Due Date'''
 
−
<br>'''Standard Tech Order Report'''
 
−
 
 
−
<br>'''User'''
 
  
−
<br>'''Standard Activities Report'''
+
[[Duplicating Standard Reports for Custom Use]]
−
<br>'''Standard SQLink Name Length Checker'''
 
  
−
<br>'''Vehicle'''
+
[[Customizing Reports]]
  
−
<br>'''Standard Vehicle Fuel Receipts'''
+
[[Report Builder Tutorial]]
−
<br>'''Standard Vehicle List'''
 
−
<br>'''Standard Vehicle Maintenance History'''
 
−
<br>'''Standard Vehicle Maintenance Scheduled'''
 
−
<br>'''Standard Vehicle Snapshot
 
−
<br>'''Standard Vehicles'''
 
−
<br>'''Standard Vehicles Tags Due'''
 
  
−
<br>'''Vendor'''
+
[[Company Reports]]
  
−
<br>'''Standard Vendor Report'''
+
[[Module Reports]]

Please note that all contributions to High5Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see High5Wiki:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)
Retrieved from "https://www.high5software.com//mediawiki/index.php?title=Reporting"