Sales Analysis > Reports > EC Sales Report - Aggregate

EC Sales Report - Aggregate

You use this program to generate a report of all sales made to other EC countries.

Report Options

Field Description
Report Selection  
Report type
Option Description
Summary

Select this to exclude detail information from being printed on the report.

The total sales values by customer tax registration number are listed.

Detail

Select this to print the detail information as well as totals on the report.

All sales to each customer by document (invoice) number are listed.

Service entries A tariff code can be entered while adding a service charge to an order (Service Charge Lines) and is then added to the miscellaneous charge line on the order.

This only applies when you select to generate a Detail report.

OptionDescription
Include

Select this to include service charge entries.

Exclude

Select this to exclude service charge entries.

Only

Select this to only include service charge entries on the report.

Reprint selection  
Reprint Select this to print a report that was previously printed.
Reprint single period only

Select this to reprint all the available data, for one particular period only.

You indicate the required month and year in the Month and Year fields below.

The month and year, defaults to the current Accounts Receivable month and year (Accounts Receivable Setup - Current Month tab).

Option Description
Month

Indicate the month (within the year selected below), for which you want to reprint the report.

Year

Indicate the year for which you want to reprint the report.

Period end date

The period end date defaults to the Accounts Receivable period end date (Accounts Receivable Setup - Current Month tab), but can be changed.

Indicate the month and year up to which you want to generate the report.

This option is ignored when you select to reprint the report.

Period Indicate the period (within the year selected below), up to which to generate the report.
Year Indicate the year for which you want to generate the report.

Selection criteria

Field Description
Tariff code selection Indicate the tariff code(s) for which you want to include invoices in the report.
Invoice date selection

Indicate the invoice date(s) for which you want to include invoices in the report.

The Sales Analysis EC Vat Sales file/table stores the date of each transaction.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

The report uses data from the Sales Analysis EC VAT sales file/table to create the listing. Each invoiced line on a sales order for a customer in an EC Member State (excluding local transactions) creates an entry in this file.

This report only prints transactions for those EC customers for whom a VAT registration number is defined (AR Customer Maintenance).

Notes and warnings

Restrictions and limits

  • You can only access this program when the EC VAT system is enabled (Tax Options).

  • The report only tracks the movement of sales across EC borders and does not include sales within your own country.

  • The EC Sales Reports are not updated for local customers, or for foreign customers who are not from an EC country. For foreign customers who are from an EC country, but who are not registered for VAT, only the Supplementary declaration listing (despatches) report is updated.