The Application Manager is a sophisticated object-oriented framework on which all application components have been created. Features include: user configurable hierarchical application navigation tree, user security control, report management, robust error handling, background processing, and distributed processing.
|User Defined Menus||
The unique application navigator is used to open windows, reports, report configurations, lookup windows, and external applications. All items which are available to the user are organized in a hierarchical tree containing folders which are used to group related items. Navigation trees can be shared among groups of users or can be specific to a single user. Each user can have their own view of the application with the windows and reports which they actually use every day. The organizational structure of the navigation tree can be easily modified by the system administrator. A complete set of standard navigation trees is included with the system to serve as templates for creating custom navigation trees for different groups of users.
Users or groups can be assigned specific permissions for application objects such as windows, reports, or properties. Users can belong to any number of groups from which they inherit permissions. Each application object can define up to 32 permission flags to control specific actions available to the user. For example, the ability to select records, insert records, update records, delete records, and post transactions. Permission flags can also be used to limit the ability of users to view or edit specific fields.
|Reporting System||The system uses a single report management system for all types of reports including financial, SQL database, interactive, and custom. Any number of report preview windows can be opened simultaneously. Powerful drill-down inquiry features are available in many reports, including user defined financial statements. Print preview mode allows users to see how the report will actually appear on printed pages. Reports can be previewed on screen, printed, sent by e-mail, faxed or saved to a file in a wide variety of formats including: Comma separated values, dBASE, Data Interchange Format, Microsoft Excel, Hyper Text Markup Language, Powersoft report, SQL Syntax, Tab-separated columns, Lotus 1-2-3, and Windows metafile format.|
|Control Report Output To Specific Printers||System allows specific reports to be designated to print on specific printers such as having pick tickets print in the warehouse, or checks printed in the accounting department.|
|Report Configurations||Report configurations including report parameters, query parameters, sorting and filtering options can be saved in the database for reuse at a later time. Report configurations can be placed on the application navigator to run a report with a specific configuration.|
|Query by Example||The query by example (QBE) grid can be used to limit the records which are to be included in the report. This can significantly reduce the amount of data which must be transferred from the database to a client workstation. Database sorting options can be specified to perform sorting of data at the database server for maximum performance. The grid allows both simple and complex criteria to be entered including: a specific list of values, a range of values, AND/OR boolean operators and string pattern matching. The query parameters can be saved as part of the report configuration for subsequent use.|
|User Defined Report Sorting||Data which has been retrieved from the database can be sorted at the workstation. The default sort order of rows can be changed by the user in seconds. The sort order can be based on a specific column of the report or a complex expression. The sort definition can be saved as part of the report configuration.|
|User Defined Report Filtering||Data which has been retrieved from the database can be filtered at the workstation using a filter expression. The filter definition can be saved as part of the report configuration.|
|Printing Report Groups||Reports and report configurations which are commonly printed at the same time can be defined as a group and printed with one click.|
|Custom Reports||Existing reports can be modified and new reports can be created using powerful and easy to use reporting tools such as InfoMaker, PowerBuilder, and any 3rd party reporting/analysis tool which is capable of accessing a database server using an ODBC connection or database specific drivers. Extended attributes which are stored in the database provide labels/headings for all database tables and columns, formatting styles and column size information. Tables and columns have been given long descriptive names to make it easy to locate the data for a report. A variety of report styles can be combined in a single report including: table, grid, free form, graph, group, cross tabulation, and many others.|
|Notes and Attachments||Store all related notes and document files such as contracts, letters, spreadsheets, pictures, scanned documents as attachments. All attachments are stored in the database for fast access and can be linked to any record in the system such as customer, vendor, item, etc...|
|Cross Reference||Any record in the database can be cross referenced to any other record. For example, a cross reference from one customer to another customer can be used to specify who referred the customer. Cross references between a shipping method and vendors who provide shipping services.|