It doesn't always have to be a complicated, expensive or high-maintenance interface between Navision and Business Central and Datev. If you are looking for a complete or even bidirectional interface, you will find numerous providers on the Internet.
Sometimes (even surprisingly often) it is simply sufficient to transfer the monthly postings from Navision or Business Central to Datev.
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.
That's all the requirements!
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