To download ABC log entries:The ABC system includes the ability to export the data to spreadsheet or analysis programs. Use the ABC Log Viewing/Download screen to download ABC activity log entries to an ASCII file on your computer.
To download ABC log entries:
From the Events > Activity Based Costing menu, select ABC Log Viewing/Download to display the ABC Log Viewing/Download screen.
You can also display this screen by pressing Shift-F5 from any screen.
Create a directory called ASCII on your C drive, if needed.
Use the Download hot key to initiate the download process.
Note: You must have the ABC.DOWNLOAD authorization key assigned to use the Download hot key.
The following prompt displays: Enter DOS Path Name: C:/ASCII/ABCDATA.ASC.
Press Enter to display the Downloading selection list.
Select a format and press Enter to download the data to the ASCII folder.
The system notifies you when the selected records, including comments, are downloaded to your computer.
Press Esc to return to the ABC Log Viewing/Download screen.
Note: If you use Microsoft™ Excel spreadsheets and you selected the Spreadsheet Reformat format, start Excel and open the ABCDATA.ASC file. Select the delimited option and the comma delimiter to display the data in separate columns. Save the spreadsheet with an .xls extension (ABCDATA.xls).
See Also: