Reporting
FIVE DATA EXPORT OPTIONS
- Customizable forms for work order printing, bills of lading, truck tickets and more come standard.
- Built-In Reports – these reports are part of R.I.M.S. and each one is a perfectly placed tool facilitating the use of R.I.M.S.
- Top Customer Report – this is more than just a report. This is an advanced data-mining tool giving you access to vital and comprehensive sales, workflow and management data in real-time.
- Ad Hoc Reporting Tool – allows the most novice user to write all manner of reports, giving you extreme flexibility in how you use R.I.M.S.
- Custom SQL Command Tool – allows a more experienced user to get any piece of information out of R.I.M.S.
CUSTOMIZABLE FORMS
R.I.M.S. comes with many forms you expect like ‘Work Order’, ‘Bill of Lading’, “Arrival Inspection’ and more.
Each of these is designed to fit the type of inventory being handled on a specific work order or type of inventory being handled.
Each of these can be customized to you specific needs.
BUILT-IN REPORTS
Reports include:
- Inventory Report
- Available
- Summary
- Detail with pending working orders optional
- Inventory Information Reports
- Information Report
- Arrival Notice
- Arrival Inspection
- Release Inspection
- Inventory Frequency Reports
- Loading Dispatch Reports
- Summary
- Activity
- Loader Breakdown
- Work Orders
- Work Order Checking & Exceptions Report
- Rate Recap Spreadsheet
- Daily Rating Recap Report
- Work Order and Inventory Batch Processing Report
- Daily Batch Recap Report
- Documents Not Scanned (Exception) Report
- Batch Invoice Report
- Invoices
- Payer Invoice Distribution Report
- Invoice Transfer Batch Report
- On-screen
- Paper
- Excel
- Word
- HTML
- CSV
- XML
- and more.
TOP CUSTOMER REPORTING
Selection Criteria include:
- Query Summary or Detail information from Invoices or Work Orders.
- Date Range.
- One or more Inventory Types.
- Dry, Liquid, Gas.
- Handling and/or Storage.
- One or more Terminals.
- One or more Shippers.
- One or more Sales People.
- One or more Customer Regions.
- One or more Customer Representatives.
Presentation Options Include:
- Summary columns include Revenue, Work Count, Work Order and totals.
- Detail columns include 30 key fields from the database that you can pick and choose.
- Group Columns by: Monthly, Quarterly, Yearly and Terminal.
- Group Rows by: Shipper, Terminal, Transaction Type, Sales Person, Customer Region, Customer Rep.
- Include Prior Year(s) and include $ change and % change columns from prior year to present.
AD HOC QUERIES
CUSTOM SQL COMMAND TOOL
R.I.M.S. has a unique feature that allows you to create custom SQL Select commands and store these “queries” or “reports” in the database. This requires a little programming skill and it is not for everyone. However, our support staff are trained in its use and can easily provide these as needed.
This provided unrestricted access to all the data on the fly. And the results of any report can be exported to Excel with the click of a button.
Additionally, our support desk finds it a useful tool to assist customers with a “report” they may need in a hurry and may only use once or twice. Our support staff knows the R.I.M.S. database making this tool is easy for them to use.
