F9 is a financial reporting software application that dynamically links general ledger data to Microsoft Excel through the use of financial cell-based formulas, wizards, and analysis tools to create spreadsheet reports that can be calculated, filtered, and drilled upon. The F9 software is developed, marketed, and support by an organization also called F9, a division of Infor Global Solutions (Canada) Ltd. which is headquartered in Vancouver, British Columbia.
| Developer(s) | F9, an Infor company |
|---|---|
| Written in | C/C++, C# |
| Operating system | Microsoft Windows |
| Type | Reporting software |
| Website | F9 Financial Reporting |
History
editF9 - The Financial Reporter was originally developed by Synex Systems Corporation, a subsidiary of Synex International (Symbol SXI, TSX).[1] First announced in 1988 as Acclink for Accpac as a Lotus 1-2-3 Add-in for DOS and released under F9 name later in 1989.[2] Subsequently F9 was developed for the Microsoft Excel Spreadsheet Platform.
F9 was developed to allow a non-technical user, typically an accountant, to create a dynamic, customized general ledger financial report using a spreadsheet that is 'hot-linked' to an accounting system's general ledger.[3]
Initially, the user interface used the same syntax as Accpac for specifying the reporting period. This was soon replaced by a simpler to understand and more flexible generic natural language interface that used a temporal trinary (three part) phrase parsing syntax composed of a modifier, a period specifier, and a temporal index. For example: "starting balance last quarter" is broken down to 'starting balance' (modifier) + 'last' (temporal index) + 'quarter' (period). The temporal index can be relative or absolute and the modifier can determine if the value returned is differential or cumulative.[4]
The first F9 addin was a significant software effort in that it used a coding trick to break the small memory model limit 1-2-3 imposed on addins and allowed F9 to be run as a compact memory model program. This allowed F9 to be written in C (using a Microsoft C DOS compiler) rather than assembler allowing easier changes and debugging.[citation needed]
An F9 addin was developed for Excel in 1989 and with the lack of a 1-2-3 version that supported Windows[5] and problems with the Lotus Programming Language (LPL)[6] the Excel version of F9 soon far outsold the 1-2-3 version.[citation needed]
On or about the year 2002 F9 was renamed 'F9 - Financial Intelligence.'[citation needed]
In 2002, Synex Systems was acquired by privately owned Lasata Software of Perth, Australia. In 2005, Lasata was acquired by UK based Systems Union. In 2007, Systems Union was acquired by privately held Infor Global Solutions,[7] a U.S. company that specializes in enterprise software.
What was Synex Systems Corporation now operates as an independent business unit (IBU) within Infor Global Solutions called F9.[citation needed]
As of 2012 F9 was used by over 30,000 financial accounting professionals in more than 20 countries worldwide[8][9] and was named one of Accounting Today's "Top 100 Software Products" for 2001.[10]
Features
edit- Financial Spreadsheet Formulas
- Use of natural language (English) accounting period specifiers
- Dynamic Report Filters
- Report Wizards
- Table and Pivot Table Reporting
- Drilldown to Transactions
- Budget Reporting and Budget Write Back
- Consolidations
- Report Analysis
- Web reporting and dashboards
- Over 150 different accounting/ERP systems are supported.[11]
Competition
editThe major competitor of F9 is Microsoft's FRx. However starting in 2011 FRx is now in a state of phased discontinuation.[12] and Microsoft's official FRx replacement is Management Reporter. Other reporting systems competing with F9 are Alchemex, Bizinsight, Renovofyi and SmartView by Solution 7.[13]
See also
editReferences
edit- ^ "F9 - Synex Systems Corporation Trademark Registration". United States Patent and Trademark Office (USPTO).
Trademark Registration #74046153
- ^ "Now shipping, F9 Links Spreadsheets, Accounting Applications". InfoWorld. Vol. 11, no. 23. IDG. June 5, 1989. p. 20. ISSN 0199-6649.
- ^ Macola Software, Technology White Paper - Progression Series 7.5, Reporting & Query Tools, page 7
- ^ F9 - Financial Intelligence Version 4 Manual, PERIOD SPECIFIERS, page 84
- ^ Excel 2.0
- ^ The rise and fall of the Lotus Programming Language, Lotus Magazine October 01, 1991, Delonas, Nicholas
- ^ Formation of Infor at Golden Gate Cap
- ^ CA Management Services Business and Software Expo 2012 Exhibitors List
- ^ "F9, an Infor Company". Archived from the original on 2012-10-28. Retrieved 2012-03-07.
- ^ F9 Software in Accounting Today’s Top 100
- ^ ACCPAC Conference Review
- ^ "Your HubSpot site has been deactivated" (PDF). Archived from the original (PDF) on 2011-02-18. Retrieved 2011-05-13.
- ^ The Changing Face of Financial Reporting for Middle Market ERP