In the ERP data menu, you can maintain, manage and configure all ERP data valid for your organizational unit.
Create and manage ERP organizational structure
In the area Master Data Management → ERP Data → ERP Structure, you can maintain an ERP organizational structure.
| Hinweis
In the case of an ERP connection, it is mandatory to create such an organizational structure for importing and exporting transaction data and it must match the actual ERP organizational structure. |
Create and maintain ERP organizational structure
You can create a new ERP structure using the New controlling area button.
- Within the controlling area, you can create the corresponding company codes using the New company code button and the purchasing organizations using the New purchasing organization button .
- Within the company code, you can create the associated plants using the New Plant button, reconciliation accounts using the New Reconciliation Account button, and sales organizations using the New Sales Organization button.
- Within the plants, you can create the associated storage locations using the New Storage Location button.
| Hinweis
When creating an ERP structure, it is mandatory that the organizational unit numbers entered in Onventis match your ERP organizational structure. If the structures differ, the documents are rejected during data transfer. Example: ERP controlling area no. 4711 = Entry in Onventis: Controlling area number 4711 |
Costing sheets
In the area Master Data Management → ERP Data → Costing Sheet, a previously imported costing sheet from your ERP system is displayed.
The calculation schema must be exported from the ERP system and then imported into TradeCore via a BC job.
In addition to the standard settings, which are imported from your ERP system, further configuration options are available.
Default settings
The following columns are imported via a BC job:
- Stage
- Counter
- Condition type
- Designation
- From level
- Up to level
- Modifiable
- Calculation rule
- Condition class
- Head
- Position
- Rounding rule
Configuration options
By activating the checkboxes you can additionally configure the conditions:
- Statistical: if you activate this checkbox, this condition will only be displayed without adding or subtracting the condition value to the net price.
- Change unit: if you activate this checkbox, the units for the respective condition can be selected.
Create and manage control code
You can maintain the valid tax codes under Master Data Management → ERP Data → Tax Codes.
Tax codes are used to define which VAT code is transmitted to an ERP system when a purchase order is transferred.
In addition, the control code is assigned to a country and must correspond to the assignment from the ERP system.
When determining the correct tax code, the system uses the country, group, main address, and organizational unit in a purchase order to find a tax code with the same country and group.
Another criterion is the reverse charge procedure, where no VAT is due.
| Hinweis
Automatic selection of the tax code during order dispatch only takes place if there is a 100% match between the order data and the tax code settings. |
Create and maintain control code
To maintain a new control code, click the New button. For the administration of existing control codes, you can select the desired control code from the list.
The following fields are available for the administration of the control codes:
- Input language: here you define the input language in which the control code is to be entered and displayed.
- Deactivate control code: by activating this checkbox, the control code in Onventis is deactivated and can therefore not be used.
- Code: SAP Tax Code Maintenance. In the case of SAP integration, this code must be identical to the SAP control code, e.g. V0, V1 etc.
- Title: in the title you can enter a title for the tax code that makes sense to you, e.g. VAT 19%.
- Tax rate: Entry of the tax rate in %, e.g. 7 for 7 percent
- Country: Use this field to define which country in your organizational unit the tax code is assigned to. In the case of SAP integration, this assignment (control code to country) must correspond to the assignment in your SAP system.
- Group: Use this field to define whether your organizational unit is an EU or non-EU country.
- Delivery in: in this field you enter the country to which the goods will be delivered.
- Country of vendor: here you maintain the country of the vendor from whom you procure the goods.
- Service order: you should select this checkbox if you want the tax code to apply only to service orders.
- VAT due (no reverse charge items): this checkbox is selected by default. For tax codes to be pulled into reverse charge item orders, this option must be unchecked, i.e. a 0% tax rate will only be specified for reverse charge items if this checkbox is unchecked.
Examples for automatic control code determination
Example 1:
A purchase order is created with an organizational unit whose country, in the main address, is Germany. The group of the purchaser is therefore EU.
Additional parameters are the country of the supplier and the delivery address. This determines whether the delivery is a cross-country delivery.
Example 2:
The goods are delivered to Germany, the supplier is located in Switzerland. In this case, the supplier group is not an EU country and it would be a cross-border delivery, delivery of goods from Switzerland to Germany. The system searches for a control code that exactly meets these conditions.
For orders with a tax rate of 0%, the following cases are distinguished in Onventis:
- If no tax code exists for which both the tax rate = 0 % and the country constellation match the purchase order item, the system searches for a tax code for which only the country constellation applies.
- The control code is assigned to the purchase order item. The tax rate of the purchase order item is overwritten with that of the tax code (e.g. 19 %).
- If a tax code exists for which both the tax rate = 0 % and the country constellation match the corresponding PO item, this tax rate is assigned to the PO item. The tax rate of the purchase order item of 0 % remains unchanged.
If the control code that meets these criteria is stored, it is automatically drawn. If no suitable tax code has been created, a system message is displayed and the tax code must be selected manually by the orderer.