Most reports in BankTEL’s Accounts Payable can be “modified/customized” in order to include only the information desired by the user.
However, if no modifications are desired to a selected report then a user can simply “run” a report by selecting the menu bar option titled Create/Refresh Report shown below.
If modifications are desired this can be done by selecting the menu bar option titled Modify Report located on each report. This option can be seen below.
Selecting this option will produce a popup menu that allows users to modify the report in many ways. This can be done by using the three tabs seen below. While the informational fields available on each report will vary the options available will not.
The first tab titled Field Selection can be used by the user to pick and choose what fields should be included on the report. If all fields are desired then the selection titled Field can be selected. This selection can also be used to unselect all fields.
REPORTS how to use
The second tab titled Sort/Options can be used to select fields in which the report should be sorted by. The ranking of the sort fields selected rank from top to bottom. This means that the field selected in Sort Field 2 will be sorted within the field selected in Sort Field 1.
A description of each available option can be seen below.
REPORTS how to use
SUBTOTAL DESCRIPTION COLUMN When subtotals are included in a report this selection indicates which column in which the subtotals will be produced beneath.
SORT FIELD Use these selections to sort a report. The
ranking of the sort fields selected rank from top to bottom.
REVERSE ORDER By default all reports are sorted in ascending order (lowest to highest). By selecting this option reports will be sorted in descending order (highest to lowest).
SUB TOTAL When a sort field is selected checking this box
will create a subtotal for that field each time the sort field changes.
PAGE BREAK Use this option to create a page break each
time the sort field selected changes. This option is only applicable when a user intends on printing a paper copy of the report.
REPORTS how to use
REPORT TYPE When summary is selected this indicates that
the report should only create a summary record for each sort field selected. If no sort fields are selected then only a total count for each record in the report will be shown.
When detail is selected this indicates that the report should be created and include detailed information for each record.
REPORT NAME The report name is included in the report
header. If the default name is not desired a user can simply alter it here.
REPORT TITLE By default no Report Title is included. If a user wishes to include a Report Title they can key it here. This information will be seen in the report header.
PRINT HEADER Be default this option will be selected.
However, if a user desires not to have a header included on a report this option can be
unselected.
PRINT FOOTER Be default this option will be selected.
However, if a user desires not to have a footer included on a report this option can be unselected.
The last tab titled Filter/Query can be used by a user to indicate that only information matching particular criteria be included on the report.
REPORTS how to use
Using the operator dropdown (equal to , greater than, etc.) a user can select how the fields should be compared for filtering/querying.
When a field and operator are selected the button titled Add Filter should be selected to add the filter/query.
Multiple filter/queries can be selected.
The example below shows a filter/query in which a report should only include vendors in the state of MS that have been paid over $10,000 in the current year.
REPORTS how to use
Filters/Queries can be removed from a report by simply right clicking on a filter in the list and selecting to delete it.
This can be seen in the example shown below.
REPORTS how to use
Once a modifications have been made to a report these changes can be incorporated by simply exiting the
Modification popup. Shown above and then selecting to Create/Refresh the report as shown in the example below.
Selecting this option will load the information onto the screen. At this point a user has many options.
• If modifications were made to the report and it is desired to have these changes saved in the form of a new report that can be accessed at a later time this can be done by selecting the option titled Save Modified Report as shown in the example below.
When the report is saved users have the ability to title the report as needed. These reports can then be recreated at a later date by selecting them from the report list. When modified reports are created they are associated with the category of report in which they were created. This simply means that if a modified report was created under Vendors then this modified report would only show when Vendors is selected in the future.
This can be seen in the examples shown below. First the user would select to run Vendor reports from the Accounts Payable Main Menu.
REPORTS how to use
In the second example, shown below the user would be prompted with a list of vendor reports and the modified report created would be noted with an “X” in the column titled Modified. Please note that multiple modified reports can be created.
So in this example a modified report was created that only list YTD (Year to Date) purchases for vendors.
However, if a user were to select a different category of report above, such as Vendor Contracts, then the modified report shown below would not be seen in the report list.
REPORTS how to use
• Another option would be to Print/Export the report for easier viewing. This can be done by selecting the menu bar option titled Print/Export Report as shown below.
Once this option is selected a user will be shown a print preview of the report. An example of this is shown below.
A listing of the available options is shown below as well as details of the options.
PRINT Allows a user to print a paper copy of the
report.
EXPORT/SAVE Allows a user to export a copy of the report to
any of the following file types :
• Excel
• CSV
REPORTS how to use
• HTML
• XML
• TAB
PAGE SETUP Allows a user to edit items such as :
• Page Margins
• Orientation (Landscape / Portrait) PRINT SCALING Allows a user to alter the view of the report to
the following :
• Original
• Percentage
• Fit To Page
ZOOM Allows a user to zoom in or out on the report
that has been created.
• Users can also continue to modify the report.