search

ledger123 / runmyaccounts

SQL-Ledger Customizations by Run My Accounts
GNU General Public License v2.0
16 stars 9 forks source link

[IBP-1025] - DATEV Import #516

Open MariaHashimi opened 5 months ago

MariaHashimi commented 5 months ago

We need to import DATEV Data for MTK and our other german clients

The export was already done in the following ticket : https://github.com/ledger123/runmyaccounts/issues/52

ledger123 commented 4 months ago

Hi @MariaHashimi ,

I have made changes to import the datev file.

To import datev file, you will go to General Ledger import and check the DATEV file checkbox and specify your datev file for import.

image

Here is sample datev file I have tested this script with:

reference,department,description,transdate,debit_accno,credit_accno,amount "AP-010","HARDWARE","","13-06-2023","5000","2100","100.00" "AP-010","HARDWARE","","13-06-2023","1206","2100","5.00" "AP-011","HARDWARE","","27-06-2023","5000","2100","100.00" "AP-011","HARDWARE","","27-06-2023","1206","2100","2.00" "AP-012","HARDWARE","","22-01-2024","5000","2100","100.00" "AP-012","HARDWARE","","22-01-2024","1205","2100","15.00" "AP-012","HARDWARE","","22-01-2024","2205","2100","15.00" "AP-013","HARDWARE","testmha415","28-03-2024","5000","2100","100.00" "AP-013","HARDWARE","testmha415","28-03-2024","2205","1205","5.50"

With this checkbox checked, import script will convert the datev file into standard GL import. image

On clicking 'Import GL' button, all transactions will be imported as GL transactions. Transactions with same reference in datev file will become one GL transaction.

image

If you want me to test with your sample datev file, you can send it to me and I will do the testing and make any changes as needed.

Regards

MariaHashimi commented 3 months ago

I've forwarded the "mapping-file" to our german partners, waiting for their answer