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 window.
You can also display this screen by pressing Shift-F5 from any window.
Form the File menu, select Download to display the Save dialog box.
Note: You must have the ABC.DOWNLOAD authorization key assigned to use the Download functionality.
The system populates the File Name field with ABCDATA.ASC and opens the C:/ASCII folder.
Click Save to display the Conversion Types selection list.
Double-click a format.
The system downloads the data to the ASCII folder.
At the Download successful prompt, click OK.
Press Esc to return to the ABC Log Viewing window.
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: