콘텐츠로 건너뛰기
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
모든 게시물 사용자 배지
태그 (모두 보기)
odoo accounting v14 pos v15
게시판 정보
신고된 질문입니다
inventoryimporting13.0
2 답글
2352 화면
아바타
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
8월 22
3505
[13.0] Where to see why Transfer is "waiting for another operation" 해결 완료
inventory transfer 13.0
아바타
아바타
1
9월 21
3619
Bulk import multiple serialised products
stock inventory importing
아바타
0
3월 19
2648
[v11] Importing reordering rules - "location_id" required 해결 완료
inventory reordering importing
아바타
아바타
2
4월 18
4496
Fedex Integration (2020) V12 - Belgium & International 해결 완료
inventory quickstart 12.0 13.0
아바타
아바타
2
2월 24
2884