Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Datev data

Archives

Contributors

OCA/bank_statement_import - Odoo 16, Switzerland

Odoo barcode range scanning functionality

Datev data

Dear OCA,

i got an issue from a customer, that uses a very specific accounting chart in germany.

As they want to perform the accounting on their own before sending it to the acc. Consultant, some adaption seem to be mandatory.

In order to create smooth convertability between the datev-export provided by odoo and the import in the system of t he accounting consultant, the data needs to be modified. So this is the feedback i got from the consultant about the export data.

 

  • The code number for the account number extension (KNE) needs to start with digit number 4 instead of a 8 digit number. This is not a problem and provided by the Odoo enterprise core export tool.

  • Exported CSV-files needs to be encoded in Windows ANSI

  • Debit/credit indicators are only allowed in capital letters "S" or "H". The standard Odoo export provides small letters

  • EXTF Version 700 instead of 510 is important when recording with empty and modified headings in the header

 

The export is provided by the modules „l10n_de_datev_reports“ & „l10n_de_reports“

The encoding can be changed after exporting, same for the capital letters. But to keep it as simple as possible for the customer, it would be great to have this included in the export function. Covering the other way as well would be awesome.

 

Is anbody aware of a solution, that already provides this kind of modification?

 

Would be very thankful for some hints concering that topic.

 

All the best

Nils

-- 

NICO SOLUTIONS - ENGINEERING & IT 
Inhaber (Owner): Nils Coenen 
Dr.-Ruckert-Str. 1G 
28865 Lilienthal 
Deutschland (Germany) 
Ust.-Idnr. (VAT-ID): DE341437044 

 

by Nils Coenen - 12:26 - 3 May 2023

Follow-Ups

  • Re: Datev data

    Many thanks Holger Brunn for linking the appropriate PR´s. I´ll have a closer look.

     

    @Thomas Pot: i would appreciate sharing your experience. Even if i am not involved in the dev of the mentioned modules yet…

    I think we can only benefit from it.

    BTW: I am facing this issue now on v16.

     

    I´ll give it a try modifying the odoo functions manually and see, what kind of problems will occur.

    It sounds like, that a corresponding module would be of interest to many users?! 
     

    All the best

    Nils

    -- 

    NICO SOLUTIONS - ENGINEERING & IT 
    Inhaber (Owner): Nils Coenen 
    Dr.-Ruckert-Str.     1G 
    28865 Lilienthal 
    Deutschland (Germany) 
    Ust.-Idnr. (VAT-ID): DE341437044 

     

     

    Von: Thomas Pot <notifications@odoo-community.org>
    Antworten an: "Odoo Community Association (OCA) Contributors" <contributors@odoo-community.org>
    Datum: Mittwoch, 3. Mai 2023 um 14:41
    An: Contributors <contributors@odoo-community.org>
    Betreff: Re: Datev data

     

    Hello All,

     

    We encountered also several issue's in the DATEV export function in Odoo EE. because of the urgent matters at that point we decided to override the default functions in Odoo.

    We reported our issue's to Odoo but as far as I know, there are no actions taken for some.

    It also depends on the used version; v15 is different from V13. (and already better)

     

    But we would be happy to share our experience with the community? 

     

     

    Met vriendelijke groet - Kind Regards - Mit freundlichen Grüßen,

    Thomas Pot

     

    Open2Bizz - dé Odoo specialist

    Mauritslaan 56 | 6161 HW | Geleen

     

    Maak meteen een afspraak voor een online demo van Odoo / Open2Ortho:

    Klik hier

     

    Van: "Holger Brunn" <notifications@odoo-community.org>
    Aan: "Contributors" <contributors@odoo-community.org>
    Onderwerp: Re: Datev data

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by Nils Coenen - 03:00 - 3 May 2023
  • Re: Datev data
    Hello All,

    We encountered also several issue's in the DATEV export function in Odoo EE. because of the urgent matters at that point we decided to override the default functions in Odoo.
    We reported our issue's to Odoo but as far as I know, there are no actions taken for some.
    It also depends on the used version; v15 is different from V13. (and already better)

    But we would be happy to share our experience with the community? 


    Met vriendelijke groet - Kind Regards - Mit freundlichen Grüßen,
    Thomas Pot

    Open2Bizz - dé Odoo specialist
    Mauritslaan 56 | 6161 HW | Geleen

    Maak meteen een afspraak voor een online demo van Odoo / Open2Ortho:
    Klik hier

    Van: "Holger Brunn" <notifications@odoo-community.org>
    Aan: "Contributors" <contributors@odoo-community.org>
    Onderwerp: Re: Datev data
    by "Thomas Pot" <thomas@open2bizz.eu> - 02:40 - 3 May 2023
  • Re: Datev data 
    > i know that Thorsten Vocks and Holger Brunn, are currently working the old

> CSV tooling for Datev Back and Forth (in a specific customer project). The

> code is not yet published but if i am not mistaken it will be soon.

you can find both on https://github.com/OCA/l10n-germany/pulls in #118 and #121


-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com
    by Holger Brunn - 01:25 - 3 May 2023

    1 attachments 1 attachments

    signature.asc
  • Re: Datev data

    Hi Frederick,

    many thanks for your reply.

     

    If there is something in progress for sharing with the OCA… would be great to have a feedback about the status.

     

    I would like to provide input as well on this task. For now, I am not able to say if my dev skills will be sufficient in this case.

    Still learning a lot. Especially in terms of using git in collab. Considering to keep it economic, i decided to ask here first.

     

    I think a contribution by the customer can be achieved. Depending an the budget needed of course.

     

    I will have an eye on OCA/l10n-germany and i will talk to the customer.

     

    If Thorsten Vocks and/or Holger Brunn are willing to provide some infos… that would be great.

     

    And many thanks for the offer of calling you on your mobile. I will fall back on it if necessary.

     

    All the best

    Nils

     

    -- 

    NICO SOLUTIONS - ENGINEERING & IT 
    Inhaber (Owner): Nils Coenen 
    Dr.-Ruckert-Str.     1G 
    28865 Lilienthal 
    Deutschland (Germany) 
    Ust.-Idnr. (VAT-ID): DE341437044 

     

    Von: Frederik Kramer <notifications@odoo-community.org>
    Antworten an: "Odoo Community Association (OCA) Contributors" <contributors@odoo-community.org>
    Datum: Mittwoch, 3. Mai 2023 um 12:52
    An: Contributors <contributors@odoo-community.org>
    Betreff: Re: Datev data

     

    Hi Nils,

    i know that Thorsten Vocks and Holger Brunn, are currently working the old CSV tooling for Datev Back and Forth (in a specific customer project). The code is not yet published but if i am not mistaken it will be soon. So maybe either of those two can comment. Definitely most of your feedback (or better the one of your consultant) is somewhat known already within the group of OCA contributors working on the OCA Datev modul set. If you don't have own development skill but your customer is willing to contribute financially to develop an Open Source solution thats is typically the easiest and fastest way to get contributors attention. If you have further questions or suggestions to make you can always give me a call on my mobile

    Best Frederik

    Am 03.05.23 um 12:27 schrieb Nils Coenen:

    Dear OCA,

    i got an issue from a customer, that uses a very specific accounting chart in germany.

    As they want to perform the accounting on their own before sending it to the acc. Consultant, some adaption seem to be mandatory.

    In order to create smooth convertability between the datev-export provided by odoo and the import in the system of t he accounting consultant, the data needs to be modified. So this is the feedback i got from the consultant about the export data.

     

    • The code number for the account number extension (KNE) needs to start with digit number 4 instead of a 8 digit number. This is not a problem and provided by the Odoo enterprise core export tool.

    • Exported CSV-files needs to be encoded in Windows ANSI

    • Debit/credit indicators are only allowed in capital letters "S" or "H". The standard Odoo export provides small letters

    • EXTF Version 700 instead of 510 is important when recording with empty and modified headings in the header

     

    The export is provided by the modules „l10n_de_datev_reports“ & „l10n_de_reports“

    The encoding can be changed after exporting, same for the capital letters. But to keep it as simple as possible for the customer, it would be great to have this included in the export function. Covering the other way as well would be awesome.

     

    Is anbody aware of a solution, that already provides this kind of modification?

     

    Would be very thankful for some hints concering that topic.

     

    All the best

    Nils

    -- 


    NICO SOLUTIONS - ENGINEERING & IT 
    Inhaber (Owner): Nils Coenen 
    Dr.-Ruckert-Str.     1G 
    28865 Lilienthal 
    Deutschland (Germany) 
    Ust.-Idnr. (VAT-ID): DE341437044 

     

    -- 
    Dr.-Ing. Frederik Kramer
    Geschäftsführer
     
    initOS GmbH
    Innungsstraße 7
    21244 Buchholz i.d.N.
     
    Phone:  +49 4181 13503-12
    Fax:    +49 4181 13503-10
    Mobil:  +49 179 3901819
     
    Email: frederik.kramer@initos.com
    Web:   www.initos.com
     
    Geschäftsführung:
    Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
     
    Sitz der Gesellschaft: Buchholz i.d.N.
    Amtsgericht Tostedt, HRB 205226
    Steuer-Nr: 15/200/53247
    USt-IdNr.: DE815580155

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    by Nils Coenen - 01:21 - 3 May 2023
  • Re: Datev data

    Hi Nils,

    i know that Thorsten Vocks and Holger Brunn, are currently working the old CSV tooling for Datev Back and Forth (in a specific customer project). The code is not yet published but if i am not mistaken it will be soon. So maybe either of those two can comment. Definitely most of your feedback (or better the one of your consultant) is somewhat known already within the group of OCA contributors working on the OCA Datev modul set. If you don't have own development skill but your customer is willing to contribute financially to develop an Open Source solution thats is typically the easiest and fastest way to get contributors attention. If you have further questions or suggestions to make you can always give me a call on my mobile

    Best Frederik

    Am 03.05.23 um 12:27 schrieb Nils Coenen:

    Dear OCA,

    i got an issue from a customer, that uses a very specific accounting chart in germany.

    As they want to perform the accounting on their own before sending it to the acc. Consultant, some adaption seem to be mandatory.

    In order to create smooth convertability between the datev-export provided by odoo and the import in the system of t he accounting consultant, the data needs to be modified. So this is the feedback i got from the consultant about the export data.

     

    • The code number for the account number extension (KNE) needs to start with digit number 4 instead of a 8 digit number. This is not a problem and provided by the Odoo enterprise core export tool.
    • Exported CSV-files needs to be encoded in Windows ANSI
    • Debit/credit indicators are only allowed in capital letters "S" or "H". The standard Odoo export provides small letters
    • EXTF Version 700 instead of 510 is important when recording with empty and modified headings in the header

     

    The export is provided by the modules „l10n_de_datev_reports“ & „l10n_de_reports“

    The encoding can be changed after exporting, same for the capital letters. But to keep it as simple as possible for the customer, it would be great to have this included in the export function. Covering the other way as well would be awesome.

     

    Is anbody aware of a solution, that already provides this kind of modification?

     

    Would be very thankful for some hints concering that topic.

     

    All the best

    Nils

    -- 

    NICO SOLUTIONS - ENGINEERING & IT 
    Inhaber (Owner): Nils Coenen 
    Dr.-Ruckert-Str.     1G 
    28865 Lilienthal 
    Deutschland (Germany) 
    Ust.-Idnr. (VAT-ID): DE341437044 

     

    _______________________________________________
    Mailing-List: https://odoo-community.org/groups/contributors-15
    Post to: mailto:contributors@odoo-community.org
    Unsubscribe: https://odoo-community.org/groups?unsubscribe

    -- 
Dr.-Ing. Frederik Kramer
Geschäftsführer

initOS GmbH
Innungsstraße 7
21244 Buchholz i.d.N.

Phone:  +49 4181 13503-12
Fax:    +49 4181 13503-10
Mobil:  +49 179 3901819

Email: frederik.kramer@initos.com
Web:   www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155
    by Frederik Kramer - 12:51 - 3 May 2023