390 likes | 570 Views
LN reporting in FST academy. Coen Decnop, Business Analyst, Infor. FST Reporting. Overview Financial Statements Creating a Financial Statement. FST Reporting. Separate module in ERP LN Financials Derived from BaanIV , but improved ( from FP5 onwards ): Functionality Usability
E N D
LN reporting in FST academy Coen Decnop, Business Analyst, Infor
FST Reporting • Overview Financial Statements • Creating a Financial Statement
FST Reporting • Separate module in ERP LN Financials • DerivedfromBaanIV, but improved (from FP5 onwards): • Functionality • Usability • Collects and processes the required financial values from the General Ledger (GLD) and the Budgeting (FBS) modules
FST Reporting • Financial Statements can be used for • Income statements • Balance sheets • Analysis per Business Unit/Cost Center etc. • Budget comparisons • Internal and external (official) reporting • Consolidated Balance Sheets
FST Reporting – Drill-down Flexible and graphical drill-down to statement values and the GLD (document and transaction line) details
FST Reporting • Financial statements can be processed in any currency • Currency translation from local and reporting currencies into the FST reporting currency • Currency translation: combinations of rate types and historical vs. current rates for different (categories of) statement accounts
FST Reporting Creating a Financial Statement includes 3 steps: • Create Statement Layouts • Create Financial Statement • Process Financial Statement Values
Create Statement Layouts • Definegenerallayout: layoutsize, column definition • Define column layouts: column positionsand format • Define Account layouts: howandwhere account is printed • Generate Report
Create Financial Statement • Define Statement details: code, currency, layout etc. • Define Statement Accounts • Define Statement Columns: what must beprinted
Create Financial Statement After creating the Financial Statement setup, change status to Approved Process Financial Statement Values: Selectsall the valuesfromthe GLD/FBS modules tobeincludedin the financial statement.
Process Financial Statement After processing, the statement values can be printed:
Demo Financial Statement Ratios: E.g. define ratio EBITDA
Demo Financial Statement 1 ratio for each column
Demo Financial Statement Consolidation in FST
Demo Financial Statement • Check Financial Statement will check if Debit and Credit are balancing • Copy to other financial Company • Global change: replace Business Unit