Tax Data Extraction and Reporting (tftax1410m000)

Use this session to generate user-definable ASCII or XML files that can be imported in Excel, Access, BIRT, and other reporting tools. The data is retrieved from the Tax Analysis (tfgld1520m000) session.

 

Selection
Selection Range
Financial Company
Tax Year / Period
Tax Year / Period
Fiscal Year / Period
Fiscal Year / Period
Tax Country/Code
The country in which the tax must be paid and/or reported. The tax country can be different from the country where the goods are issued or delivered.
Tax Code
Kind of Tax
Tax Authority
Tax Category
A way to distinguish and/or group types of tax for inquiries, reporting, and tax payment selections. For example, for social contributions the categories Unemployment and Medical insurance can be required.
Collection Office
Document Date
Transaction Type
A user-defined three-position code used to identify documents. The series linked to the transaction type give documents the sequence number.
Business Partner
Options
Options
Tax Origin
Streamed Reporting Code
The appropriate flexible reporting code selected from the Streamed Reporting Codes (tfgld0592m000) session.
Final Print
If this check box is selected, this is the last time this analysis data can be printed.
Print Selection Details
If this check box is selected, LN prints a single-page report with the selection criteria that were used.
Include Finally Printed
If this check box is selected, LN also prints data that was printed previously.
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.

Settings
Reporting Currency Group
For a multicompany setup, the reporting currency group defined in the Reporting Currency Group Setup (tfgld0680m000) session.
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:

Separator
The character to be used as column separator in the output file.

Default value

"|"

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.