| # 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 by Tax Position Range To select tax data by tax position, select this check box. If this check box is selected, the following fields are unavailable: Tax Country The displayed values are derived from the tax position range. Tax Code The displayed values are derived from the tax position range. Tax Origin ( Options tab) The tax origin is overruled by the tax type of the tax position range. Note To use the tax position for selection purposes, ensure that the Tax Position and Tax Position Description fields exist in the Tax Reporting area of the Flexible Reporting Fields (tfgld0591m000) session, and were added to the flexible reporting code that you use for your tax reporting. If, in the Tax Positions (tfgld0120m000) or Tax Position (tfgld0620m000) sessions, Relations by Country Group is selected, that tax position is ignored for data extraction. Tax Position Represents a box on the tax declaration form. To link the tax codes that contribute to the amount in a box to its tax position, you define relations by tax position. To add the box to the tax declaration, link the tax position to the declaration master. Selection Selection Range Financial Company Financial Company Tax Year / Period Tax Year Tax Year / Period Tax Period Fiscal Year / Period Fiscal Period Fiscal Year / Period Fiscal Period Tax Country 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 Tax Code Kind of Tax Kind of Tax Tax Authority 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 Collection Office Document Date 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 Business Partner Options Options Tax Origin VAT Type Flexible Reporting Code The appropriate flexible reporting code selected from the Flexible 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, the application 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. Report 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`. 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: The local currency Two reporting currencies 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. |