TX130 - EC Sales Report Use TX130 (EC Sales Report) to generate a flat file containing all the information required for your quarterly EC Sales List report. The EC Sales List is a listing of all intra-EEC sales transactions reported on your company's VAT returns reports for the three periods included in the quarter. You can use three different sort orders. You must first have defined your reporting information in TX06.1 (Tax Report Maintenance for VAT), using the Sales List button to set up tax codes that will be used to retrieve the tax transaction records for reporting. In addition, you must first have run TX120 (VAT Returns Report Generation) in update mode for all three periods in your reporting quarter before you can run your EC Sales Report for that quarter. The Tax Year and Period specified must be in sequential order and must have been defined in TX08.1 (Tax Calendar). Updated Files CKPOINT - Referenced Files ARCOMP - The AR Company file contains the accounts receivable company records. CUSTDESC - The AR Group Customer file contains customer master records. These records contain company independent information. TXCALDTL - Maintains year, period and period status information for the tax calendars defined in TX07.1 (Tax Calendar). TXCOMPANY - The Tax Company file contains company information, as well as which tax system the company uses. If general ledger accounts are defined at the company level, those accounts are included on this file. TXTAXCODE - The Tax Code file contains all tax code information. Tax codes are used in several Lawson systems to calculate tax transactions. TXTAXTRAN - The Tax Transactions file contains all tax transaction records that have been created for the Lawson Tax system by the Lawson Accounts Payable, Accounts Receivable, Billing, Cash Ledger, and Cash Receipts systems. TXVATESLCD - This file contains a list of tax codes that are to be included on the EC Sales List Report that is related to a specific VAT Report. TXVATRPT - This file defines a VAT tax report for a country. |