Use this listing to produce a detail or summary listing of all sales to customers in European Union (EU) member states other than your own. You can run this report from the Submit Requests window in either Detail or Summary mode. The report will be sorted by member state, with a second sort by VAT Number. Sales will be totalled by member state.
Prior to submitting this report you must set the VAT Member State codes for all the EU countries in the Countries and Territories window.
All EU countries must have a none null value in the VAT Member State Code column, apart from the 'Home Country'. For example, running these reports from the UK would mean that the only states with none null VAT Member State Code would be the EU countries minus the UK.
Detail/Summary: Choose to produce a Detail or a Summary listing.
From/To Date: The start and end dates for the report.
Site Reported: Choose the site use for the VAT registration numbers that you want printed in this report.
If you choose Ship To, but a ship-to site use for a VAT registration number was never defined, then Receivables prints the bill-to site use for the VAT registration number.
Branch ID: The Branch Id of the Trader whose sales information is being reported.
From Date/To Date: The starting and ending dates of the period being reported.
Trader VAT No: The VAT Number of the Trader whose sales information is being reported.
Line Number: Receivables prints a sequential line number for each line of the Detail part of this Header/Detail report.
Country: The Country Name of the member state being reported on. This is the member state of the Trader's Customer.
VAT Number: The VAT Number of the Trader's customer being reported.
Currency: The currency of the amount in the Net Total column.
Net Total: The Net Total of sales for the respective VAT Number. If the report is run in 'Detail' mode then this figure will relate to each detail line within each VAT Number, within each Country. If the report is run in 'Summary' mode then this figure will relate to each VAT Number within each Country and so will be a summary for each VAT Number.
Functional Total: The total of sales for the respective VAT number in your functional currency.