Query, Reporting & Search - Aqilla provides a flexible tool for the querying data held within the system. Document views may be created at both a summary and detail level of each of the source document types and ledger transactions. Queries can be constructed to view Sales Invoices, Purchase Invoices, Expense Sheets, etc. showing a summary view based on one or more fields that have been selected to summarise by and more often than not making the requirement to print hard copy reports unnecessary.
The summary views can be expanded into details to show what transactions make up that summary (Drill Down). Similar views can be constructed for the ledger transactions enabling queries by journal, transaction, account, etc.
These views also provide intelligent drill-down capabilities so that information may be examined in different dimensions. For example from an account enquiry, the user could select the journal number to display a journal enquiry for the selected transaction or a transaction enquiry by selecting the transaction reference.
As is the case throughout the rest of Aqilla, column data can be sorted on the fly in ascending, descending and entry sequences.
Reporting - Reports may be viewed directly in a web browser (or through a web service) and can contain both summary and detail views. If a hard copy report is required, the system can generate its output as a PDF file, which can be printed, emailed as an attachment, or exported to a formatted Microsoft Excel spreadsheet or CSV file.
Each report can access a set of report profiles that stores the users individual selection; e.g. whether the un-posted journals are to be included, and details of the columns etc. These profiles can be specific to the user, and be added to, deleted or modified as required. Profiles may also be made available globally but these may not be modified.
In order to assist in efficient and fast processing of documents, Aqilla has Smart-Search capabilities implemented throughout. When typing data into any Smart-Search field, the system will automatically generate a drop down list of records that includes matching information. Continuing to type will focus the results until the correct item is ultimately selected from the drop down.
Smart-Search enables you find information quickly and efficiently, reducing errors in the preparation of documents.
Integration - Aqilla uses web services technology to expose and exchange often used business functionality for direct application-to-application interaction, in the form of processes, messages, or documents.
All web services are highly interoperable and re-usable and there is an increasing number of such services in the public domain designed to provide information from up to date currency rates through identification authentication to consignment shipment status and the systems makes good use of these where relevant.
In addition to all the financial reports in the system being viewed directly via the web browser; any of the data in the system may be published using a web service in summary and detail forms and from here shared, processed (with full validation still being managed by Aqilla), printed, output to PDF or emailed as an attachment.
Furthermore all data entered into the system may also be imported using a web service. This approach supports the entry and amendment of source documents; the updating of status information as well as the entry and amendment of reference data.
Integration with Microsoft Excel - One way that the system exploits these web services is through the use of the Microsoft Excel Add-in. With this add-in installed, the user may very simply analyse live data, update reference data or import transactional data from an Excel worksheet.
Business Intelligence Built In - The Aqilla Home Page features as standard a selection of Smart-KPIs (to track financial and non-financial metrics). These define and aid the measurement of progress against operational and strategic goals.