Reports
DTN TABS provides a wealth of reports that can help you zero in on the information you need, when you need it. The types of reports you can create include:
Most DTN TABS reports can be exported to an Excel or an ASCII text file format for emailing or downloading into a back-office application.
This saves time in not having to re-enter critical information and provides a method for making sure all systems are in sync. Other reports, such as the Real Time Transaction Report, are strictly for online viewing.
- Customer Reports:
- Provides reports to search for shipments, orders and contract transactions. These are only visible if using contracts.
- BOL Reports:
- Provides information about BOL activity for a given time.
- Allocation Reports:
- Tracks allocations for a specific terminal or terminal group and a specific consignee or consignee group.
- Setup Reports:
- Summarizes database information for terminals, terminal groups, consignees, consignee groups, carriers, products, and users. The information can be used to verify that your DTN TABS database has been set up correctly.
- Forecast Reports:
- Specifies information on forecasts generated, changed and historical allocation and forecasting.
- Other Reports:
- Provides information on Security Audits, Alerts generated, SPLC Master Report, Export Feedback Report, Master Data Audit log, ADMLOD Report, Supply Events Report and the Master Data Terminal Audit report.
- Audit Log Reports:
- Tracks terminal edits for a given period, provides information on Prepayment Audit Report and Tax Audit Report.
Most DTN TABS reports can be exported to an Excel or an ASCII text file format for emailing or downloading into a back-office application.
This saves time in not having to re-enter critical information and provides a method for making sure all systems are in sync. Other reports, such as the Real Time Transaction Report, are strictly for online viewing.
How to Open a Report
Here’s how to open a report:
- From the Reports menu, select the report you want to run. This page lists the reports that are available through DTN TABS.
OR
- From the BOLS menu select Download or History to view those reports.
- Select the desired report and click to open it.
Select Report Criteria
Once you have opened the desired report, use the upper pane of each report page to specify the criteria needed in the report. Remember that you are searching for records to include in the report when specifying the criteria.
For example, the Report Criteria pane of the Admin Activity Report lets you specify a start date and time, as well as an end date and time. You can include or exclude records by file name, transaction type, user name, and action results.
View Report Results
After specifying criteria for your report, click View Report to view your report.
The system returns a list of records that matched the specified report criteria.
You can view these results online to verify that the information is correct. If you need to make changes to any record, return to the window where that record was created. For example, if you wanted to correct a seller consignee address, you would need to return to the Seller Consignee page.
In most cases, click 
to export the report to an Excel file that can then be downloaded into a back-office application. See the Run and Export a Report File section in this manual for more information on exporting a report file.
Run and Export a Report File
Reports can be exported to Comma Separated Values (CSV) format commonly used by Excel.
Note: Not all reports can be exported.
- Select the report you want to run and export. The corresponding Report Criteria panel opens.
- Enter the report criteria you want and click
. The system returns the Report Results panel with records that matched your criteria. - Review the report online.
- Select . The File Download window displays.
- Select one of the following options:
Opens the file Online
Provides a Save As box to specify a filename, file type and location for the export file.
Cancels the action.