Product Release 2021.06

Extended support to include maintenance of “Super Entities” using the Aqilla Microsoft Excel Add-in and via the API plus more effective debt collection support.

June 2021 –  Mid-Summer Release Brings Extended Support For “Super Entities”


In the Spring of 2021, we introduced support for a series of three additional, user-definable, “Super Entity” types in Aqilla with the ability for customers to configure additional information specific to that type of entity.

For example, if you require Contract information to be captured, you can have one of the Super (customisable analysable) Entity types enabled and named “Contract”. Additional information can then be configured with the Attribute Wizard such as Contract Owner (text), Start Date (date), End Date (date), and Contract Value (value). 

With this latest release, we have extended support to include maintenance of such “Super Entities” by way of the Aqilla Microsoft Excel Add-in and the API plus some enhancements to support more effective debt collection using the Statement of Accounts function.

The principal enhancements in version 2021.06 are as follows:


1.  Aqilla Super Entities – Excel Support

The new Super Entities are now fully supported in the Aqilla Excel add-in (and the Aqilla API). Once a Super Entity has been configured in Aqilla, the data relating to that entity can be maintained using the Excel add-in like any other entity such as account, project, and asset.

Extracting data from Aqilla using the “getAnalysisEntities” function


The first parameter is the name of the Super Entity, in this example “Contract”. The second parameter is optional and can be used to filter out a subset of records by specifying the initial characters of the value of the Name, Code, Description or Text1 to Text10.

For example, if the parameter is set to “AB”, all records where Name, Code, Description or Text1 to Text10 starts with “AB” will be returned. Note that the search values should be specified within quotes.

Updating Aqilla

Once changes have been made, the data is updated by selecting the appropriate menu option under Analysis Entities.

Documents using Custom Entities

If any documents have been configured to use Super Entities these will be automatically added to the add-in version of the document and the contents validated.

In the above example, Contract has been added to the sales invoice line and the values supplied has been rejected as not being a valid contract code.

* Please note to use these features requires an optional upgrade of the Aqilla Microsoft Excel Add-in.

2. Statement of Accounts

The Statement of Accounts (previously Debtor Statements) function has been enhanced to provide additional features to focus collection action based around potential slow or late payers or focus attention upon the due as opposed to the original transaction date.

Min Balance Age (Days) is a new selection parameter that filters accounts where there are no outstanding transactions greater or equal to the number of specified days. This option can be particularly useful to identify and chase late payers. The filter works in the same way as in the Aged Analysis Reports.

Aged Totals in printed statements. Normally, the summary of aged totals printed at the bottom of a statement are based on the Transaction Date of each transaction. A new hidden option changes this behaviour to base the ageing on the Due Date. Please contact support at if you wish to change this behaviour.