| # Print Finalized Transactions - Flexible Reporting (tfgld1406m500) Use this session to print finalized transactions for legal or corporate reporting purposes. Reporting is based on predefined fields and export options to Excel or XML. Options Options 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. Flexible Reporting Code The appropriate flexible reporting code selected from the Streamed Reporting Codes (tfgld0592m000) session. Print Selection Details If this check box is selected, LN prints a single-page report with the selection criteria that were used. Create XML format If this check box is selected, LN generates an XML file. If this check box is cleared, LN generates an ASCII file. Make Credit Amounts Negative To print credit amounts as negative amounts, select this check box.
Check box | Column 1 | Column 2
Cleared | Amount | Debit/Credit
Cleared | Debit Amount | Credit Amount
Selected | Amount | N/A
Settings 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. Home Currency home currency Separator The character to be used as column separator in the output file. Export Location Select Local System or Server, as required. Export Directory Click the browse button to select the directory in the Browse For Folder dialog box. Export File Name Click the browse button to select the file in the Open dialog box in the selected directory. Reporting Options Options Amount Format Specify a string that defines the required amount format. Example For French legal reporting, amounts require a dot as thousands separator and a comma as decimal sign. Date Format Specify a string that defines the required date format. Example For French legal reporting, the required date format is `DD/MM/YYYY`. Time Format Specify a string that defines the required time format. Example For French legal reporting, the required time format is `HH:MM:SS`. UTC Date Time Representation Select how UTC time must be displayed. Include Balancing Transaction Type If this check box is selected, you can specify the transaction type to be used for balancing. A user-defined three-position code used to identify documents. The series linked to the transaction type give documents the sequence number. Double Quote Fields If this check box is selected, all values in a text or CSV file will be enclosed by double quotes. Sort By Finalization Date If this check box is selected, transactions are sorted by the date they were posted to the General Ledger. |