I would like to import bank statement in openERP. I get errors even when I try to import a statement I just exported. Could anyone give a working csv sample, please? Regards
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Project
- MRP
Diese Frage wurde gekennzeichnet
I exported journal entries for the bank to get the template giving fields
journal_id/id
line_ids/account_id/id
line_ids/partner_id/id
line_ids/debit
line_ids/credit
line_ids/date
line_ids/internal_note
name
But it (v9) tells me that name (number is missing a required value. I've tried the name column with an existing statement number to no avail. The name field cannot be left out.
I don't know how to do this and will be entering manually otherwise.
Thanks
The CSV file fields must match the entity attributes. The best way to know them is first use the export resource after execute some view. This way you will have the right columns name and kind/type of value that will be consumed on import data.
Hope it helps you!
Hi. I did try this way several times before posting, unfortunately, for the bank statement, the system does not even import what I just exported. I export an "import compatible" csv from a bank statement I inserted manually in the system. Then I try to import it, and I get quite a few errors.
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
RegistrierenVerknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
---|---|---|---|---|
|
1
März 15
|
4436 | ||
|
1
Okt. 24
|
3329 | ||
|
3
Apr. 24
|
4267 | ||
|
1
Juni 23
|
1601 | ||
|
1
März 15
|
4009 |