| | Processing and printing of financial statementsPrinting directly from LN vs. using an external
reporting tool To be able to print financial data according to the setup in Financial Statements, LN needs to calculate the values of all statement accounts. This processing of
financial data is done differently for statements used for direct printing from LN or for statements that
use an external reporting tool. To process financial data to be used by an external reporting
tool, refer to Processing financial data for external reporting tool. Processing and printing of financial statements from LN - From the LN menu, start the Process Financial Statement Values (tffst1249m000) session. Alternatively, you can start this session through the appropriate menu in the Financial Statements (tffst1500m000) session or the Financial Statements (tffst1600m000) session.
- Select the appropriate financial statement.
- If, in the selected statement, periods were set up as Variable, you must also specify a range of years and
periods.
- To print a consolidated statement, make sure the financial
statements that are linked were already processed for the same year and
period.
- If you entered adjustment transactions for the selected financial statement and you want to take
these into account, select Post Adjustment Transactions to Statement. For more information, refer to Adjustment and elimination transactions.
- If you linked a financial statement in the Next Statement field for the selected statement in
the Financial Statements (tffst1500m000) session and you want to process that
statement as well, select Process Next Statements.
- Select all required fields depending on your setup in the Financial Statements (tffst1500m000) session.
-
If you set up fixed amounts in the selected statement and
these values are modifiable, to update these values, click one of these
buttons: - Acc/Column Spec
- Column/Acc Spec
- Click Process.
-
If you set up ratios in the selected financial statement,
complete these additional steps: - Click Select Ratio Values.
- In the Select Ratio Values (tffst6205m000) session, select the ratios that must be calculated,
and then specify the period in which these values must be stored.
- Click Select.
- To add the calculated ratios to the financial statement
values, in the Process Financial Statement Values (tffst1249m000) session, click Process again.
To print the financial statement, click Print. The Print Financial Statement Values (tffst1450m000)
session is started. For more information, refer to the next
section.
To process financial data to be used by an external reporting
tool, refer to Set the Actual Value Code parameter. Printing financial statement values from LN - From the LN menu, start the Print Financial Statement Values (tffst1450m000) session. Alternatively, you can start this session through the appropriate menu in the Financial Statements (tffst1500m000) session, or by
using the Print button in the Process Financial Statement Values (tffst1249m000) session.
- Specify a range of financial statement accounts and
sublevels.
- Select options as required.
- Click Print.
Exporting financial statement values You can also use the Print Financial Statement Values (tffst1450m000) session to export financial statement
values to a CSV file or to an Excel template that includes XBRL. To export statement values to a CSV file After you have defined the range and have selected options
as required: - Under Export, select CSV file.
-
Accept the default separator (",") or, if commas are
used in the ledger account descriptions: - Enter another separator.
- Select Tab Delimited.
Click Print. The XBRFSTTB.xlsm spreadsheet opens with the statement
values imported from LN.
To export statement values to an Excel template (including
XBRL) After you have defined the range and have selected options
as required: - Under Export, select Excel template (including XBRL).
- Click Show Template.
As a result, LN: - Copies the XBRL template of the additional files to your
computer.
- Defaults the name and location in the Open in Spreadsheet field.
- Opens the Excel spreadsheet, so you can already maintain
the XBRL mapping.
- Save and close the spreadsheet.
-
Accept the default separator (",") or, if commas are
used in the ledger account descriptions: - Enter another separator.
- Select Tab Delimited.
Click Print. The XBRLFST.xlsm spreadsheet opens with its Dynamic Data tab filled with the statement values imported
from LN. The Messages tab allows you to
translate the messages into the required language.
| |