AOI
Access Office Integration
50 articles
Use the integrated Upload Templates
Access Analytics - download and review detail line data to excel for reporting
Add more lines to a journal
Check add-in is enabled or disabled and check Trust Center settings
Creating and using the Nominal Budget template
Edit Customer Accounts using an AOI Template
Create a Debtors Letter template using Microsoft Word
inXL column definitions
I have a message to say Access Office Integration registration has expired
InXL - Get Data is not pulling the updated Major Heading Category Code
INXL tab not showing in Microsoft Excel
Access tabs aren't appearing in Microsoft Excel
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 Template
Data Connection Type list is greyed out
InXL - The Get Data is shadowed grey, so I cannot update it
Hosted Dimensions is not showing in AOI administrator (Access Hosted Clients)
Transfer existing templates from one machine to another
Install the FMS Connector to Upload Journals
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 - '...we couldn't find ... Access Office Integration Excel Functions.xll...' when opening Excel
Error – ‘No valid registration details exists.’
Error - 'Error (Exception from HRESULT: 0x800A03EC,' inXL get data exception
Error – ‘The PivotTable field name is not valid’ Access Analytics
Error - 'An error occurred whilst saving the registration details. An error occurred whilst creating the AOI registration database...'
Error - 'An error has occurred attempting to connect to the database'
Error - 'Object reference not set to an instance of an object' occurs when opening AOI Administrator
Error - 'A logon or configuration error occurred whilst connecting to the registration database'
Error - 'Access Office Integration requires updated logon details' when opening Excel (Access Hosted Clients)
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 underlying connection was closed: The connection was closed unexpectedly...' when INXL is trying to load transactions enquiry data
Error - 'Unable to retrieve security modules access for the database xxx.' when launching Excel
Error - 'You do not have security profile access to update the data in this template.' when uploading data
Error - '25000 rows or less is recommended for Offline Data...' in inXL
Error - 'AOI is only registered for n users'
Error - Purchase Analysis code XXX does not exist Transaction count after EXECUTE
Error - When opening outlook since a windows update
Error - 'Unexpected error (Exception from HRESULT: 0x800401A8) during workbook upgrade activity.' with Journal Upload template
Error - 'The file format and extension of 'Access Office Integration Excel Functions.xll' don't match"'
Error - 'String or binary data would be truncated' with journal upload
Error - 'Access Office Integration has fired an exception' when Outlook is opened
Error - 'addAdministratorPage failed' and Root Element is missing' - when loading AOI Admin