Business Analytics     CRM     eCRM     Forecast PRO     FormTrap     Credit Card Interface (IC Verify)     Report Writer     Office Automation

What is F9?

The financial reporting and analysis market has, in recent years, developed into an industry unto itself with dozens of new players joining the game touted as the new "industry standard." Unfortunately, many of these new solutions involve reinventing your entire financial process with huge investments in new software, hardware, training and implementation time. Not so with F9. In fact, you probably already have 90% of the skills you need to effectively integrate F9 into your current financial system, without a huge investment in time and capital.

F9 is a spreadsheet based financial reporting application. It provides you with the luxury of working in your favorite spreadsheet application (Microsoft Excel or Lotus 1-2-3) and the ability to make intelligent queries of your General Ledger, e.g. "Get me the number for sales of blue widgets in the Midwest for January."  By connecting your spreadsheet to our accounting system, F9 turns your spreadsheet application into the most flexible financial reporting application available. You now have all of the spreadsheet's formatting and layout options available for your financial reporting and analysis needs. You can create literally any report you desire with virtually unlimited formatting options. Colors, fonts, layout, graphics, charts, etc., are at your disposal. The real advantage to using F9 is that you already have the skills you need to be productive immediately; your spreadsheet skills. 

 

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 QuattroPro as a financial reporting
  application
• Performs "what if" analyses
• Creates reports via step-by-step guidance from the Report Wizard
• Hotlinks 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

 

Back to Module List

Home | Products | Partners | Services | Support | About Us | Contact Us
© 2003 Lonehill Systems, Inc.
Customer Service