Product Release: 1205

Aqilla – Microsoft Excel Add-in

1. The add-in now supports two forms of the purchase invoice. If you currently only use the “simple” purchase invoices, importing invoices with the PurchaseInvoice2 document with include the imported document in the Purchase Invoice group of documents instead of Purchase Invoice M/C.
2. The behaviour of uploading documents through the add-in has been changed. Documents will now only be added if all documents selected for upload are valid. This change will help ensure that invalid documents are not missed and the documents will be added in the sequence that they were defined in the spreadsheet.

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.

Financial Reports

The revaluation option within column definitions has been enhanced to enable you to specify different Currency Rate Types. For example, different currency rates may be used for entering transactions and reporting.

Posting Realised Currency Exchange Differences

The process of posting exchange differences in Transaction Matching, Payments, and Debits has been enhanced as follows:

1. Exchange difference transactions are now allocated their own unique references (by default prefixed by “FX”).
2. Exchange difference transactions are created strictly one per invoice that is paid and copies all analysis information from the original invoice to the exchange difference transaction with the exception of the transaction date which is the payment date.
3. Because of the strict matching to invoices, it is now necessary to match any manually paid currency invoices through the Transaction Matching function.