Print Finalized Transactions - Flexible Reporting (tfgld1406m500)

Field Information

Options

Options

Accounting Scheme

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

reporting currency group

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.

transaction type

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 .