Product Release: 1601

Following on from the release in November of a new version of SharperLight, we’re pleased that the new year comes with another update to the core Aqilla system (1601).

The principal enhancements in this release include:

The introduction of Enquiry Profiles which allow a user to save or memorise (and share) filter selections in all the Enquiry screens including an often demanded capability to remember the configuration of complex Ledger Enquiries.

Standard and Actual Costing method enhancements in Inventory Control.

Tighter validation of look-up values in Journal Correction feature.

Dynamic column headings in Period Spread type Financial Reports.

The detail on each of these features with examples is shown below.

Enquiry Profiles

A new feature has been added to all the enquiries in Aqilla that enables the selections to be memorised. For example, each month you may wish to check for any Expense documents that have not yet been posted.

In the top of the menu bar, there is a new dropdown option and a yellow star button. Selecting the star button opens a dialogue window that allows you to save the current selection and give it a name:

You will see that this profile can be saved for your personal use or made available to everyone defined within that particular Aqilla instance (assuming they have access to this enquiry function). This means an administrator can define complex queries and then share those amongst other co-workers. Once the profile is saved, the profile is available in the drop-down list.

If you wish to create a new profile for any Enquiry, first select the blank option from the profile drop-down. If you have made an error with the definition of the profile simply select the profile, amend the selection criteria and open the dialogue box to re-save the definition. The Profile Name or Privacy can be changed in the same way (in other words it can be switched from Personal to Public or back the other way).

Note that when a profile is marked as Global, only the owner of the profile may edit the profile.

A more complex example using Ledger Enquiry displays the net value of all sales invoices this period:

In this example all transactions are selected for This Period that:

Are not debtor transactions.

Are created by journals of Journal Type Name starting with “sales”.

Exclude transactions in the VAT account.

Note that any number profiles can be created for any of the enquiry views throughout Aqilla.

Inventory Costing

A number of enhancements have been made to the handling of Standard and Actual costs when using Aqilla integrated Inventory Control features. The Actual Value (i.e. the value of the transaction when it is brought into stock) is now always maintained against an inventory transaction irrespective of what costing method is employed. This value is carried across to any issue transaction based on how it was matched against the receipt transaction. When using Standard Costing, the purchase invoice journals recording the inventory stock automatically post the cost variance between the standard cost and the cost of purchase. When selling inventory controlled items, the sale invoice journals automatically record the reduction in the inventory account.

Journal Corrections

When a journal contains attributes that were subject to lookup values in the source document, they are now validated against the same lookup values.

Dynamic Column Headings for Spread Type Financial Reports

A new option has been added to the definition of the column headings for Spread type columns. Normally, the column headings are automatically generated with the name of the period. It is now possible to provide additional text for the heading. Specifying %1 in the heading text species where the Column Period Parameter is shown. Currently the only Column Period Parameter the Period Name. For example, when using the Period Spread Forward option to report on Budget information, the column can now include Budget into the heading:

E-book: Dispelling the (five) myths of accounting in the Cloud

Month or year end doesn’t have to be slow or difficult. Here is a best practice guide to the busiest times of the accounting and finance year with 5 tips to facilitate a quicker and more efficient period end.