F9 Financial Reporting

Last updated
F9 Financial Reporting
Developer(s) F9, an Infor company
Written in C/C++, C#
Operating system Microsoft Windows
Type Reporting software
Website F9 Financial Reporting

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.

Contents

History

F9 - 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 Shipping Box and Promotional Pen Synex F9 software box with promotional pen.jpg
F9 Shipping Box and Promotional Pen

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

Competition

The 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

Related Research Articles

Lotus 1-2-3 Spreadsheet software

Lotus 1-2-3 is a discontinued spreadsheet program from Lotus Software. It was the first killer application of the IBM PC, was hugely popular in the 1980s, and significantly contributed to the success of IBM PC-compatibles.

Microsoft Excel Spreadsheet, part of Microsoft Office

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office suite of software.

Spreadsheet Computer application for organization, analysis, and storage of data in tabular form

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document.

Lotus Improv

Lotus Improv is a discontinued spreadsheet program from Lotus Development released in 1991 for the NeXTSTEP platform and then for Windows 3.1 in 1993. Development was put on hiatus in 1994 after slow sales on the Windows platform, and officially ended in April 1996 after Lotus was purchased by IBM.

Balance sheet Accounting financial summary

In financial accounting, a balance sheet is a summary of the financial balances of an individual or organization, whether it be a sole proprietorship, a business partnership, a corporation, private limited company or other organization such as government or not-for-profit entity. Assets, liabilities and ownership equity are listed as of a specific date, such as the end of its financial year. A balance sheet is often described as a "snapshot of a company's financial condition". Of the four basic financial statements, the balance sheet is the only statement which applies to a single point in time of a business' calendar year.

Business software is any software or set of computer programs used by business users to perform various business functions. These business applications are used to increase productivity, to measure productivity, and to perform other business functions accurately.

Wingz was a spreadsheet program sold by Informix in the late 1980s and early 1990s. Originally developed for the Macintosh, it was later ported to Microsoft Windows, OS/2, NeXTSTEP and several other commercial flavors of Unix. In spite of many positive reviews, including one calling it "clearly the spreadsheet of the future", the market was rapidly entrenching Microsoft Excel. Informix eventually gave up on the desktop market and reverted solely to database sales in the mid-1990s. Claris licensed and sold an extensively cleaned up version as Claris Resolve in 1991, but it was far too late to market to have any effect.

Sage 300 Software company in Canada

Sage 300 is the name for the mid-market Sage ERP line of enterprise management and accounting applications, primarily serving small and medium-sized businesses. Since 2004, Sage 300 is developed by Sage. In 2012, Sage renamed ACCPAC to Sage 300.

General ledger

In bookkeeping, a general ledger, is a bookkeeping ledger in which accounting data is posted from journals and aggregated from subledgers, such as accounts payable, accounts receivable, cash management, fixed assets, purchasing and projects. A ledger account is created for each account in the chart of accounts for an organization, are classified into account categories, such as income, expense, assets, liabilities and equity, and the collection of all these accounts is known as the general ledger. The general ledger holds financial and non-financial data for an organization. Each account in the general ledger consists of one or more pages. An organization's statement of financial position and the income statement are both derived from income and expense account categories in the general ledger.

Essbase is a multidimensional database management system (MDBMS) that provides a platform upon which to build analytic applications. Essbase began as a product from Arbor Software, which merged with Hyperion Software in 1998. Oracle Corporation acquired Hyperion Solutions Corporation in 2007, as of 2009 Oracle markets Essbase as "Oracle Essbase", both on-premises and in Oracle's Cloud Infrastructure (OCI). Until late 2005 IBM also marketed an OEM version of Essbase as DB2 OLAP Server.

Javelin Software

Javelin Software Corporation (1984–1988) was a company in Cambridge, Massachusetts which developed an innovative modeling and data analysis product, also called Javelin, and later Javelin Plus. Seen as the successor technology to spreadsheet software in reviews of the time, and rival to the then-dominant Lotus 1-2-3, Javelin won numerous industry awards, including besting Microsoft's new Excel for the InfoWorld Software Product of the Year award.

Power Plus Pro is a piece of financial software produced by Reuters Group in the form of an addin for Microsoft Office Excel. A real-time data engine, it pushes new data into Excel when it receives notification of updates from a Reuters TIBCO bus or from Thomson Reuters' RMDS. This commonly involves live market data, such as stock prices, from a financial exchange. Using the addin, Excel can also contribute information to the TIBCO bus or to RMDS; such information then becomes available to other permissioned users using the addin on another computer or using Reuters 3000 Xtra stand-alone software. Power Plus Pro also has features which allow retrieval of historical market data.

Microsoft Small Business Financials is a business accounting software package. The software is targeting growing small businesses that require more than basic accounting software: with fewer than 25 employees and less than $10 million of revenue. It is part of Microsoft Dynamics family. It is based on Microsoft Dynamics GP and runs on top of free Microsoft MSDE or SQL Server Express database. Microsoft Small Business Financials and Microsoft Dynamics GP are built on the same platform, so migration to Microsoft Dynamics GP is very simple and straightforward.

Construction cost estimating software is computer software designed for contractors to estimate construction costs for a specific project. A cost estimator will typically use estimating software to estimate their bid price for a project, which will ultimately become part of a resulting construction contract. Some architects, engineers, construction managers, and others may also use cost estimating software to prepare cost estimates for purposes other than bidding.

Synex Systems Corporation, a subsidiary of Synex International Inc. was formed in 1983 in an effort to develop software for the microcomputer market and was run by Synex International Vice President Murray Hendren until 1992. 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, a U.S. company that specializes in enterprise software.

Microsoft Forecaster is a software product used for organizational budgeting and planning. While not dependent on Microsoft Dynamics ERP packages, Microsoft Forecaster is most often positioned and sold as an add-on to Microsoft Dynamics general ledgers.

CYMA is the name of a series of accounting software packages.

References

  1. "F9 - Synex Systems Corporation Trademark Registration". United States Patent and Trademark Office (USPTO). Trademark Registration #74046153
  2. "Now shipping, F9 Links Spreadsheets, Accounting Applications". InfoWorld. Vol. 11, no. 23. IDG. June 5, 1989. p. 20. ISSN   0199-6649.
  3. Macola Software, Technology White Paper - Progression Series 7.5, Reporting & Query Tools, page 7
  4. F9 - Financial Intelligence Version 4 Manual, PERIOD SPECIFIERS, page 84
  5. Excel 2.0
  6. The rise and fall of the Lotus Programming Language, Lotus Magazine October 01, 1991, Delonas, Nicholas
  7. Formation of Infor at Golden Gate Cap
  8. CA Management Services Business and Software Expo 2012 Exhibitors List
  9. "F9, an Infor Company". Archived from the original on 2012-10-28. Retrieved 2012-03-07.
  10. F9 Software in Accounting Today’s Top 100
  11. ACCPAC Conference Review
  12. "Your HubSpot site has been deactivated" (PDF). Archived from the original (PDF) on 2011-02-18. Retrieved 2011-05-13.
  13. The Changing Face of Financial Reporting for Middle Market ERP