Oasis Finance Data Warehouse is a complete Financial Statement Solution for Baan developed using Baan Tools. Just like standard Baan Financial Statement, it facilitates creation of different financial statements from Baan Ledger History. To present the Financial Statement properly, it supports the creation of Statement Accounts, which can consolidate values from different range of ledger accounts and dimensions, based on the ledger account mapping.
Unlike Baan Financial Statement, Oasis Finance DW supports creation of multiple reports, with different Ledger / Dimension mapping, from the same set of Financial Statement, Statement Accounts and Report Layout.
Standard Baan Financial Statement will select value for only the current period for which the financial statement processed. But Oasis Finance DW will store value for every period for which the financial statement is processed, which enables easy selection and immediate display of Financial Statement for any period and also facilitate reports comparing values of different periods, including Graphs and Charts.
In Baan IV Standard Baan Financial Statement the layouts are prepared in the Financial Statement module with very limited functionality. In Baan 5 and LN 6.x, layouts are prepared in external application like Crystal Report with very limited functionality. In all the above cases, calculations related to the financial statements are made with limited functionality associated with Financial Statement column definition.
To avoid the above handicap associated with standard Baan Financial Statement, Oasis Finance DW supports following functions:
• Most of the complex calculations associated with Financial Statements like, Current Period values, Current Budget values, Corresponding period previous year values, Year to Date values, Year to Date Budget values, Year to Date corresponding period previous year values, etc. are calculated and stored automatically with every period for every financial statement defined in the system.
• Further updates, like complex calculations and allocations, in the financial statement values can be done as customized updates.
• Almost all the major Business Intelligence tools like, Business Objects, Cognos, Oracle BI and Crystal Reports are supported by the Oasis Finance DW.
DEVELOPED USING BAAN TOOLS
Oasis Finance DW is developed as a Baan specific product, with all tables defined in Baan database and all sessions (Maintenance, print and update) developed using Baan Tools. Oasis Finance DW supports all versions of Baan including Baan IVxx, Baan 5xx and LN 6.x. The full technical information is available as standard Baan documents like Table Definition printouts and specific technical and user documents provided in this regard. Many convenient functions like copying ledger account / dimension mapping from standard Baan financial statement are provided.
Financial Statements can be any reports prepared for the management information from the Ledger History of Finance. Normally the financial Statements consist of:
• Trial Balance
• Profit and Loss Statements
• Balance Sheet
• Cash Flow / Fund Flow Statements
• Profit and Loss Annexure, including Operating Expenses Statements
• Balance Sheet Detailed Statements, etc.
But depending on the organizational requirement, the same statement like Profit and Loss, Operating Expenses, etc. needs to be presented in different formats like:
• Consolidated Statements
• Statements by different Financial Companies
• Statements by Different Departments
• Statements by Different Branches
• Statements by Different product groups, etc.
This in many cases results in preparation of hundreds of financial statements for every reporting period.
Ledger Accounts and Dimensions in Baan facilitate systematic recording of values related to every financial transactions. But this raw data needs considerable processing before presenting the values for decision making. The basic purpose of Financial Statements is this presentation of information. One of the important requirements for this presentation, is the definition of Statement Accounts, which represents information collected from different range of Ledger Accounts and Dimensions.
The same statement account like 'Gross Revenue' will have different values depending on the financial statement like Consolidated Financial Statement, Financial Statement by Companies or Branches, Financial Statement by Departments or Product Groups, etc.
Statement Accounts created for one Financial Statement can be used in different reports, by selecting statement accounts relevant only for that report. For example, on preparing a graph for different periods related to Gross Revenue, only that statement account from the standard Profit and Loss Statement is needed. But when preparing a detailed Profit and Loss Statement, most of the Statement Accounts defined for that Financial Statement will be used.
STATEMENT SERIAL
STATEMENT SERIAL
One of the major handicaps of standard Baan Financial Statement is that separate Financial Statement will all Statement accounts needs to be defined for every financial statement of same nature Oasis Finance DW facilitates creation of multiple serials for one Financial Statements, facilities in the creation of many reports from the combination of same Financial Statement, Statement Accounts and Layout. For the User, it is as convenient as selecting a different Financial Statement from a set of options given in a combo box.
This also facilitates to prepare reports of different departments as columns in the same Financial Statement.
The above statements can be for individual companies, branches, departments, product groups, etc.
The same statement account like 'Gross Revenue' will have different values depending on the financial statement like Consolidated Financial Statement, Financial Statement by Companies or Branches, Financial Statement by Departments or Product Groups, etc.
Statement Accounts created for one Financial Statement can be used in different reports, by selecting statement accounts relevant only for that report. For example, on preparing a graph for different periods related to Gross Revenue, only that statement account from the standard Profit and Loss Statement is needed. But when preparing a detailed Profit and Loss Statement, most of the Statement Accounts defined for that Financial Statement will be used.
PROCESS AND STORE VALUES FOR MULTIPLE YEAR / PERIODS
Standard Baan Financial Statements supports only storing the value for the last processed period. This is a major handicap. Oasis Finance DW stores value for every year / period for all financial statements processed. This has the following advantages:
This facilitates easy selection of different year / period for analysis:
Selecting the value of a financial statement for a different year / period is as simple as selecting an option from a combo box.
This facilitates comparison of financial statement for different period, without any further process:
For the above balance sheet, you can compare the values for the:
• Current Period vs. Previous Period
• Current Period vs. Last Year Closing Period
• Current Period vs. Corresponding Period Previous year, etc.
This facilitates easy preparation of monthly Financial Statement, by just changing the layout:
click here to enlarge
• Profit and Loss Statement by Month — with easy selection for various departments / branches
click here to enlarge
• Comparison Charts for any Statement Accounts or Sub-totals for differnt periods, from the standard financial statement, with only preparation at the layout level.
