Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TX130


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.