İçereği Atla
Menü
Bu soru işaretlendi
2 Cevaplar
2325 Görünümler

Hello,

I'm trying to update my inventory database of around 3200 entries with new cost values based on the vendor price. First, I'm exporting the entire inventory with "I want to update data (import-compatible export)" checked. I copy 'Vendors / Price' field into the 'Cost' field in the xlsx file, and then I try to import the file back into Odoo. I'm only importing the External ID field and the Cost field, but I keep getting this error:

Unknown error during import: : Wrong value for account\.move\.type:\ 'product'\ at\ 872 different\ rows:

This\ is\ followed\ by\ a\ list\ of\ row\ numbers\.\ I\ cannot\ understand\ what\ is\ different\ with\ these\ rows,\ as\ far\ as\ I\ can\ see\ the\ associated\ products\ are\ very\ similar\ to\ the\\ rest,\\ but\ somehow\ account\.move\.type is\ not\ set\ correctly\ for\ them\?\ I\ tried\ adding\ 'product'\ to\ the\ selection\ options\ of\ account.move.type field to no avail.

This is happening on Odoo v13.0 community edition. Any ideas what's happening here? 

Avatar
Vazgeç
En İyi Yanıt

Hi  Siavash,

I think this video can help you: https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1

Avatar
Vazgeç
En İyi Yanıt

Hi,
You have to ensure that the value you are importing to type field of account.move has to be from the available values.

type = fields.Selection(selection=[
('entry', 'Journal Entry'),
('out_invoice', 'Customer Invoice'),
('out_refund', 'Customer Credit Note'),
('in_invoice', 'Vendor Bill'),
('in_refund', 'Vendor Credit Note'),
('out_receipt', 'Sales Receipt'),
('in_receipt', 'Purchase Receipt'),
], string='Type', required=True, store=True, index=True, readonly=True, tracking=True,
default="entry", change_default=True)



Thanks

Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
2
Ağu 22
3486
1
Eyl 21
3608
0
Mar 19
2628
2
Nis 18
4485
2
Şub 24
2856