Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Parts List to BOM Tranformation

By
F. Lee Erickson
on 7/14/16, 12:25 PM 194 views

I am researching part management systems.

I am hoping for a solution where my input for an assembly is a parts list with one record for each item.

I expect the system to convert such lists to a BOM with a consolidated recored for each of the mutlipule items of the same type.


Example Parts List

REF    Part

R1    1K

R2    4.7K

R3    1K


Example BOM

Part    QT    Ref

1K        2    R1, R3

4.7K    1    R2


I found no hits on Part List or Parts List for ODOO but perhaps I am not using the correct name.

Any insight would be of help.

Thanks,    

From your two examples, it looks like an assembly contains a part which is itself.

Both examples contain PART and REF.

If you have three component/purchased parts, your BOM should be a fourth item.

Example BOM

REF Qty Part

A1 2 R1

A1 2 R3

Robert Geleta
on 7/16/16, 1:37 PM
0
F. Lee Erickson
On 7/18/16, 10:20 AM

Hello Robert,

Regarding, "From your two examples, it looks like an assembly contains a part which is itself."

I am not sure what you mean.

However "REF    Part" is a column heading for the Parts list.  And "Part    QT    Ref" is a  column heading for the BOM.


The differenc is that there is one row for every reference designator in a Parts List. In the BOM the like parts are agrigated into a single record with a list of muliipule reference designators.


Here is a more complet exampel of a real parts list.


C1 33pF

C2 33pF

C3 33pF

C4 33pF

C5 33pF

C6 33pF

C7 33pF

C8 33pF

C9 33pF

C10 33pF

C11 33pF

C12 39pF

C13 33pF

C14 10nF

C15 33pF

C16 24pF

C17 33pF

C18 24pF

C19 33pF

C20 33pF

C21 33pF

C22 33pF

C23 33pF

C24 220uF/10V

C25 33pF

C26 33pF

C27 33pF

C28 33pF

C29 100nF

C30 100nF

C31 100nF

C32 100nF

C33 100nF

C34 10nF

C35 220uF/10V

C36 100nF

C37 39pF

C38 33pF

C39 10nF

C40 220uF/10V

C41 220uF/10V

C42 100nF

C43 100nF

C44 10uF/16V

C45 10nF

C46 1uF

C47 1uF

C48 390pF

C49 39pF

C50 220uF/10V

C51 1.2nF

C52 10nF

C53 220uF/10V

C54 10nF

C55 10nF

C56 220uF/10V

C57 33pF

C58 33pF

C59 39pF

C60 33pF

C61 10nF

C62 10nF

C63 12pF

C64 100nF

C65 33pF

C66 DNI

C67 10nF

C68 10nF

C69 33pF

C70 33pF

C71 100nF

C24b 10nF

CRTN1 CARTON_9X6X6

D1 1N4004

D2 BAT54A

D3 BAT54C

D4 MMSD914

D5 MBR0540 MBR0540

D6 BAT54C

D7 BAT54A

D8 MMSD914

D9 MMSD914

DB9M TO RJ45 ADAPTER1 RJ45_DB9M_EIA-561

DB9M TO RJ45 ADAPTER2 RJ45_DB9M_EIA-561

FI1 VR2004_1_20080112_Final Rev3

FM1 DNDP0909FM75

FW1 SOFTWARE_VR2004_VRXBOOT 1.3

FW2 SOFTWARE_APP: V1.10 POS

FW3 SOFTWARE EE file: SAM4_JOURNAL_9600_1Sec.ee

FW3_KIT SOFTWARE EE file: SAM4_JOURNAL_9600_1Sec.ee

Handling1 Handling Kits SAM4s10 or less

HANDSHAKE ADAPTER Sam4s HANDSHAKE_DB9F_SAM4

I1 INSULATOR_U49

I2 INSULATOR_U49

J1 CON_KK100_3

J2 CON_KK100_3

J3 CON_KK100_3

J4 CON_KK100_3

J5 CON_DC_POWER_2MM DIGI-KEY CP 202A-ND

J6 USB_B

J7 HEADER_100_6

J8 PIN-2-YY

J9 CON_KK100_2

JUMPER1 on J1 Pin1-2 JMPR_SHRT_2

JUMPER2 on J2 Pin1-2 JMPR_SHRT_2

JUMPER3 on J3 Pin1-2 JMPR_SHRT_2

L1 33uHSMD

L2 DNI

LBL1 LABEL_VR2004_UNIT

LBL2 LABEL_VR2004_CARTON_SAM4sKIT

LBL3 LABEL_GREEN_DOT

LBL4 on FM1 LABEL_VR2004_PWA

LED1 T1_GREEN

MF1 DNDP2525MF75

PCB1 PCB_VR2004_LC

POWER TRANSFORMER TRAN_9VDC_200MA_P7_PLG

Process1 Product Fulfillment Process_SAM4s

Product Fullment Process Product Fullment Process

PWA1 VR2004_1_20080112_PWA

Q1 MMBT2222

Q2 MMBT2907ALT1

Q3 MMBT2222

Q4 MMBT2907ALT1

Q6 MMBT2222

R1 39R

R2 39R

R3 39R

R4 39R

R5 39R

R6 39R

R7 39R

R8 39R

R9 39R

R10 39R

R11 39R

R12 39R

R13 39R

R14 39R

R15 10K

R16 39R

R17 39R

R18 1R

R19 100R

R20 470R

R21 39R

R22 39R

R23 1R

R24 1R

R25 10K

R26 1R

R27 1R

R28 39R

R29 39R

R30 1K

R31 39R

R32 DNI

R33 10K

R34 10R

R35 1R

R36 82R

R37 10K

R38 100K

R39 330R

R40 1R

R41 4.7K

R42 10K

R43 1R

R44 1K

R45 DNI

R46 1K

R47 DNI

R48 1K

R49 100R

R50 10R

R51 1K

R52 220R

R53 75R

R54 100R

R55 1.6K

R56 470R

R57 39R

R58 10K

R59 DNI

R60 1R

R61 330R

R62 1K

R63 10K

R64 10K

R65 10K

R66 10K

R67 1R

R68 DNI

R69 1R

R70 100K

R71 10K

R72 10K

R73 4.7K

R74 10K

R75 100R

R76 DNI

R77 4.7K

R78 4.7K

R79 4.7K

R80 4.7K

R81 10K

R82 1R

R83 DNI

R84 100R

R85 47K

R86 DNI

R87 100K

R88 1M

R89 10K

R90 10K

R91 DNI

R92 DNI

R93 1R

R94 10K

R95 39R

R96 1R

R97 100K

RCA TO RCA CABLE RCA_RCA_6FT

RDCE1 100R

RDCE2 DNI

RDCE3 100R

RDCE4 DNI

RDCE5 100R

RDCE6 100R

RDCE7 100R

RDCE8 100R

RDCE10 DNI

SETUP SHEET INSTALL_SHEET_SAM4s

SW1 SW_TACT_RT_NO

Test TEST_FACTORY_VR2004_V1

U1 18F4550_I_PT 18F4550_I_PT

U2 NOR SOT-23

U3 ADM208ARZ_Lead Free ADM208ARZ_Lead Free

U4 LM317-TO220

U5 LC74782M

W1 PCB_FEATURE

W2 PCB_FEATURE

W3 PCB_FEATURE

W4 PCB_FEATURE

W5 PCB_FEATURE

W6 PCB_FEATURE

W7 PCB_FEATURE

W8 PCB_FEATURE

WaveHand 1 WAVE_HAND_VR2004

X1 4MHz

X2 14.31818MHz


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/14/16, 12:25 PM
Seen: 194 times
Last updated: 7/18/16, 10:20 AM