I create a new database and then I create a customer invoice and export it. I then change the values in the file to other names and amounts.
When I try to re-import there is no way to map the fields that do not show up in the list (Invoice partner display name, signed total, etc..)
I do not understand why it exports to a file with wrong field names???
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
1
Balas
3826
Tampilan
Hello,
here is the best way to handle this situation:
1. when you have to update existing record => select the record/records -> action(export) -> check "i want to update..." -> select the required fields -> export.
- this will allow you to export th External Id of this record "unique per every record on the database"
- the excel file will has the first row with technical name of fields which have been chosen in step 1, which will automatically matches the existing fields during import process
2. update/add records
3. activate developer mode -> go to import -> choose your update file-> test-> import
Note: make sure to check "i want to update..." during export process and make sure to import based on this external ID to update this specific record
for simplicity those are main fields to import
| External ID | Number | Partner | Invoice/Bill Date | Due Date | Reference | Invoice Lines / Unit Price | Invoice Lines / Account | Invoice Lines / Label | currency_id |
hope this will help
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
1
Feb 18
|
5074 | ||
|
1
Feb 24
|
2852 | ||
|
2
Feb 21
|
7668 | ||
|
how to format mapped() result
Diselesaikan
|
|
2
Jun 20
|
12262 | |
|
Financial Transaction Mapping: Debit/Credit (v13.0)
Diselesaikan
|
|
5
Feb 20
|
4263 |
Just share any screenshots of the error. Usually, there is an option to select while you export the data. Make sure it's true.
"I want to update data (import-compatible export)"
I donI don't seem to be able to attached images here.. But you can see a screenshot here: https://www.kbsf.dk/wp-content/uploads/errors.png