One moment please...
 
 
Exact Globe   
 

Product Update 415: CSV format supported for DATEV export (German legislation)

From this product update onwards, the export of the transfer of general ledger balances, invoices, and master data can only be done in the CSV format. The previous formats, which were the OBE and KNE formats, can no longer be used for the export of DATEV.

The following are the enhancements that have been made to support the new CSV format:

DATEV settings screen

In the DATEV settings screen, which is accessible via System ➔ General ➔ Settings ➔ DATEV settings, the Lock check box has been added under the Logistics and Financial sections. The Lock check box is required to indicate the value in the report header. When the check box is selected, Yes will be displayed in the request header, whereas when it is not selected, No will be displayed.

When the Lock check box has been selected, the value will be displayed in the report header as follows:

As required by the German GoBD, any modification that has been made to the Lock check box will be logged in Logbook, which is accessible by clicking the Logbook button in the DATEV settings screen or via System ➔ Checks ➔ Logbook, as displayed in the following screen:

Transfer GL balances screen

In the Transfer GL balances screen, the following fields have been removed from the Entry data section:

  • No. data medium
  • Settlement number
  • DFV code
  • Password
  • DATEV input format

The fields that are now available in the screen are as displayed in the following screen:

Transfer invoices screen

In the Transfer invoices screen, the following fields have been removed from the Entry data section:

  • No. data medium
  • Settlement number
  • DFV code
  • Password
  • DATEV input format

The fields that are now available in the screen are as displayed in the following screen:

Transfer master data screen

In the Transfer master data screen, the following fields have been removed from the Entry data section:

  • No. data medium
  • Settlement number
  • DFV code
  • Password
  • DATEV input format

The fields that are now available in the screen are as displayed in the following screen:

DATEV report header

In the DATEV report header, the value that has been selected at the Lock check box in the DATEV settings screen will be reflected as displayed in the following samples:

Transfer GL balances report

Transfer invoices report

In the Transfer invoices report, the S/H column has also been added to indicate whether the amount is a debit or credit amount. The value “S” indicates that the amount is a debit amount, whereas the value “H” indicates that the amount is a credit amount. 

Maximum entries for CSV file

The maximum entries that are allowed for the export of the transfer of general ledger balances and invoices are 99,999 entries for each CSV file. Once the limit has been exceeded, the file will split to another file, which will contain the 100,000th entry and onwards.

File name

The default naming convention for the CSV file has a prefix of “EXTF_” which represents External Formal. The following are the descriptions of the naming convention for the transfer of general ledger balances, invoices, and master data:

Transfer general ledger balances for the batch entry

File name: EXTF_Buchungsstapel_GL_YYYYMMDD_001.csv

  • GL: This indicates that the CSV file is for the transfer of general ledger balances.
  • YYYYMMDD: This indicates the current system date.
  • 001: This indicates the running number of the CSV file.

Transfer general ledger balances for the batch entry (for the file splitting)

File names: EXTF_Buchungsstapel_GL_YYYYMMDD_001.csv and EXTF_Buchungsstapel_GL_YYYYMMDD_002.csv

  • GL: This indicates that the CSV file is for the transfer of general ledger balances.
  • YYYYMMDD: This indicates the current system date.
  • 001 and 002: This indicate the running numbers for both CSV files. “001” contains the first 99,999 entries, whereas “002” contains the 100,000th entry and onwards.

Transfer invoices for the batch entry

File name: EXTF_Buchungsstapel_INV_YYYYMMDD_001.csv

  • INV: This indicates that the CSV file is for the transfer of invoices.
  • YYYYMMDD: This indicates the current system date.
  • 001: This indicates the running number of the CSV file.

Transfer invoices for the batch entry (for the file splitting)

File names: EXTF_Buchungsstapel_INV_YYYYMMDD_001.csv and EXTF_Buchungsstapel_INV_YYYYMMDD_002.csv

  • INV: This indicates that the CSV file is for the transfer of invoices.
  • YYYYMMDD: This indicates the current system date.
  • 001 and 002: This indicate the running numbers for both CSV files. “001” contains the first 99,999 entries, whereas “002” contains the 100,000th entry and onwards.

Transfer master data

File name: EXTF_DebKred_YYYYMMDD.csv

  • DebKred: This indicates that the CSV file contains debtor and creditor details.
  • YYYYMMDD: This indicates the current system date.

CSV sample files

The CSV sample files are displayed as follows:

Transfer GL balances


Transfer invoices


Transfer master data

 

     
 Main Category: Support Product Know How  Document Type: Release notes detail
 Category: Release Notes  Security  level: All - 0
 Sub category: Details  Document ID: 28.165.808
 Assortment: Exact Globe  Date: 30-11-2017
 Release:  Attachment:
 Disclaimer