Quick search:eBay DataTransfer JTL-Worker PayPal
Contents

    Entering tax information

    Your task/initial situation

    In the customer master data, you can maintain tax information about your customer. In addition to the VAT ID and the tax ID, you can also enter a commercial register number and an accounts receivable number for your customer.

    Entering tax information

    1. Click on the Customers icon to go to the customer overview in JTL-Wawi.
    1. Find the customer you want to edit in the overview or via the search and filter functions.
    2. Double-click on the customer master data.
    3. In the General information and Customer data area, you can now store the required data.
    1. Close the customer master data by clicking Save. The tax information is now stored in the customer master data.

    Checking the VAT ID

    Via the Check button, you can check the entered VAT ID. If your registered office is in Germany, but the VAT identification number to be checked is from another EU country, the check will take place via https://evatr.bff-online.de/eVatR/. If the VAT identification number to be checked is from Germany or if your registered office is not in Germany, the check will be carried out via http://ec.europa.eu/taxation_customs/vies/vatRequest.html.

    1. Click on the Check button. The Check VAT ID dialogue box opens.
    Please note: The icon on the button shows you whether the VAT number has not been checked yet and whether it is valid or invalid. Hover over the button with the cursor and a note with more information will be displayed.
    Please note: The Check VAT ID dialogue box opens only if the tax ID is not a German tax ID.
    1. Click Start request.

    Further information on checking the VAT ID can be found on the website of the finance authority of your country or the European Commission.

    Checking VAT IDs from JTL-Wawi version 1.5.45 (Only relevant to merchants based in Germany)

    The process to check the VAT ID remains the same. However, the printing function and thus the postal certificate of the examination of the “Bundeszentralamt für Steuern” (German Federal Central Tax Office) is obsolete. The proof of the check is now displayed as an entry in the customer history. Double-clicking on the entry opens the result transmitted by the “Bundeszentralamt für Steuern”. A screenshot of this is sufficient as proof.

    If your tax accountant requires a mass proof, use the following SQL to obtain the data for a specific period:

    SELECT tKunde.cCustomerNo, historie.cValue1 as cTest result, historie.dErstellt 
 FROM [Kunde].[tHistorie] history
 JOIN tKunde ON tKunde.kKunde = history.kKunde
 where historie.kProcess = 46 and IsNull(cValue2, '') = ''
 and historie.dErstellt >  '01/01/2011'  -startzeit ab dem suchen werden
 AND historie.dErstellt < '31/12/2021' -- Entzeitpunkt
 order by historie.dErstellt DESC