Add Accounts not responding when Excel on second monitor

From Sage Intelligence Knowledgebase
Jump to: navigation, search

ISSUE: Add Accounts on the Reports Tools menu does not respond on Financial Reports when Excel is on the Secondary monitor


SYMPTOMS:


In ABC company:


In SMI Report Manager:


1. Expand the Financials folder


2. Create a copy of Financial Reports 2-0 and click the Run icon.


3. Select the following parameters and click Ok:


o Fiscal Year = 2010

o Budget = ORIGINAL


4. If Excel launches on a Primary monitor, move the program to a Secondary monitor


5. On the Categories sheet, map the following Account Groups:


o CURRENT ASSETS = 20

o PROPERTY, PLANT AND EQUIPMENT = 24

o OTHER ASSETS = 26

o CURRENT LIABILITIES = 28

o LONG TERM DEBT = 32

o EQUITY = 36

o PROVISION FOR INCOME TAXES = 16

o REVENUES = 8

o COST OF SALES = 9

o OPERATING EXPENSES - CENTRAL = 12

o OPERATING EXPENSES = 12

o GENERAL & ADMINISTRATIVE = 12

o OTHER INCOME & EXPENSE = 13


6. Click on the Menu sheet and run any Balance Sheet Report.


7. Click Ok at the New Sheet Name.


8. In Report Manager, right click on Copy of Financial Reports 2-0 and select Create and Link Template.


9. Select Copy of Financial Reports 2-0(MAS) and click OK.


10. Select Yes and OK.


In MAS:


1. Expand General Ledger, Main and click Account Maintenance.


2. Create the following Account and click Accept:


o Account No = 100-01-01


3. Expand General Ledger, Main and click General Journal Entry:


4. Create the following General Journal entry and click Accept:


o Source Journal = JE

o Click Next Journal # button

o Posting Date = 05/31/2010

o On the lines tab, enter the following:

o Account No = 100-01-01, Debit = 500.00

o Account No = 111-00-00, Credit = 500.00


5. Preview and update the General Journal.


In SMI Report Manager:


1. Expand the Financials folder


2. Select Copy of Financial Reports 2-0 and click the Run icon.


3. Select the following parameters and click Ok:


o Fiscal Year = 2010

o Budget = ORIGINAL


4. Click Yes at the Trial Balance Add-In screen.


5. Click on the Balance Sheet.


6. Place curser on any row.


7. Select Report Tools from the Add-Ins menu.


8. Click the drop down arrow and select Add Accounts.


9. Note that the Add Account does not respond.


Expected Behavior:

The Add Accounts functionality should respond regardless of which monitor Excel is located.


RESOLUTION/WORKAROUND:

Move Excel to the Primary monitor


APPLIES TO:

Sage 100 v4.40 and 4.50 Build 4.50.7107.008