Wrong value for account.move.type when trying to import xlsx file to inventory

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
Project
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Wrong value for account.move.type when trying to import xlsx file to inventory

inventory importing 13.0

2 الردود

2756 أدوات العرض

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?

Thuy Ngoc

Hi Siavash,

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

Niyas Raphy (Walnut Software Solutions)

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

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Trying to import initial inventory in Odoo 15 inventory importing InventoryAdjustment	2 أغسطس 22	3767
[13.0] Where to see why Transfer is "waiting for another operation" تم الحل inventory transfer 13.0	1 سبتمبر 21	3837
Bulk import multiple serialised products stock inventory importing	0 مارس 19	2806
[v11] Importing reordering rules - "location_id" required تم الحل inventory reordering importing	2 أبريل 18	4655
Fedex Integration (2020) V12 - Belgium & International تم الحل inventory quickstart 12.0 13.0	2 فبراير 24	3117

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!