You can edit the data sources used (databases, d.velop documents connection, etc.) in the editor of the corresponding edoc automate app. You will also find the associated app variables in the app, such as access data for a web service used.
In this article, you will learn more about the conventions for connecting data sources and configuring variables.
Configure the data sources in edoc automate
Configure the database connection in the app details in the Datasources section. Enter the name transfer_db for the data sources to make them easier to identify in future. This connection refers to the local database you have created. For more information see: Install and uninstall edoc invoice link for DATEV
Configure the app variables in edoc automate
When you import the app, you will find a number of variables that you can configure in the app details in the Variables section.
Enter the relevant data in the variables to configure your app optimally.
Overview of the DATEVconnect variables of type "datev" and "import"
The app variables of type datev and import are only relevant if you use the import of master data from DATEV via DATEVconnect.
For more information about setting up DATEVconnect see at DATEV in document no. 1000736 (only available in German).
-
datev.user: Enter the login name for the login to DATEVconnect.
-
datev.password: Enter the password for the login name (datev.user) for logging in to DATEVconnect.
-
datev.base_url: Enter the URL for communication with DATEVconnect.
-
datev.auth_type: Specify the type of authentication for logging on to DATEVconnect.
-
import.creditors.various_addresses_active: If activated (value 1), the various addresses are also output when importing creditors.
-
import.creditors.debitors_active: If activated (value 1), the debtors are also output when importing creditors.
-
import.cost_centers.posting_month_range: When importing master data from DATEV, only cost centers that can be posted on the current date are imported. You can use this variable to define a "transition period" in which the cost centers that have already been closed are also imported. Enter the "transition period" in months.
Overview of the app variables of type "export"
To save the output file in the correct share directory, specify the following app variables:
-
export.export_type: Specify how the DATEV files are to be provided (default: share). Possible values:
-
share: If you specify this value, the files are provided in an SMB share folder. You configure the details using the parameters of export.share_*.
-
persistence: If you specify this value, the files are provided in the persistent folder of the app in the subfolder ..data/persistent/export. You can share the folder e.g. via WebDAV sharing or via SFTP in the edoc platform system environment.
-
hybrid: If you specify this value, the files are provided both in the SMB shared folder and in the persistent folder of the app. Details:
-
SMB share folder: You must create further details using the file share service data source. This data source must have the name File Share Service.
-
Persistent folder in edoc automate: Subfolder ..data/persistent/export. You can share the folder e.g. via the WebDAV share or via SFTP in the edoc platform system environment.
-
-
-
export.company_id: The variable is used to determine the company number for DATEV:
-
If you enter the value company_id, the field company_id is determined from the table transfer_headvalue.
-
If you enter the value finance_id, the field finance_id is determined from the table transfer_headvalue.
-
-
export.company_directories: Specify whether you want to export the DATEV files in the release directory to a subfolder depending on the company number (value 1) or not (value 0).
-
export.local_currency: Enter the currency code (e.g. EUR, USD) that you use as the local currency.
-
export.posting_date_field: Specify the field to be used for grouping by posting period. Default: invoice_date
-
export.account_length: Enter the length of the G/L account numbers as a number.
-
export.account_chart: Specifies the G/L chart of accounts in which the company operates.
-
export.consultant_number: Enter the DATEV consultant number.
-
export.beleglink_short: Enter the abbreviation for the document link under which the ECM document can be called up.
-
workflow.inbox: Specify the name of a group inbox to which invoices should be sent when clicking Send back to workflow.
-
credit_note.amount-sign: The variable specifies the posting indicator with which credit memos are exported:
-
Enter a plus sign + as a value so that amounts for credit memos (greater than or equal to zero) are marked with the posting indicator S (debit). All amounts for credit memos that are less than zero (0) are marked with the posting indicator H (credit).
-
Enter a minus sign - as a value so that amounts for credit memos (greater than or equal to zero) are marked with the posting indicator H (credit). All amounts for credit notes that are less than zero (0) are marked with the posting indicator S (debit).
-
-
invoice.amount-sign: The variable specifies the posting indicator with which invoices are exported:
-
Enter a plus sign + as a value so that amounts for invoices (greater than or equal to zero) are marked with the posting indicator H (credit). All amounts for invoices that are less than zero (0) are marked with the posting indicator S (debit).
-
Enter a minus sign - as a value so that amounts for invoices (greater than or equal to zero) are marked with the posting indicator S (debit). All amounts for invoices that are less than zero (0) are marked with the posting indicator H (credit).
-