F9

Objective

To add spreadsheet power to SYSPRO’s General Ledger enabling WYSIWYG reporting and on-the-fly recalculations.

The Value of F9 for SYSPRO

SYSPRO makes it easy to add financial reporting power to spreadsheets, quickly and effortlessly. F9 for SYSPRO is an industry leading business productivity tool that enables the creation of virtually any financial report that a company requires for in-depth business analyses. F9 for SYSPRO magnifies existing spreadsheet skills and applies them to a company’s financial needs. F9 for SYSPRO hotlinks the SYSPRO General Ledger data to Microsoft Excel®, Lotus 1-2-3® for Windows or QuattroPro® via Dynamic Data Exchange (DDE.) Create a financial report only once. Then, each time a spreadsheet is calculated, up-to-the-second numbers are automatically inserted from the General Ledger. F9 for SYSPRO allows access to information from multiple companies simultaneously, “drill down” to further explore the numbers in reports, and creation of and/or editing of budgets in a spreadsheet. Additionally, F9 for SYSPRO features smart templates to customize the chart of accounts automatically, support for multiple currencies, report wizards for easy report building, data preload to speed recalculation times, report auditing ease, the ability to specify date ranges and much more.

Features and Benefits

• Uses Microsoft Excel, Lotus 1-2-3 for Windows or Quattro Pro as a financial reporting application
• Performs “what if” analyses
• Creates reports via step-by-step guidance from the Report Wizard
• Hot-links any cell in a spreadsheet to any balance in the General Ledger
• Simultaneously accesses information from multiple companies
• Allows “Drill down” to further explore the numbers in reports
• Creates and/or edits budgets in a spreadsheet and writes that budget data back to the accounting system

System Requirements

• F9 for SYSPRO requires the General Ledger module
• F9 for SYSPRO requires one or more of the following:
  • Microsoft Excel Version 4 or above
  • Lotus 1-2-3 for Windows
  • QuattroPro for Windows Version 5 or higher
  • ODBC license