Skip to Content
Menu
This question has been flagged
1 Odpoveď
4024 Zobrazenia

Odoo is not supporting MT940E for the bank statement format, so how to import it ?


Avatar
Zrušiť
Autor Best Answer

Here is an Excel Template where you can paste your MT940E format and in the third tab this one will be automatically converted into an excel import template made for Odoo. 

Three things to do : 

  • Paste your file in the excel template 

  • Change the id of the bank statement in the third tab to not have duplicated id 

  • Bonus : Vlookup on partner_id to have the partner_id/id 

    • By adding a fourth tab with all your contacts and ids you can automate this step 

Then import in Odoo via model = account.bank.statement


PS : if you want to look into a formula don’t forget to valid it back by clicking on “Ctrl+Shift+Enter” and not just “Enter”


MT940E Import Template


Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
2
jan 23
8344
1
feb 25
4988
0
júl 23
1200
1
feb 25
535
0
mar 24
716