Document Control Revision History in Manually Created BOM's (Bill of Materials)

T

Trakman

#1
Revision History in Manually Created BOM's

Hi Folks,

Recently, I reviewed some material and find that our BOM's that are created in Excel (manually!) have no revision history in them at all. All other drawings and documents have revision history in them. The problem becomes very annoying when an ECN is processed, and without the revision history on the BOM, we cannot tell if it has been updated with the ECN information.

So I sent a CAR to Doc Ctrl for them to include revision history in BOM's, and there was literally a refusal to do so; "I have never done this so I won't do it now..." also, the revision history is included as a comment, but few people know how to print the document with comments, so for most people the hardcopy will never have revision history.

Question: Does this sound reasonable to request that the revision history be included in BOM's particularily when they are manually derived? Is this done in other companies?

Thanks!

Trakman
 
Elsmar Forum Sponsor

CarolX

Super Moderator
Super Moderator
#2
Trackman,

How often is your bill of material revised? Most BOM's I have used do not track revisions of the individual components. Is that what you are after?

Ask this question, what does revision history get you? What are the implications of not having rev history on the BOM's?

If you find it really is neccessary, enlist the help of Doc Control. Buy in will be easier if they can develope the method for it.

Have fun!!!

CarolX
 

E Wall

Just Me!
Super Moderator
#3
Revision History in Manually Created BOM's

Our system documents BOMs by part number and revision level but no history. This information is available to anyone with access to the system. The changes made are not indicated in the program (J.D. Edwards), but on the ECO [Engineering Change Order] which all who are impacted by the change must review and approve.

I've sent my Materials Manager the question "Is it possible to see a change history on a single part/component?" I'll be sure to let you know what he replys....*grin* Already I know his first response: "Why do you want to know?"
 
T

Trakman

#4
Thanks CarolX and EWall,

Well what I am after is for Doc Ctrl to list the ECN's (or ECO's as you may be familiar with...) that have impacted changes to it. I am not looking for typo changes, or every revision of each component. I understand that it would be a monumental (emphasis on mental!!) undertaking to list all that.

The main reason is to provide a reference to the ECN on the BOM so that forced changes can be linked to an ECN so that everyone can see that the BOM has been updated. With our system of doing all things manually, I believe that this would serve the purpose of ensuring that all ECN mandated documents are in fact updated, as there is some serious tardiness in Doc Ctrl dept. to get the ECN's done.

(Audit question: Show me that the ECN has been fully implemented...)

Is this a reasonable request or
does this open up another can of worms,
or am I overly picky?

:confused:

Thanks!

Trakman.
 

E Wall

Just Me!
Super Moderator
#5
Revision History in Manually Created BOM's

Two things...
Show the ECN has been fully implemented-
This presumes the first identifier is the ECN which should list the BOM Part # and both the current revision and the change revision levels (FROM - TO). Whatever system is in place should be able to quickly verify what the current BOM revision is, as well as review the relevant details to confirm the changes were made.

ECN Information on BOM-
What a great idea! Headache? Maybe...awww, whose kidding who...heck yea! But we do put the change numbers on all our specs and work instructions. We show them as the 'approval by' information...So, why not BOMs? I guess a lot will depend on what kind of tracking system (software) you have in place an how easy it is to make modifications to it. I know for us that would be very costly in and of itself and everyone would try other options first.

What our company does is this:
1. BOM change need identified
2. ECO/ECN inititated
3. All respond approved to DC
4. DC sends ECO/ECN to Finanace to enter BOM Change Data/Info
5. Finance returns ECO/ECN to DC when completed (with sign-off)
6. ECO is issued out and notification form has block to be completed by the 'originator' to verify the changes are in the system.
#6 serves as both notification and follow-up verification.

I really don't see that there would be any difference in the steps if DC handled the BOM updated themselves other than skipping 4 & 5. We use Finanace because there are usually costing issues involved and this acts as their notification as well, because costing information then goes elsewhere too. Sounds confusing doesn't it? But, it works.

If the work (processing ECNs & updating BOMs) is getting done and the issue is really how 'long' it takes...there may be other areas that need to be addressed. Is the person responsible lolly-gagging around or actually busy? Are additional resources required or a shifting of some responsibilities? Either way for the BOM update issue...maybe tracking approval recipt time vs data entry time as a metric should be done with the improvement goal of reduction to 0!
 
Last edited:
A

Al Dyer

#6
A Bill of Material is a controlled document in that it contains the information required by the company. Once the BOM is filled out it then becomes a "RECORD", with no need of revision level change.
 
T

Trakman

#7
Al,

Yes, Yes, YES! You are Right!, it is a quality record! That's that part I was missing! :D

Therefore revisions are not necessary, but old records ARE.
Ah yes, the lights are coming on now! :rolleyes:

So now I need to eat some humble pie and close the CAR I issued to Doc Ctrl, BUT, first I will make sure that iterations of BOMs before changes are being saved (printed off) now that they fall in the quality record camp (ISO9001: 2K;4.2.4, '94;4.16)

It is now making sense folks, and I am sure that we all get stuck in an incorrect mental loop every now and then.

Many thanks to all that provided the much needed insight. I will be sure the return the kindness in responding to others' concerns within Cayman Cove Forums.

I think that this wraps it up nicely!

Trakman.
;)
 
Thread starter Similar threads Forum Replies Date
M Document Control - Revision Number in Document Names Document Control Systems, Procedures, Forms and Templates 4
C Document Control - old revision vs new revision Document Control Systems, Procedures, Forms and Templates 22
M Where does Document Revision Control Start? Rev 0 or Rev 1 Document Control Systems, Procedures, Forms and Templates 19
I Document Control - Document Revision History Question Document Control Systems, Procedures, Forms and Templates 16
L Document Control Procedure - Revision Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 15
T Document Control Revision - Starting Over Document Control Systems, Procedures, Forms and Templates 1
Z Revision Number vs. Issue Number - Document Control in ISO 17025:2005 ISO 17025 related Discussions 8
G Revision Control - Per document vs Universal control Document Control Systems, Procedures, Forms and Templates 7
F Document Control and Document Revision Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 14
M Document Control Software Program with Revision Tracking Recommendations Document Control Systems, Procedures, Forms and Templates 7
A Document Revision Control - Use alphabets or date? Quality Manager and Management Related Issues 18
R Document and Quality Manual Revision Control requirements - Alpha or Numeric Document Control Systems, Procedures, Forms and Templates 4
D Document Control Management System (MyDMS) & Revision Time Frames Document Control Systems, Procedures, Forms and Templates 3
L Document Control - Document Version or Document Revision? Document Control Systems, Procedures, Forms and Templates 12
L Document Version or Document Revision? Document Control Document Control Systems, Procedures, Forms and Templates 18
kisxena Issued travelers that have out-dated revision - 21 CFR 820.40 - Document Control Document Control Systems, Procedures, Forms and Templates 10
D Document Revision Numbers and Control of Documents Document Control Systems, Procedures, Forms and Templates 18
I Document Control on Log Files ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Q Tracking Procedure Revisions (Document Control) Document Control Systems, Procedures, Forms and Templates 9
C Document Control Stamps - Does anyone still stamp their documents? Document Control Systems, Procedures, Forms and Templates 24
I Control of Documentation Distribution - Document Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
T Control of downloaded document copies by employees Document Control Systems, Procedures, Forms and Templates 3
T Document control ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 5
O Vendor vs Engineering Document Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
A ISO9001:2015 Document control and training aids ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
GreatNate Document Control info - What is required on a controlled form/document for ISO 9001: 2015? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
J Document Control Software Needed ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
I First Time Implementing Document Control for ISO-9001 - how far back do you go? Document Control Systems, Procedures, Forms and Templates 15
I Document Control Workflow Document Control Systems, Procedures, Forms and Templates 2
D ISO 9001:2015 8.5.6 and 7.5.3 Document Control Questions Document Control Systems, Procedures, Forms and Templates 50
R Changing Document Control software. Must I transfer EVERYTHING? Document Control Systems, Procedures, Forms and Templates 3
B Referencing to Supplier Outputs within our Document Control System 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
Sidney Vianna IAF Mandatory Document #23 - Control of CB Franchisees and Agents Registrars and Notified Bodies 3
D Software for advancing with Document Control Quality Assurance and Compliance Software Tools and Solutions 4
L IATF 16949 Cl. 7.1 - Lotus Notes for Document Control IATF 16949 - Automotive Quality Systems Standard 0
A Removing purchase order form from document control - should it be done? Document Control Systems, Procedures, Forms and Templates 9
I Video under Document Control SOP ISO 13485:2016 - Medical Device Quality Management Systems 2
S Change Control Form vs. Document Change Notification ISO 13485:2016 - Medical Device Quality Management Systems 3
S Document control for tooling drawings (Document control clause 7.5.3) IATF 16949 - Automotive Quality Systems Standard 5
J Document Control Newbie - Control of Nonconforming / Returns Log AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 8
P Document Control - Do hard copies of documents need to be signed? Document Control Systems, Procedures, Forms and Templates 3
R External Standards List (Document Control) Document Control Systems, Procedures, Forms and Templates 3
M Retiring documents in Document Control Procedures ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
R Managing Level 3 Production Documents - Document Control System Help Document Control Systems, Procedures, Forms and Templates 6
M Cross Function Process Map for Document Control Process Maps, Process Mapping and Turtle Diagrams 3
0 How to deal with resistance to GDP Document Control Discipline Document Control Systems, Procedures, Forms and Templates 7
dubrizo Restructuring Document Control Numbering System Document Control Systems, Procedures, Forms and Templates 3
G Migrating to an ISO 13485:2016 Compliant Document Control System ISO 13485:2016 - Medical Device Quality Management Systems 6
E Document Control MS Access Database Document Control Systems, Procedures, Forms and Templates 39
S Looking for Document Control Templates Document Control Systems, Procedures, Forms and Templates 1

Similar threads

Top Bottom