| # 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 tax position Selection Selection Range Financial Company Financial Company Tax Year / Period Tax Year Tax Year / Period Tax Per Fiscal Year / Period Fiscal Period Fiscal Year / Period Fiscal Period Tax Country/Code tax country Tax Code Tax Code Kind of Tax Kind of Tax Tax Authority Tax Authority Tax Category tax category 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 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, 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 home currency 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. |