Odoo is not supporting MT940E for the bank statement format, so how to import it ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 회계
- 재고 관리
- PoS
- Project
- MRP
신고된 질문입니다
1
회신
4005
화면
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”
| 관련 게시물 | 답글 | 화면 | 활동 | |
|---|---|---|---|---|
|
2
1월 23
|
8334 | ||
|
1
2월 25
|
4983 | ||
|
0
7월 23
|
1196 | ||
|
1
2월 25
|
526 | ||
|
0
3월 24
|
711 |
