BAAN Document
BAAN Document
BAAN Document
0c Finance
Financial Statements
Module Procedure
UP119A US
Document information
Document
Document code
Document group
Document title
Application/Package
Edition
Date
: UP119A US
: User Documentation
: Financial Statements
: BaanERP 5.0c Finance
:A
: August 1999
Financial Statements
Table of contents
1.
1.1
1.2
1.3
1-1
1-1
1-3
1-3
2.
2.1
2.2
2-1
2-1
2-3
Financial Statements
i
Financial Statements
ii
Financial Statements
1
Common Data
EMM
FBS
FST
Financial Statements
GLD
General Ledger
IBD
MCS
Tables
SLI
Sales invoicing
TD
TI
Baan Manufacturing
TP
Baan Project
TS
Baan Service
WH
Baan Warehousing
Legend
Mandatory
session
Optional
session
Mandatory
business object
Optional
business object
TF
Indicates a module
FBS
Indicates a module that is described in the module procedure
FST
Financial Statements
2
1.
1.1
You can produce financial statements with Safari InfoTOOLS, which is built by
Interactive Software System Inc (ISSI). The Safari InfoTOOLS forms a
software package that is used for reporting. The Safari InfoTOOLS is integrated
with the BaanERP software and consist of two main parts:
n
n
Financial Statements
1-1
Basic data
Service
MCS
COM
IBD
TS
EMM
GLD
Finance
FBS
Project
FST
GLD
Central Invoicing
TP
Logistics
WH
SLI
TD
TI
Financial Statements
1-2
1.2
GLD
FBS
FST
If you want to create financial statements, you can export data from the General
Ledger (GLD) module and the Financial Budget System (FBS) module and
store it in the interim tables on the Safari InfoSERVER. As a result, you can use
the Safari ReportWriter to generate financial reports from the interim tables.
Master data and
prerequisites
Before you can start working with FST, you must define the financial statement
parameters. You need these parameters to correctly implement and work with
FST and Safari InfoTOOLS.
1.3
Financial Statements
1-3
Financial Statements
1-4
2.
2.1
Copy (a part of) the general ledger stucture or dimension structure to the
statement accounts
Financial Statements
2-1
Financial Statements
(tffst1500m000)
Statement Accounts
(tffst1520m000)
Statement Ledger/
Dimension Accounts
(tffst1521m000)
Export Financial
Statement Data
(tffst1200m000)
Financial Statement
Performance
(tffst1510m000)
Safari InfoSERVER
Financial Statements
2-2
Step 2
Note
The definition of the statement accounts forms the basis on which to export the
Baan Finance data to the interim tables of the Safari InfoSERVER.
Step 3
Step 4
You can also indicate the level of detail for the following information types that
are stored in the interim tables:
n
n
n
n
n
These five types are available for actual data and for budget data. You can also
indicate which dimension types are involved in the report.
2.2
Through the interim tables that are stored on the Safari InfoSERVER. If you
use a batch process, the interim tables are filled with data from the Baan
Finance history tables.
Financial Statements
2-3
In FST, you can only access the history tables of the General Ledger (GLD)
module and the budget values of the Financial Budget System (FBS) module. If
the report structure fits the charts of the accounts structure, you do not need to
transfer data through the interim tables.
If you want to link multiple ranges of ledger accounts and dimensions to the
statement accounts, use the interim tables. Based on the statements-account
setup, the data is copied from the Baan Finance tables and is restructured. Then,
you can generate reports from the interim tables with the Safari ReportWriter.
Start the export process through the Export Financial Statement Data
(tffst1200m000).
In Figure 4 you can see how Baan FST and the Safari InfoTOOLS are
integrated.
Note
The Bshell is a separate program that shields the BaanERP software from the
operating system, user interface driver, and the database driver to make it
platform independent.
Financial
Statement
Definition
Baan
Financial
Tables
Safari
Report
Writer
Trigger
Process
Statement Set
Definitions &
Update
Interim Tables
Bshell
Figure 4, The Baan-Safari InfoTOOLS integration
Financial Statements
2-4
Safari InfoSERVER