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 …

This edition of WEB 2.0 Accounting looks at the key issues and areas that can be improved upon to alleviate the problem of a slow month end close and provides 5 tips to facilitate a quicker and more efficient month end. Read this newsletter to find out how to transform your finance department. Thank you for downloading our Newsletter.

See how the constant evolution of Aqilla is providing functionality that make business’ better including: posting documents from document enquiries, value checking, multi-recipient emails, simplified transactional processing and configurable financial reports. Read this newsletter to find out how to transform your finance department. Thank you for downloading our Newsletter.

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 …