Home >  Support >   Web ADI > 

Frequently Asked Questions about Web ADI

Can I use Web ADI on a Mac?

Web ADI can be used on Intel-powered Macs.  To use Web ADI, switch to the Windows Operating System (start Parallels).

 

Why haven’t I been prompted to Enable Macros?

Macro Security is a setting in Excel which may need to be adjusted to allow Macros; close your ADI template and perform the following in Excel:

 

Excel 2003 and similar

1. Under Tools → Macro → Security, select the Security Level tab, and choose Medium.
2. Under Tools → Macro → Security, select the Trusted Publishers/Sources tab, and make sure Trust Visual Basic Project is checked.
3. Click OK.
4. Reopen your ADI template, Enable Macros, and continue with data entry and upload.  These settings will remain in place for future Excel sessions.

Excel 2007

1. Click the Microsoft Office Button in the upper left hand corner, and then click Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
3. Click the options that you want:
   - Disable all macros with notification:  This will allow you to choose to Enable Macros for ADI templates.
   - Trust access to the VBA project object model. Turn on access by selecting the check box.
4. Click OK to save the settings.
5. Reopen your ADI template, Enable Macros, and continue with data entry and upload.  These settings will remain in place for future Excel sessions.

 

Why am I getting a error message regarding Visual Basic Project?

This is an Excel setting; close your ADI template and perform the following in Excel:

 

Excel 2003 and similar:

1. Under Tools→ Macro→ Security, Trusted Publishers/Sources Tab, check box labelled “Trust Visual Basic Project”
2. Click “OK”
3. Reopen your ADI template, Enable Macros, and continue with data entry and upload.  These settings will remain in place for future Excel sessions.

Excel 2007

1. Click the Microsoft Office Button in the upper left corner, and then click Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
3. Click the option that you want:
   - Trust access to the VBA project object model.  Turn on access by selecting the check box.
4. Click OK to save the settings.
5. Reopen your ADI template, Enable Macros, and continue with data entry and upload.  These settings will remain in place for future Excel sessions.

Why am I getting an “invalid journal entry line” message and there is no information on that line?

Even if there is no chart string or dollar amounts on a line, if the line has a flag under the Upl column (far left), ADI will try to upload the line.  Double-click the flag to make it go away and this error should not recur.

 

I have completed data entry but the Oracle Upload command doesn't work. What's wrong?

Make sure that you have pressed Enter or move the cursor off the cell into which you have finished entering data. Otherwise Excel thinks you are still editing that cell and won't allow Upload.

Why is my chart string invalid/incomplete?

Make sure that you have started entering the value for Entity in the Entity column, not the Upl column to the far left. The Upl column should be left blank; the system may put a flag symbol there but the user won't enter data there. Each chart string segment should be entered in a separate cell with no symbols such as periods or dashes included. If a chart string value begins with zero and this gets dropped (or Subactivity 0000 converts to 0), re-enter the number with a single quote ( ' ) before it so it will be interpreted as text and the beginning zeroes will be preserved.