Enter an A/R invoice with EU statistics

Related topics

If you manually enter invoices for trade between EU countries, you should also enter information regarding trade statistics.

Prerequisites

EU reporting in Work with companies and EU stat at entry in the A/R control file must both be set to YES.
Your company must be registered for VAT in at least one country within the EU, preferably the system country. This means that there is a valid value in VAT registration no for the country in Work with countries.
Use a customer number that has a debtor address in an EU country that is different from the country where your company is registered for VAT. Addresses are entered in the Business partner file.
The customer number should also have defaults set up for EU handling in the Business partner file, with an import/export code for trade within the EU.

Select the Enter financial transactions menu item.
On Financial system transaction entry, complete the applicable fields and click OK. For further instructions and field descriptions, see Open a new batch.
You remain on the same panel, which is now updated, showing only the routines that are valid for the selected voucher type. Select the A/R invoices routine and click OK.
You access A/R invoice/credit note entry. Follow the instructions in step 4 in Enter an A/R invoice with a pre-defined contra account with the following exceptions and new fields:

Export code: Enter an export code where EU statistics is set to YES.

Trader country: The system defaults these fields based on the values for the customer in the Business partner file.

EU VAT rep act code: This activity code is for reporting only and determines how the information on the EU VAT sales report is presented. If the import/export code used indicates that no EU VAT sales report is to be printed, then you are not allowed to enter anything. Otherwise, enter an EU VAT reporting activity code established by your local EU administration for the actual transaction, e.g. triangular trade, subcontracting, etc.

Debtor VAT country: The system defaults the country of the customer from the Business partner file. If you enter another country, the customer must have an address in this country and the address must be valid as a debtor address.

Debtor VAT number: The system defaults the VAT registration number of the country in Debtor VAT country. If there is none, you must enter a valid VAT registration number manually.

The fields above are only shown when EU reporting is activated. Click OK. The system retrieves defaults for the fields that were left blank. Click OK again to confirm.

You access A/R EU statistics entry. The following fields are relevant:

Country dispatch to: The system defaults the country of the customer.

Country of origin
Terms of delivery
Nature of trans
Manner of transport
Port of dispatch
Commodity code: The system defaults the values from the Business partner file. If no defaults exist, entry is mandatory in all fields except Country of origin.

Weight in kg: You must enter weight in kilograms if Quantity statistics is YES.

Delivered quantity
Delivered unit: Enter quantity and units of delivered goods.

Reporting quantity
Reporting unit: Enter quantity and units of delivered goods according to the reporting measurements. If a conversion factor exists between the delivered and reporting unit, the system will complete the fields automatically. If not, then this field is optional.

Amount: The system defaults the difference between the invoice amount and the matched amount.

Ancillary cost: Enter the cost or let the system use the rules set up in Work with borders.

Stat procedure
Department: The system defaults the values from Work with countries for the trader country.

Quantity statistics: The default is YES, which means that you must enter the weight in kilograms or reporting quantity, if a reporting unit is defined for the commodity code. If you change to NO, then a weight or reporting quantity need not be entered.

Click OK when you have completed all relevant fields. As long as the invoice amount does not equal the matched amount, the system will re-display the entry panel for more statistics entries. Click Back if you cannot match the entire amount.

You access A/R EU statistics maintenance with all your entries. Click OK to confirm. The system will check that the invoice amount equals the matched amount, but a complete match is not necessary to continue. Exit the routine.