What dates are transferred to DATEV?
Data transfer to DATEV
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.
Posting-Relevant Date
The DATEV API used by JustOn Connector for DATEV supports only one posting-relevant date and cannot distinguish between document date and accounting date. This is why accounting document items have three relevant date fields:
| Field | Description |
|---|---|
| Document Date | The date taken from the (parent) accounting document |
| Accounting Date | Accounting date of the accounting document item The integration with JustOn Billing & Invoice Management uses the Booking Date of the booking details. |
| Date | A formula field that determines the date to be transferred to DATEV – if available (which is the case with the JustOn Billing & Invoice Management integration), the Accounting Date, otherwise the Document Date |
When integrating with JustOn Billing & Invoice Management, the accounting data is taken from the booking details (as created from invoices and invoice line items). There are two basic options to determine the accounting date:
By default, the booking date of the booking detail is derived from the invoice Date field. For an invoice issued on May 12, 2022, for example, the revenue and input tax liability arise in May 2022:
| Invoice | Booking Detail | Accounting Document Item | DATEV | |||
|---|---|---|---|---|---|---|
Date |
→ | Booking Date |
→ | Accounting Date |
→ | Date |
2022-05-12 |
2022-05-12 |
2022-05-12 |
2022-05-12 |
Using the custom field ON_BookingDate, you can set dates other than the invoice date as the booking date. For an invoice issued on May 12, 2022 with an additional Booking Date field – which is set to April 30, 2022 by some custom logic –, the revenue and input tax liability arise, consequently, in April 2022:
| Invoice | Booking Detail | Accounting Document Item | DATEV | |||
|---|---|---|---|---|---|---|
ON_BookingDate |
→ | Booking Date |
→ | Accounting Date |
→ | Date |
2022-04-30 |
2022-04-30 |
2022-04-30 |
2022-04-30 |
Due Date
If your business keeps lists of open items ("offene Posten") in DATEV to support liquidity management, your booking data must show the due date. Since the accounting document item provides the field Due Date, you can set up the data transfer from JustOn Billing & Invoice Management to include this information.
To this end, you add the Due Date field to the booking detail like:
| API Name | Data Type | Value |
|---|---|---|
DueDate |
Formula (Date) | ONB2__Invoice__r.ONB2__PaymentDueDate__c |
Once set up, JustOn will
- Copy the payment due date from the invoice to the
Due Datefield on the booking detail when generating booking details, - Copy the due date from the booking detail to the accounting document item when preparing the accounting data for DATEV.
Consequently, DATEV will acquire the due date from the accounting document item on data transfer.
Delivery Date
The Delivery Date is irrelevant to the posting-relevant date.
If you need the delivery date information in DATEV, you can add this field to the Booking Detail, as described in Additional Fields.
Related information:
Enabling Data Transfer to DATEV
What data is transferred to DATEV by default?