What data is transferred to DATEV by default?
To seamlessly transfer invoice-based bookkeeping data to DATEV, JustOn integrates with JustOn Connector for DATEV. This is an add-on to JustOn that generates DATEV-specific ledger records from booking details (as created from invoices and invoice line items), and transfers them to DATEV Unternehmen online. Once there, these accounting documents and accounting document items can be used by any DATEV application that accesses the DATEV Cloud.
For details, see Data Transfer to DATEV.
The following table shows the default mapping between the relevant Booking Detail fields, the (intermediate) Accounting Document/Accounting Document Item fields and the target DATEV data structure.
| Booking Detail | Accounting Document | Accounting Document Item | DATEV |
|---|---|---|---|
| InvoiceNo | InvoiceId | invoiceId | |
| BookingPeriod | DocumentDate | date | |
| AccountName | CustomerName | customerName | |
| BillingCity | CustomerCity | customerCity | |
| IBAN | IBAN | iban | |
| BIC | SwiftCode | swiftCode | |
| VATId | VatId | vatId | |
| Amount | Amount | amount | |
| AccountNo | AccountNo | accountNo | |
| BookingDate | AccountingDate | date | |
| OriginalBookingDate DeliveryDate |
DeliveryDate | deliveryDate | |
| TaxRate | Tax | tax |
JustOn can copy additional fields from the booking details to the accounting documents and accounting document items. This is done for all additional fields on the booking detail if a field with the same name exists on the corresponding target.
The following table lists some examples:
| Booking Detail | Accounting Document | Accounting Document Item | Notes |
|---|---|---|---|
BillingCountry__c |
BillingCountry__c |
||
BuCode__c |
BuCode__c |
Holds booking codes to control certain DATEV features, like 40 to switch off the automatic tax calculation in automatic accounts. |
|
ClientId__c |
ClientId__c |
Holds a client ID in the format ConsultantID-ClientID. Allows the accounting documents to be assigned to a client-specific data transfer. When a data transfer is created, a user can select the client to which they want to transfer the data if there is no predefined client ID. |
|
CostCategoryId__c |
CostCategoryId__c |
Holds a cost center. Usually, a Booking Detail formula field that refers to Center. |
|
DeliveryDate__c |
DeliveryDate__c |
||
Discount__c |
Discount__c |
||
DueDate__c |
DueDate__c |
Holds the due date of an invoice to support "open items" management in DATEV. | |
Duplicate__c |
Duplicate__c |
Duplicate__c |
Note
Be aware that the DATEV interface does not accept any arbitrary additional fields. For a list of possible fields see Übertragene Belegdaten DE or the Accounting Document or Accounting Document Item object references.
The DATEV interface will only accept additional custom fields on the Accounting Document or the Accounting Document Item if they are defined under the document record data file format (see Formatbeschreibung der Belegsatzdatendatei DE in the DATEV Developer Portal). Any fields other than those included in the DATEV format will be ignored, even if they have been correctly created and set.
Related information:
Enabling Data Transfer to DATEV
What dates are transferred to DATEV?