Skip to main content

AOI - Access Office Integration

Install & Setup, Guides, Troubleshooting and Error Messages

104 articles
Troubleshooting
Access tab not showing in Microsoft Excel
Access INXL tab not showing in Microsoft Excel
Are there any Purchase Order (POP) Update Templates like there are for Sales Orders?
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 jounal upload templates is greyed out
Custom journal templates
Data Connection Type list is greyed out
Database is not showing in AOI administrator
Displaying a message saying Access Office Integration registration has expired
Forecast Nominal revision has updated actual budget figures
How do Reversing or Recurring journals work?
Is there a way to 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
Is Office 365 compatible with AOI/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
Received new AOI licence and its now wanting to upgrade my Standalone Journal Template?
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 Messages
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