Ir al contenido
Se marcó esta pregunta
inventoryimporting13.0
2 Respuestas
2750 Vistas
Avatar
Siavash Asadollahi

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
Descartar
Avatar
Thuy Ngoc
Mejor respuesta

Hi  Siavash,

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

Avatar
Descartar
Avatar
Niyas Raphy (Walnut Software Solutions)
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
Trying to import initial inventory in Odoo 15
inventory importing InventoryAdjustment
Avatar
Avatar
2
ago 22
3766
[13.0] Where to see why Transfer is "waiting for another operation" Resuelto
inventory transfer 13.0
Avatar
Avatar
1
sept 21
3837
Bulk import multiple serialised products
stock inventory importing
Avatar
0
mar 19
2805
[v11] Importing reordering rules - "location_id" required Resuelto
inventory reordering importing
Avatar
Avatar
2
abr 18
4654
Fedex Integration (2020) V12 - Belgium & International Resuelto
inventory quickstart 12.0 13.0
Avatar
Avatar
2
feb 24
3116