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
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
1
Odpowiedz
3039
Widoki
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
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
1
lut 18
|
4485 | ||
|
1
lut 24
|
2173 | ||
|
2
lut 21
|
6637 | ||
|
how to format mapped() result
Rozwiązane
|
|
2
cze 20
|
11402 | |
|
5
lut 20
|
3621 |
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