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.
Field Information
- Options
-
- Options
-
- Accounting Scheme
-
Allowed values
- Statutory
-
A ledger account used for official accounting purposes according to legal requirements.
- Complementary
-
A ledger account that you can use for the amounts that are complementary to the amounts in the statutory accounts. For example, you can link a statutory account and a complementary account to a parent account. If you print the Management report based on the parent accounts, on the report ERP LN adds the amounts in the complementary account to the amount in the statutory accounts.
- Both
- Flexible Reporting Code
-
The appropriate flexible reporting code selected from the Flexible 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
- 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.
- 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 .