Es muss nicht immer eine komplizierte, teure oder pflegeintensive Schnittstelle zwischen Navision oder Business Central BC365 und Datev sein. Wenn Sie jedoch eine vollständige oder gar bidirektionale Schnittstelle suchen, dann finden Sie im Internet zahlreiche Anbieter dafür.
Manchmal (sogar erstaunlich oft) reicht es einfach aus, die monatlichen Buchungen aus Navision bzw. Business Central nach Datev zu übertragen. Einfach so.
To do this "just like that", however, you need...
Requirements
The Business Central or Navision chart of accounts has the same account numbers as the Datev chart of accounts. This does not necessarily have to be an SKR03 or SKR04, but the account numbers must match.
The same applies to customer numbers and vendor numbers.
Das war es schon an Voraussetzungen! Sollten Sie sich mit einer einfachen Schnittstelle wie dieser Buchungsübertragung von Navision /BC365 zu Datev anfreunden können, haben aber von ihrem Datev-Steuerberater abweichende Sachkonten- oder Debitoren/Kreditorennummern? OK, dann können wir dieses Kleine Manko auch leicht abstellen, indem wir die hier beschriebene Datev-Schnittstelle halt noch um eine kleine Übersetzung erweitern.
Vorsicht: Bidirektional, also von Datev zurück nach Navision oder Business Central BC365 wird dieses Tool dadurch nicht!
Output from Navision & Business Central
- the same customer numbers
- the same supplier numbers
- the same G/L account numbers
in Navision AND Datev
Regardless of your Datev connection, this is a clever and practical idea for everyday use anyway.
Import into Datev
You can import the Navision datev files directly via the posting batches...
...or via the regular import function. (In both cases the same import is technically started!)
They end up being imported in both ways:
This file sets practically all the settings shown below in Datev for the Navision import. Here you will find both the file itself, packed as 7z, and the file content. You can simply copy this into an empty XML file yourself.
<?xml version="1.0" standalone="yes"?>
<FormatDescription>
<Format>
<FormatId>1</FormatId>
<Description />
<Name>Navision</Name>
<StandardType>0</StandardType>
<Importable>1</Importable>
<Exportable>1</Exportable>
<DataCategory>Bewegungsdaten|Finanzbuchführung|Buchungsstapel</DataCategory>
<GroupSeperator>.</GroupSeperator>
<DecimalSeperator>,</DecimalSeperator>
<DateFormatExpression>TT.MM.JJJJ</DateFormatExpression>
<DateFormatSeperator />
<CurrencySignExpression />
<DirectoryName>C:\Temp</DirectoryName>
<FileName>Datevausgabe 01.01.19..31.01.19.csv</FileName>
<Version>1</Version>
<IsDefaultFormat>0</IsDefaultFormat>
</Format>
<Field>
<FieldId>1</FieldId>
<DisplayGroupId>106</DisplayGroupId>
<OrdinalNumber>0</OrdinalNumber>
<Label>Umsatz (ohne Soll/Haben-Kz)</Label>
<LabelAlias />
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>10</Length>
<DecimalPlaces>2</DecimalPlaces>
<FormatType>Betrag</FormatType>
<Necessary>1</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>1</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>351</BaseFieldId>
<FixedLength>16</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>2</FieldId>
<DisplayGroupId>106</DisplayGroupId>
<OrdinalNumber>1</OrdinalNumber>
<Label>Soll/Haben-Kennzeichen</Label>
<LabelAlias />
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>1</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Text</FormatType>
<Necessary>1</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>352</BaseFieldId>
<FixedLength>1</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>3</FieldId>
<DisplayGroupId>107</DisplayGroupId>
<OrdinalNumber>2</OrdinalNumber>
<Label>Kontonummer</Label>
<LabelAlias>Konto</LabelAlias>
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>9</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Konto</FormatType>
<Necessary>1</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>360</BaseFieldId>
<FixedLength>9</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>4</FieldId>
<DisplayGroupId>107</DisplayGroupId>
<OrdinalNumber>3</OrdinalNumber>
<Label>Gegenkonto (mit BU-Schlüssel)</Label>
<LabelAlias />
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>13</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Konto</FormatType>
<Necessary>1</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>362</BaseFieldId>
<FixedLength>13</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>5</FieldId>
<DisplayGroupId>108</DisplayGroupId>
<OrdinalNumber>4</OrdinalNumber>
<Label>Belegdatum</Label>
<LabelAlias />
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>8</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Datum</FormatType>
<CalculationRule>0=""</CalculationRule>
<Necessary>1</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>363</BaseFieldId>
<FixedLength>10</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>6</FieldId>
<DisplayGroupId>109</DisplayGroupId>
<OrdinalNumber>5</OrdinalNumber>
<Label>Belegfeld 1</Label>
<LabelAlias />
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>36</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Text</FormatType>
<Necessary>0</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>364</BaseFieldId>
<FixedLength>36</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>7</FieldId>
<DisplayGroupId>110</DisplayGroupId>
<OrdinalNumber>6</OrdinalNumber>
<Label>Buchungstext</Label>
<LabelAlias />
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>60</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Text</FormatType>
<Necessary>0</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>368</BaseFieldId>
<FixedLength>60</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<Field>
<FieldId>8</FieldId>
<DisplayGroupId>113</DisplayGroupId>
<OrdinalNumber>7</OrdinalNumber>
<Label>Festschreibung</Label>
<Importable>1</Importable>
<Exportable>1</Exportable>
<Length>1</Length>
<DecimalPlaces>0</DecimalPlaces>
<FormatType>Zahl</FormatType>
<Necessary>0</Necessary>
<IsFormatable>0</IsFormatable>
<DecimalsEditable>0</DecimalsEditable>
<GroupingSymbol>0</GroupingSymbol>
<CreditDebitSign>0</CreditDebitSign>
<BaseFieldId>3419</BaseFieldId>
<FixedLength>1</FixedLength>
<AddCreditDebitSign>0</AddCreditDebitSign>
<MaxCount>0</MaxCount>
</Field>
<CsvFormatProperties>
<CsvFormatPropertiesId>1</CsvFormatPropertiesId>
<FormatId>1</FormatId>
<SeperatorField>;</SeperatorField>
<SeperatorText>"</SeperatorText>
<DoubleTextSeperator>0</DoubleTextSeperator>
<LayoutStyle>variabel</LayoutStyle>
<Alignment>typabhängig</Alignment>
<Coding>ASCII</Coding>
<RowFrom>1</RowFrom>
<RowTo>-1</RowTo>
<Header>0</Header>
<Headline>1</Headline>
<EndLineWithSeperatorText>0</EndLineWithSeperatorText>
</CsvFormatProperties>
</FormatDescription>
Nevertheless, please check the following settings, especially e.g. the ASCII/Ansi setting.
Attention! Datev buffers the last import here! Please use the import preview to check whether Datev is displaying the current version of your Navision file.
If not, please select the file name again.
English 
Deutsch 
Español