Stats

  • State Not Answered
  • Replies 2
  • Subscribers 50
  • Views 117
  • Members are here 0
More Content

Control Bill Of Materials of different revision

Filo221

I'm looking for some advice on BOM management and revision control.

I use a multi-sheet Excel file, where each worksheet represents a different variant in the CIS. For every modification, I update the revision and date of the corresponding worksheet.

We are talking about BOMs with approximately 1,500 components. Once the BOM has been exported from the CIS, what checks do you typically perform?

Is there a tool available that can compare two BOMs and provide a detailed report of the differences?

Thanks 

Parents
  • 0

    Hi  ,

    Could you provide a bit more detail on your workflow? Are these worksheets representing different design revisions or different assembly variants, and what specific differences are you typically looking to verify after exporting the BOM (added/removed parts, quantity changes, MPN/value changes, DNI/DNP status, etc.)?

    Also, if you are comparing different design revisions, have you tried Tools > Compare Design? It can help identify schematic-level differences such as added or deleted parts, property changes, connectivity changes, and net differences between design revisions.

  • 0 in reply to TechnoBobby

    Hi Techonobody , sorry for the late reply, but I've been sick.

    I am not referring to a schematic modification, but only to a change in MPN and quantity. I use CIS to make these changes.

    For Example, I have  to create new version whit a different  nominal voltage. I have to change many component (80 MPN) comparate to start version.

    Then I export the new BOM in my excel file and I use an Excel macro to compare the BOM of the original variant with the new one. The output is a file containing all the differences, which I then review one by one. When many components are changed, there is always a risk that some differences may be overlooked.

    I am wondering whether there is a safer procedure or any software tools (including paid solutions) that can ensure a more reliable and error-proof BOM comparison process.

Reply
  • 0 in reply to TechnoBobby

    Hi Techonobody , sorry for the late reply, but I've been sick.

    I am not referring to a schematic modification, but only to a change in MPN and quantity. I use CIS to make these changes.

    For Example, I have  to create new version whit a different  nominal voltage. I have to change many component (80 MPN) comparate to start version.

    Then I export the new BOM in my excel file and I use an Excel macro to compare the BOM of the original variant with the new one. The output is a file containing all the differences, which I then review one by one. When many components are changed, there is always a risk that some differences may be overlooked.

    I am wondering whether there is a safer procedure or any software tools (including paid solutions) that can ensure a more reliable and error-proof BOM comparison process.

Children
No Data
Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.