Print Trial Balance for External Reporting (tfgld3412m000)Use this session to print a trial balance report. You can also use this session to export a trial balance to an Excel template that includes XBRL. To export a report to an Excel template (including
XBRL) After you have defined the range and have selected options as required:
Selection Current Company If this check box is selected, LN Reporting Currency Group In an environment with multiple financial companies, a code
that defines the common home currency to be used in reporting and viewing data
for those companies that are linked to that code. Financial Company A company that is used for posting financial data in Financials. You can link one
or more enterprise units from multiple logistic companies to one financial
company. Home Currency One of a company's base currencies in which LN registers and
reports amounts. In a multicurrency system, up to three home currencies can be defined: Year/Period A separate period, or year for financial purposes. Three financial period types exist:
Period Type Fiscal Period Ledger Account A register used to record financial transactions and to
accumulate the values of the transactions for reporting and analysis. The
ledger accounts classify the transactions into categories such as revenues,
expenses, assets, and liabilities. Sublevel A number that indicates the level of a ledger account or a
dimension in the hierarchical structure of accounts and dimensions. A low
number corresponds with a low sublevel. Ledger accounts can have sublevels 0
through 99. Dimensions can have levels 0 through 9. Transactions can only be posted to accounts and dimensions which have a sublevel zero. All amounts and quantities on the sublevels 1 and higher are aggregated from lower sublevels. Account Type Select the appropriate account type. Allowed values
Accounting Scheme A scheme of accounts to which the results of certain events are
posted. The accounting scheme consists of ledger accounts, structured in a
parent-child hierarchy. Options Print Selection Values in Annexure If this check box is selected, the selection data is
included in an annexure. Include Opening Balance If this check box is selected, the opening balance is
included in the report. Print Legal Ledger Account If this check box is selected, LN only prints the legal ledger accounts, which are defined in the Chart of Accounts (tfgld0508m000) session. Include Statutory Balance If this check box is selected, LN prints the statutory
balance. Include Zero Balances If this check box is selected, the report includes
lines of which the balance is equal to zero. For example, the balance of a line is zero if the invoice amount is less than or equal to the credit note amount. Use Ledger Account Print Sequence Number If this check box is selected, LN prints the ledger
accounts according to order of the print sequence number you define in the Chart of Accounts (tfgld0508m000) session. Export Export to Excel Template (XBRL) Select this check box if you want to export a trial balance
report to Excel, using an XBRL template. Open in Spreadsheet The name and location of the spreadsheet file. Default value C:\Users\user_name\Documents\Print Trial Balance\XBRLTB.xlsm Separator The separator to be used. Accept the default separator (",") or, if commas are used in the ledger account descriptions:
Default value "," Tab Delimited If selected, tabs will be used as separators.
Show Template Opens the XBRLTB.xlsm spreadsheet.
| |||