To support these enhancements users need to download the latest copy of the Aqilla add-in. If you do not have the password for downloading, contact Aqilla support at support@aqilla.com for details of the user name and password. The process of posting exchange differences in Transaction Matching, Payments, and Debits has been enhanced as follows: Month or year end doesn’t have …

Olympic Release

The Miscellaneous Document has been enhanced so that the value columns are now no longer reset after the upload to remove the signs. The displayed Credit/Debit column has also been removed. In line with the other document types, only the new document reference will be returned if the document has been successfully uploaded. This change now makes it easier to …

Two auto-expansion options have been added to provide better control of how the Financial Reports are displayed. A new configurable process has been added to calculate and post unrealised currency exchange differences To use this process users need to identify which currency is to be re-valued, at the same time nominating an appropriate Unrealised Exchange Gain and Loss account(s). Under …

A new function has been added to the Configuration tab to turn on auditing of data changes to any reference data or document. When switched on all changes to the selected entities are logged, detailing who changed what and when. These changes may be viewed by the Audit Viewer found under the Enquiries tab. When applied to documents, the State …

The Account and Ledger Enquiry functions previously allowed access to all information stored in the ledger to anyone who had access to these functions. It is now possible to define automatic filters to individual users to prevent them from seeing specific data. A simple example of preventing a user from viewing any Balance Sheet accounts is shown below. The same …

A new function has been added under the Journals tab to enable corrections to be made to journals that have been posted to the ledger. The function requests a Journal Number and displays the details of the transactions within that journal. The user is able to make amendments to the fields shown as editable and Post the changes back to …

Calculated Columns have been enhanced to enable users to create their own calculated columns. To do this, users simply select a Column Type “Calculation” and in the Formula field specify the calculation in terms of the other columns defined in the report. It is straightforward to use, and a calculation may include other columns in the report and constants using …

The layout of the Excel reports exported from the Financial Reports have been improved to set the column widths more accurately, thus making the reports more readable without having to reformat the columns within Excel. Within the Configuration of Financial Reports it is now possible to copy a whole report definition. This is particularly useful if you wish to create …

A number of enhancements have been made to the processing of payments to help minimise errors when making the payment selections. The improvements are as follows: An additional payments file option has been added to support Barclays Bank “Sage” format. The format can be selected by a new option (Payments Export Format) within the Company Information function found under the …

Please note that the Aqilla Add-in is not currently supported on the 64bit versions of Excel. This is due major differences in the way web services are handled between the 32bit and the 64bit versions of Excel. Month or year end doesn’t have to be slow or difficult. Here is a best practice guide to the busiest times of the …