Example 1
Experts in building management reports using Crystal
We have many years experience building customised crystal reports for our clients and not necessarily on our mainstream products, in fact we can build reports on anything that has a database or ODBC connection.
Please see below some more generic reports available for purchase. If you run, for example, Sage Pastel Partner Accounting and can provide us with remote access to your server, we can deliver the crystal report you require and map it to your company database. Please contact us at sales@crestsoftware.com.au if you have any questions.
Crystal Reports for Sage Pastel Partner Accounting
Please contact us if you are interested in purchasing any of these reports. You will need Crystal Reports Professional V11 onwards.
Credit Control Report
|
The graph shows the
history of invoices and the
time in days taken to pay in full - This is useful for
spotting trends in customers payment habits. If an invoice
is part paid first, then the report chooses the final
payment date for calculating the days taken to pay.
|
Cost- $400 plus GST |
Check for different inventory groups across store locations.
|
If you run Pastel Partner with an integrated inventory in a multi-stores
environment, then you often need to check that your stock has the same inventory groups across all stores, especially if you value you
your inventory based on inventory groups. This check report will only
list stock items that have more than one distinct count of inventory
groups, across your stores. You can then correct the data in Partner
and re-run on a regular basis.
|
Cost- $150 plus GST |
Printing invoices in customer order.
|
If you prefer to send out invoices at the end of each month to your customers, Pastel can print these invoices but in invoice number order. This Crystal report prints all unprinted invoices in customer order making it very easy to collate and send out your invoices.
|
Cost - $400 plus GST
(plus further formatting if required) |
Sales Analysis - Sales by Product Category
|
This report allows you to select a number of months in the current year e.g. Oct, Nov, Dec and will show previous year's comparisons. Qty, Sales, Cost, Profit and GP % are shown. If you are choosing a select number of month's then the previous year will show the equivalent sales allowing you to easily see whether you are achieving better or worse sales in that period. Individual periods sales performance are indicated by a green tick or a red cross.
|
Cost - $500 plus GST
(plus an hour per year
due to new yr formulas) |
Sales Analysis - Sales by Customer
|
This report allows you to select a customer code range and a number of months in the current year e.g. Oct, Nov, Dec and will show previous year's comparisons. Qty, Sales, Cost, Profit and GP % are shown. If you are choosing a select number of month's then the previous year will show the equivalent sales allowing you to easily see whether you customers are achieving better or worse sales in that period. Individual periods sales performance are indicated by a green tick or a red cross. This report can help indicate whether a customer is purchasing from your competitors.
|
Cost - $500 plus GST
(plus an hour per year
due to new yr formulas) |
Sales Analysis - By Customer by Product Category
|
This report allows you to select a customer code range, a product category range and a number of months in the current year e.g. Oct, Nov, Dec and will show previous year's comparisons for each Category only. Qty, Sales, Cost, Profit and GP % are shown. If you are choosing a select number of month's, then the previous year will show the equivalent sales allowing you to easily see whether your customers are achieving better or worse sales in that period for each Category. Note - There are grand totals due to the nature and functions built in the report. Customer Category sales performance is indicated by a green tick or a red cross. This report can help indicate whether a customer is purchasing certain product lines from your competitors.
|
Cost - $500 plus GST
(plus an hour per year
due to new yr formulas) |
Intelligent Reorder and Stock Holding Report
This report allows you to select a customer code range, a product category range and a number of months in the current year e.g. Oct, Nov, Dec and will show previous year's comparisons for each Category only. Qty, Sales, Cost, Profit and GP % are shown. If you are choosing a select number of month's, then the previous year will show the equivalent sales allowing you to easily see whether your customers are achieving better or worse sales in that period for each Category. Note - There are grand totals due to the nature and functions built in the report. Customer Category sales performance is indicated by a green tick or a red cross. This report can help indicate whether a customer is purchasing certain product lines from your competitors.
Crystal Reports for Tranman Fleet Management Software
As standard Crest Software Solutions provides all Tranman Series 7 customers with the following reports written in Crystal Reports. They provide all the key management and performance information needed for the fleet management industry.
These reports can be further enhanced or adapted to suit your needs.
Please note that some reports may not be useful if you do not use the related Tranman Series 7 Module or necessary functionality. The final deployed reports list may change slightly.
Accident Management:
Accident Analysis by Division or Department and Time Period |
Accident Analysis by Model |
Accident Analysis by Model and Division or Department |
Accident Analysis by Reason |
Accident Analysis by Use |
Accidents by Division or Department and Driver Age |
Administration:
CO2 Emissions Report |
Establishment by Class |
Establishment by Operator |
Establishment by Operator and Class |
Fleet List by Operator or Department |
Fleet List by Vehicle Class |
Replacement Schedule by Operator or Department |
Replacement Schedule by Operator or Department |
Vehicle Maintenance History Record |
Cost Analysis:
Age and Maintenance Cost Analysis by Vehicle Class |
Life Running Cost Per Kilometre by Class |
Life Running Cost Per Kilometre by Operator |
Annual Running Cost per Kilometre by Class |
Annual Running Cost per Kilometre by Operator |
Profit & Loss by Workshop |
Profit & Loss by Repair Class |
Job Invoices by Fleet Number |
Costs Report by Operator |
Costs Report by Vehicle Class |
Maintenance Management:
Fitter Analysis - Recorded vs Charged |
In Progress Jobs by Age |
In Progress Jobs by Operator |
In Progress Jobs by Repair Class |
Productive Fitter Hours by Fitter |
Productive Fitter Hours by Week |
Monthly Fitter Hours Report by Fitter |
Monthly Fitter Hours Report by Month |
Job Costs by Reason |
Outstanding Recalls Report |
Repair Type Analysis by Class |
Recorded vs Charged by Operator or Department |
Recorded vs Charged Hours by Workshop |
Service Scheduling:
Service Due Memo |
Service Due Report |
Service Schedule Planner |
Operational Equipment:
| |
Operational Equipment Service Schedule |
|
Stores:
All Orders Analysis Report |
Outstanding Orders Report |
Frequently Fitted Parts by Part |
Frequently Fitted Parts by Vehicle |
Supplier Turnover Analysis |
Top 10 Suppliers |
Stock Valuation at a Given Date |
Slow Moving Stock Analysis |
Stock Valuation by Part No |
Stock Valuation by Repair Type |
Stock Valuation by Main Supplier |
Stock Valuation by Location |
Fuel Management:
Annual Litres per 100K Performance by Vehicle Class |
Annual Litres per 100K Performance by Operator or Department |
Fuel Internal vs. External by Department |
Fuel Usage by Operator (detailed) |
Fuel Usage by Operator (summary) |
Short & Long Term Hire:
Hire Utilisation Analysis |
Ongoing Hire Contracts |
Hire Contract Type Analysis |
| |
Hire Invoice Report |
|
|
