AOI
Access Office Integration
87 articles
- Use the integrated upload templates
- Download and review data using Access Analytics
- Add more lines to a journal
- Check and enable the AOI add-in and Trust Center settings
- Create and use the Nominal Budget template
- Edit customer accounts with an AOI template
- Create a Debtors Letter template in Microsoft Word
- Set up a custom view
- Set up an Analytics template
- Set up and use the Standalone journal template
- Set up a Purchase Credit Note upload template
- Set up the data connection on a standalone journal template
- inXL Transaction Enquiry
- Refreshing data within Excel
- Set up a column update template
- Using AOI to check and update information for profit and loss accounts
- Available Excel Update Templates
- inXL column definitions
- Access Office Integration registration has expired
- InXL Get Data is not pulling the updated major heading category code
- InXL tab is missing from Excel
- Access tabs don't appear in Excel
- Check your AOI licence status
- Check your load behaviour is set to three
- COM add-in does not stay enabled when Excel opens
- Journal upload template connections are greyed out
- Custom journal template
- Data connection type list is greyed out
- InXL Get Data is shadowed grey
- Hosted Dimensions does not appear in AOI Administrator
- Transfer existing templates from one machine to another
- Install the FMS Connector to Upload Journals
- Re-enable the AOI add-in for Excel
- Refresh the AppData
- Remove a user who is no longer needed
- Return both actual and budget information for nominal accounts
- Replacement AOI licence
- Journal Uploader section missing in Access tab in Excel
- Journal posts fail for future periods
- Office 365 and AOI/INXL compatibility
- InXL Get Budget figures do not match the system budgets
- No databases appear in AOI Administrator
- Nominal Budget template shows no budget figures
- Password prompt appears when Excel opens
- New AOI licence triggers a Standalone Journal Template upgrade
- Re-create all user settings
- Re-create the licencing database
- Re-enable the Excel option in AOI Administrator
- Refresh, Update and Edit buttons are all greyed out on the Access tab
- Report, template or workbook performance issues
- Can not write back data on AOI Templates
- Error: 'The following error occurred whilst validating the connection'
- Error: 'The Access Office Integration Excel Functions.xll file could not be found' when opening Excel
- Error: 'No valid registration details exist'
- Error: 'Exception from HRESULT: 0x800A03EC' on the inXL Get Data
- Error: 'The PivotTable field name is not valid' in Access Analytics
- Error: 'An error occurred whilst saving the registration details'
- Error: 'An error has occurred attempting to connect to the database'
- Error: 'Object reference not set to an instance of an object' 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
- 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'
- Error: 'The underlying connection was closed unexpectedly' when loading inXL data
- Error: 'Unable to retrieve security modules access for the database' when opening Excel
- Error: 'You do not have security profile access to update the data in this template'
- Error: '25000 rows or less is recommended for Offline Data' in inXL
- Error: 'AOI is only registered for n users'
- Error: 'Purchase Analysis code does not exist' on journal upload
- Error when opening Outlook after a Windows update
- Error: 'Unexpected error (Exception from HRESULT: 0x800401A8)' 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' on journal upload
- Error: 'Access Office Integration has fired an exception' when Outlook opens
- Error: 'addAdministratorPage failed' and 'Root element is missing' when loading AOI Administrator
- Error: 'Unhandled exception: Index was outside the bounds of the array' when launching AOI Administrator
- Error: 'No user ID has been entered, access to the Accounts has been denied' on journal upload
- Error: 'Specified cast is not valid' when processing an integrated upload journal
- Error - '#-2147217911 'The SELECT permission was denied on the object 'CST_COSTHEADER' when uploading a journal