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