AOI - Access Office Integration
Install & Setup, Guides, Troubleshooting and Error Messages
104 articles
- Add more lines to a journal
- Download and review detail line data to Excel for reporting
- INXL transaction enquiry
- Refresh data within Excel
- Return Actual and Budget information for nominal accounts
- Templates - Available Excel Updates
- Templates - Analytics
- Templates - Column update template
- Templates - Custom View
- Templates - Custom View Edit
- Templates - Customer Accounts
- Templates - Debtors Letters in Word
- Templates - Integrated Journal Upload
- Templates - Nominal Accounts / Profit & Loss
- Templates - Nominal Budget
- Templates - Purchase Credit note
- Templates - Purchase Invoice (Table Based)
- Templates - Sales Invoice (Table Based)
- Templates - Standalone journal
- Access tab not showing in Microsoft Excel
- Access INXL tab not showing in Microsoft Excel
- Purchase Order (POP) Update Templates
- Check add-in is enabled or disabled and check Trust Center settings
- Check your licence has expired or used up its licence count
- Check your load behavior is set to three
- COM Addin will not stay enabled and keeps disappearing when Excel is launched
- Connections for journal upload templates is greyed out
- Custom journal templates
- Data Connection Type list is greyed out
- Database is not showing in AOI administrator
- Access Office Integration registration has expired
- Forecast Nominal revision has updated actual budget figures
- Reversing and recurring journals explained
- Extract end of year reports from the Assets module using AOI
- INXL column definitions
- INXL Get Budget showing different figures and not matching the system budgets
- INXL Get Data is not pulling the updated Major Heading Category Code
- INXL Nominal attribute columns are missing
- INXL tab is showing in Excel but all options are greyed out
- Office 365 compatibility with AOI and INXL
- Issues with decimal places in journal upload validation and posting from the batch to the ledger
- Journal Uploader section missing in Access tab in Excel
- Outlook Today
- Re-enable the AOI add-in for Excel
- New AOI licence prompting a Standalone Journal Template upgrade
- Refresh the AppData
- Refresh, Update and Edit buttons are all greyed out on the Access tab
- Remove a user who is no longer needed
- Report, template or workbook performance issues
- Re-enable the Excel option in AOI Administrator
- Transfer existing templates from one machine to another
- Upload the Suppliers from one database onto a new database in bulk
- Validate and process buttons are greyed out in the journal upload template
- View your version
- Error - '25000 rows or less is recommended for Offline Data' in InXL
- Error - 'A logon or configuration error occurred whilst connecting to the registration database'
- Error - 'Access Office Integration has fired an exception'
- Error - 'Access Office Integration requires updated logon details'
- Error - 'addAdministratorPage failed' and 'Root Element is missing' when opening AOI Administrator
- Error - 'AOI is only registered for n users'
- Error - 'An error has occurred attempting to connect to the database'
- Error - 'An error has occurred attempting to connect to the database... specified DSN contains architecture mismatch...'
- Error - 'An error occurred whilst retrieving analytical data. A transport -level error has occurred when receiving results from the server (provider: Session Provider, error: 19 - Physical connection not usable)'
- Error - 'Cost centre Code X for Project Y is not active' when uploading journal
- Error - 'Error (Error (Exception from HRESULT: 0x800A03EC'
- Error - 'Failed to convert parameter value from a String to a Int32' when uploading Budgets
- Error - 'has no valid datasets' when click on Get Data
- Error - 'Inner Exception ......' when opening outlook since a windows update
- Error - 'Invalid column name CAST(STK_DO_NOT_USE AS bit)'
- Error - 'Login failed for user xxxx'
- Error - 'Microsoft Excel is waiting for another application to complete an OLE action.'
- Error – ‘No valid registration details exists’
- Error - 'Object reference not set to an instance of an object'
- Error - 'Purchase Analysis code XXX does not exist Transaction count after EXECUTE'
- Error - 'Specified cast is not valid... ' when validating or processing upload journal
- Error - 'String or binary data would be truncated' when validating or uploading a journal
- Error - 'The cell or chart you're trying to change is on a protected sheet...'
- Error - 'The file format and extension of 'Access Office Integration Excel Functions.xll' don't match'
- Error - 'The following error occured whilst validating the connection. There was no endpoint listening at https://aoilive.accessacloud.com/510/RegistrationService that could accept the message'
- Error – ‘The PivotTable field name is not valid’
- Error - 'The registration details do not match the details in the registration database...'
- Error - 'The SQL server Objects required by Access Office Integration do not exist within the database'
- Error - 'The supplied user credentials are not valid'
- Error - 'The underlying connection was closed: The connection was closed unexpectedly...' when INXL is trying to load transactions enquiry data
- Error - 'The user with email xx does not have permission to access the xx database'
- Error - 'Unable to connect to registration database. No registration information exists for user reference...' when opening Excel
- Error - 'Unable to connect to the registration database. The content type text/html of the response message does not match the...'
- Error - 'Unable to retrieve security modules access for the database xxx.' when launching Excel
- Error - 'Unexpected error (Exception from HRESULT: 0x800401A8) during workbook upgrade activity' on Journal Upload template
- Error - 'Unhandled exception has occurred in a component in your application... Index was outside the bounds of the array.'
- Error - 'User MSTR cannot post transactions to period n as this is a restricted period' or 'User MSTR has not got future period posting enabled and therefore cannot post transactions'
- Error - 'User 'X' cannot post transactions to period XXX as this is a restricted period'
- Error - 'User xx is not permitted to Insert Journal transactions'
- Error - 'You do not have security profile access to update the data in this template.' when uploading data
- Error - '...we couldn't find ... Access Office Integration Excel Functions.xll...' when opening Excel