Skip to Content
This question has been flagged
inventoryimporting13.0
2 Replies
2708 Views
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
Discard
Avatar
Thuy Ngoc
Best Answer

Hi  Siavash,

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

Avatar
Discard
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

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
Discard
Related Posts Replies Views Activity
Trying to import initial inventory in Odoo 15
inventory importing InventoryAdjustment
Avatar
Avatar
2
Aug 22
3748
[13.0] Where to see why Transfer is "waiting for another operation" Solved
inventory transfer 13.0
Avatar
Avatar
1
Sep 21
3820
Bulk import multiple serialised products
stock inventory importing
Avatar
0
Mar 19
2762
[v11] Importing reordering rules - "location_id" required Solved
inventory reordering importing
Avatar
Avatar
2
Apr 18
4632
Fedex Integration (2020) V12 - Belgium & International Solved
inventory quickstart 12.0 13.0
Avatar
Avatar
2
Feb 24
3090