The Connectivity Centre will gradually replace other export and import forms and become the central point of contact for various files on a visually uniform interface.
Import service basics
You can use the import service to upload, check, edit and import files with bookings or master data.
The import service processes different types of data. We will use a DATEV booking file as an example to show you how to use it.
Simply drag 'n' drop the file onto the cloud (1). If you are using an EXTF / DTFV file, the Datev import type is automatically recognised.
Depending on the filters in your worklist (2), you will see the file in the table area below (4).
Old export and import forms are still available for a transitional period via the three dots (3) (e.g. import Datev format).
Double-click or select and preview to see the data contained and the messages highlighted in colour.
Errors are displayed in red (1) for mouse-over. Incorrect lines cannot be imported.
In yellow (2) you will see notes that you should check.
If there is a large amount of data, you can filter the rows using the drop-down (3).
Use the checkbox (4) to determine which rows are imported at all.
The value can be edited by clicking in a cell (5).
With (6) you can select or deselect all lecture bookings (according to the settings).
Once you have selected a row, use (7) or double-click to switch to the document preview.
Use (8) to switch to the import settings, directly next to it you have quick access to the control matrix.
Finally, click (9) to start the import.
Import service - Datev import
The import service for files in DATEV format offers you more data and a better overview than the previous DATEV import. Other differences between the old and new DATEV import:
In the new import, you can specify separately in the settings that the payment term and payment type from the personal account master data are used.
If the posting was made to a DATEV automatic account, the BU key field in the import is empty. If the Datev automatic account checkbox is activated in the Scopevisio account master of the account, the tax key specified in the Scopevisio account master is used, the Fixed tax key field is ignored.
The following date fields are now taken into account and imported as follows:
Document date: External document date, posting date depending on the setting
Service date: Service date from
Due date: Net due date
Tax period assignment date: Posting date, depending on the setting
If DATEV and Scopevisio are to be congruent for VAT purposes, you should set "Tax period determines posting date" to YES in the settings
.
Import service - Datev import for personal accounts
If no collective account is specified in the file for the subledger account to be created, a standard assignment is made depending on the chart of accounts and subledger account type:
For debtors
SKR03 = collective account 1400
SKR04 = Collection account 1200
SKR14 = Collective account 3400000
SKR70 = Collection account 3400
RLGAT = Collective account 2000
Individual = Collection account 1400
For creditors
SKR03 = Collection account 1600
SKR04 = Collective account 3300
SKR14 = Collection account 3300000
SKR70 = Collection account 3300
RLGAT = Collective account 3300
Individual = Collection account 1600
If other collective accounts are to be stored, this can be controlled via the "Default collective account" field in the person account number ranges.
If an existing personal account is being updated, the collective account is not changed.
Exports
Exports are not yet available in the Connectivity Centre.