Skip ke Konten
Pertanyaan ini telah diberikan tanda
inventoryimporting13.0
2 Replies
2313 Tampilan
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
Buang
Avatar
Thuy Ngoc
Jawaban Terbai

Hi  Siavash,

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

Avatar
Buang
Avatar
Niyas Raphy (Walnut Software Solutions)
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
Trying to import initial inventory in Odoo 15
inventory importing InventoryAdjustment
Avatar
Avatar
2
Agu 22
3477
[13.0] Where to see why Transfer is "waiting for another operation" Diselesaikan
inventory transfer 13.0
Avatar
Avatar
1
Sep 21
3607
Bulk import multiple serialised products
stock inventory importing
Avatar
0
Mar 19
2620
[v11] Importing reordering rules - "location_id" required Diselesaikan
inventory reordering importing
Avatar
Avatar
2
Apr 18
4478
Fedex Integration (2020) V12 - Belgium & International Diselesaikan
inventory quickstart 12.0 13.0
Avatar
Avatar
2
Feb 24
2844