Reports - Microsoft Office Documents

Question

Sage 50 Pro Canadian Edition 
 I'm trying to print a Chart of Accounts with GIFI codes. Since the Code field is not available to the Chart of Accounts report, I went to Reports > Microsoft Office Documents... and found in the resulting list a report entitled "Chart of Accounts with GIFI Codes", Type "Excel". When I attempt to open the report, Excel opens a spreadsheet populated with data (but not my data) and I get a dialog box asking if I want to refresh the report. If I say no, the Excel file remains open but is filled with sample data. If I say yes, Sage displays another dialog asking me to choose a database for generating the report. 
 What database is it looking for? If I select a *.saj file, Sage produces another dialog asking for authorization and a username and password. Since I'm on a single-user installation, I have no clue what Sage is asking for. 
 Any ideas?

Richard S. Ridings · Accepted Answer

In answer to your first question, Reports, Lists, Accounts allows you to put the GIFI code column on the report. 
 
For the database you want in the MS Office Documents Excel report, you should have a look at File, Properties before you run Reports, MS Office Documents so you will know which company file (*.sai) to run the Excel spreadsheet on. If you don't log into Sage 50 with a user name and password, then use sysadmin with no password (see the bottom right-hand corner of the Home screen for your Username).

Sage 50 Canada

Reports - Microsoft Office Documents

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING