Breadcrumbs

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