1. Home
  2. /
  3. User Guides
  4. /
  5. Financials
  6. /
  7. Accounts Receivable
  8. /
  9. Invoice handling
  10. /
  11. Working with EU statistics...
  12. /
  13. Maintain EU statistics in...

Maintain EU statistics in A/R

Related topics

This routine allows you to maintain an invoice with EU statistics or add EU statistics for an existing A/R invoice in the system. You add the EU information through the maintenance routine for A/R transactions.

Prerequisites
To be able to enter and report the EU statistical information you must define an Export code (which is done in Work with VAT import/export codes), that indicates the following:

  • the EU VAT and trade statistics will be updated when you enter A/R invoices manually.
  • the INTRASTAT will be declared for the transactions.
  • the EU VAT sales will be declared for the transactions.

For more detailed information about how to get to the panel and field descriptions, see About working with A/R transactions. See also the Panel help.

  1. Select the Work with A/R transactions menu item.
  2. You access the main panel. Select the applicable invoice and click VAT.
  3. You access Work with A/R transactions, VAT information where you enter the VAT information about the debtor:
    4. Trader country
    The system defaults the country based on the value for the customer in the Business partner file. If no default trader country exists, the system defaults the system country. You can change to another country. The system will check your company’s VAT registration number in Work with countries. Note: Each company, outside or inside the EU, can be registered for VAT in another EU member country. All countries where the company is registered are trader countries.
    EU VAT rep act code
    The code you enter will be printed on the EU VAT sales report as information. Note: If this is an invoice created in DC1 Distribution from a BtB sales order, then this field will show T (3-party sales), which means that the invoice will be printed on the EU VAT sales report. For more information, see Handle 3-party sales.
    Debtor VAT country
    Enter the country of the customer.
    Debtor VAT number
    The system defaults the VAT registration number of the country in Debtor VAT country. If there is none, then you must enter a valid VAT number manually.
    Export code
    Displays the export code of the document. The export code must be defined with EU statistics set to YES.

    Update the information and click OK to proceed to add EU statistical information.

  4. On the A/R EU statistics maintenance panel, click Add to enter the EU statistics.
  5. Note: Only applicable if you are running the Italian application. The first panel you access after clicking Add is an EU statistics maintenance detail panel where you enter the applicable commodity code to indicate if you are working with a goods or service invoice. For this task, a goods invoice is assumed. Click OK to access the panel described in the following step.
  6. You access the detail maintenance panel where you add the sales information for EU reporting. To complete the EU statistics, the following fields are mandatory:
    7. Country dispatch to
    The system defaults the country of the debtor.

    If you have defined the information in the Business partner file, then the fields below will be defaulted. If they are not defaulted, then they must be manually completed.

    Terms of delivery
    Nature of trans
    Manner of transport
    Commodity code
    Note: Only applicable if you are running the Italian application. The commodity code is defaulted from the EU statistics maintenance detail panel described in step 5 above, but can be changed.

    The following fields are not defaulted:

    Weight in kg
    You must enter a value in this field, if Quantity statistics is set to YES.
    Reporting quantity
    Reporting unit
    Enter quantity and units of delivered goods according to the reporting measurement. If a conversion factor exists between the delivered and reporting unit, the system will complete the fields automatically.

    Click OK when you have completed all relevant fields. Note: Only applicable if you are running the Italian application. If you have entered statistical corrections in a previous goods invoice that was incorrectly declared, then scroll down before clicking OK on this panel. On the next detail panel you specify the references of the previous Intrastat declaration that contained errors and for which you have entered corrections. These corrections will be included in the next official Intrastat declaration. When you have completed the Adjustment information fields, click OK.

  7. You access A/R EU statistics maintenance again with complete EU statistics for the invoice. The panel now displays the total amount that is matched to the invoice for EU reporting. Note: If you have not matched the entire invoice, then you will get a warning message. Click OK to confirm your update with the difference, or click Add to enter more statistical information of the sale. Then, click OK to update the information. Exit the routine.

Related topics