Skip to main content
Skip table of contents

Using the Aqilla Function

This function enables you to create, update and delete reference data in Aqilla. 

Click on the Aqilla Ribbon in Excel

Then go to References and click on GET to use the function

image-20241023-100431.png

You can also click the Fx icon and select the category Aqilla Functions

image-20241023-100703.png

Then select the function you want to use:

image-20241023-100724.png


Reference Data

Most of the reference data in the Aqilla have a corresponding Add-in menu under References. 

image-20241023-101037.png

List of reference data.  

  1. Accounts (Ledger, Creditor, Debtor)

  2. Account Categories

  3. Assets

  4. Budget Lines

  5. Customers

  6. Currencies

  7. Currency Rates

  8. Departments

  9. Items

  10. Item Units

  11. Item Unit Conversion Rates

  12. Lookup Values

  13. Movement Types

  14. People

  15. Projects

  16. Suppliers

image-20241023-101146.png

You can also upload and - optionally post - various documents. N.B. Expense Claim documents cannot be uploaded via the Add-in. See the various options at Aqilla MS Excel Add-in

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.