|
A powerful 32-bit business productivity tool, F9 uses Dynamic Data Exchange (DDE) technology to deliver data from the Sage MAS 90 or 200 General Ledger module to your favorite spreadsheet program. When you activate the unique hot link feature from within your spreadsheet, you create an automatic link to your general ledger data—and each cell in your spreadsheet can be hotlinked to any data item in the General Ledger module. Real-time financial information is instantly available within your spreadsheet, and you can save time by taking advantage of your existing spreadsheet expertise. F9 also saves time by eliminating re-keying of data into your spreadsheet.
With F9, your spreadsheet becomes an integral part of your Sage MAS 90 or 200 accounting system. You can easily perform a "what if" analysis to determine the effect of business decisions on your company’s financial status, using up-to-the-minute information from the general ledger.
System Requirements: PC running Windows NT or Windows 98, 2000 or XP plus the following spreadsheet programs (not included): Lotus 1-2-3 for Windows or Microsoft Excel Version 4 or above. You also must have sufficient workstation memory to run the spreadsheet with which you are linking.
|
|
|
| Graphical Presentation of Data |
The presentation of your financial information can be enhanced by taking advantage of the graphics, text and add-in capabilities of your spreadsheet. |
| AnyTimeSlice | You can create financial reports that span any period, even a one-week or one-day Profit and Loss (P&L), if desired. |
| DataPreLoad | By loading all or part of your chart of accounts into memory, you can speed recalculation times dramatically. |
| Multi-Company Capabilities | Access general ledger data from any number of companies simultaneously. Simplify consolidation across departments, divisions or companies. |
| Drill Down | Find the origin of any number in your spreadsheet—drill down all the way to the individual transaction itself. For example, a total revenue figure can be sliced into revenue by department, by product or by location, and that information can be pasted into your spreadsheet to augment your report. |
| Analyze | Report out of balance? With the click of a button, F9’s Analyze feature scans the entire spreadsheet, helping you troubleshoot your report by identifying missing or duplicate accounts. |
| Multiple Fiscal Years | You can access data from all Sage MAS 90 or 200 fiscal years using F9. |
| Report Wizard | You are guided through report creation step by step; in seconds, you can create a complete financial report with all F9 functions, formulas and cell references intact. |
| Flexible Cell Reference | Suppose you have created a departmental report with one cell containing the department code (e.g., "100"). Change "100" to "100,200" and you have a two-department consolidated report. Change "100" to "*" and you have an all-departments report. |
| Create/ Edit/ Write Budgets | "Read Budget" and "Write Budget" buttons provide a mechanism for passing budgets back and forth between your general ledger and spreadsheet. Spreadsheets are an optimal environment for creating and editing budgets, and F9 makes it easy. |
| Executive Information System (EIS) Functionality | With F9, you can drive F9 functionality from within a macro or Visual Basic program. Create dialog boxes, menus and buttons, and use them to explore your accounting numbers, just as an executive information system would. |
| GL Function Wizard | The GL Function Wizard enhances productivity and the creation of reports. The formula inserts the appropriate number of cells in the spreadsheet to build an F9 report. The GL formula contains the cell references required to complete the report. |
| Financial Entities | Financial Entities extends the utility of F9’s formulas. GL account numbers may be specified, using either the segment value or it’s description, as they appear in the chart of accounts. You can also define your own F9 Financial Entities. |
| WGL Formulas | WGL Formulas allow writing budget information back to the F9 Datamart’s general ledger. A single cell of information can be written back to the budget files. While Budget Write Back is for batch updates, WGL allows accounts to be updated individually. |
| Account Enquiry | Just launch F9, select the account(s) you want a balance from, and click Get Balance. With Account Enquiry, you can obtain account balances from your general ledger without using your spreadsheet. Makes quick queries fast and easy. |
Click here to view the F9 PDF File
F9 is a product of Synex Systems Corporation and is distributed under license by SAGE Software, Inc.
herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities.
Windows is a registered trademark of Microsoft Corporation.
All other trademarks are property of their respective owner.