Example implementation E-invoices with Conextrade (Switzerland)

Example implementation of an e-invoice for exchange with the trading platform Conextrade

Product line

Standard

|

Expert

Operating mode

CLOUD ABO

|

ON-PREMISES

Modules

Services & CRM

Budget & Phases

Purchases

Resource Planning

Business Intelligence

Created: 28.07.2015
Machine translated
Updated: 08.08.2019 | Replaces mapping file with modified comments. New screenshots.

The example implementation refers to the invoice with minimum content of the Specification Version 3.1 Swisscom for the Conextrade trading platform. An ETS XML file is created and a PDF is attached.

Prerequisites / Mapping

Specification of fields Description business values ets 3.1 – invoice_v1.06_en.pdf
Mapping file Vertec Mapping-file.xslx
Scripting Create an e-invoice.py

Corresponding data must be available in Vertec for the specified fields. The mapping file specifies which (Conextrade) field is used for which (Vertec) data.

The script for invoicing is structured accordingly, so if you want to change anything about the mapping, you have to adjust the script accordingly.

The following basic prerequisites must be provided in Vertec:

  • Under System settings > General, your company must be defined as your company. This company must have the following properties:
    • Name and address according to commercial register entry.
    • In the VAT number field, the VAT must be entered in the VAT ID format (e.g. CHE-123.456.789 VAT).
  • The following two system settings must exist and contain a path:
    These can be created once with the following code via the Script Editor :
    cxtExportXML cxtExportPDF
    p = vtcapp.createobject("StringProperty")
    
    p.propertyname = "cxtExportXML"
    p.propertycaption = "Conextrade Exportpfad XML"
    p.auswahltyp = 5
    p.gruppe = 3 # Rechnung
    p = vtcapp.createobject("StringProperty")
    
    p.propertyname = "cxtExportPDF"
    p.propertycaption = "Conextrade Exportpfad PDF"
    p.auswahltyp = 5
    p.gruppe = 3 # Rechnung
  • For the PDF, the standard report called Invoice with Performance List will be used. This report must be registered in Vertec under this name (or the corresponding name must be changed in the Python Script).
  • The script must be in Vertec for the class Rechnung, einzelnes Objekt be registered.

Create an e-invoice

An e-invoice can now be created on settled invoices. Via menu entry (or right mouse button on the invoice in the list) the e-invoice is created:

If you do not have all the required data, you will receive an information message and you can complete the data accordingly:

If the creation of the e-invoice has been successfully completed, you will receive a confirmation:

The two files are now located in the locations you have saved in the system settings: