We have a new part that will be taking the place of an existing part, but only in some of the bills in which the current part is used in. The existing part is used in hundreds of bills, but it is only a suitable replacement in less than a hundred of the existing bill of materials. I could manually make the change one by one but I had another idea. Could I enter a Replace/Delete Component Entry in the system and it will identify all the bills that need to be changed. Then I could run the register but not update it, just leave it at the point where it is asking if I want to update. Then I could use Data File Display and Maintenance to delete the bills that should NOT have the replacement performed. Will this work?
Would it be better to just create something using VI and import into the BM_ReplaceDeleteCompWork, Header and Detail files?
What suggestions on how to do a replace entry that only applies to a subset of the bill of materials that use this component?
While I am asking about that, what about changing components where the units of measures are different? For example, let's say one SKU is a unit of measure of LBS and the new SKU is measured in 50# bags. The quantity per bill needs to be 1/50 of what it is currently.
Is exporting out the BM_Header and BM_Detail files into Access and then making the change in Access and then reinitializing these files and importing back in from Access a good way to do that?
Curious to know what others are doing in this regard.
Thanks,
