Sage 100

Client has about 100 items that are duplicates. Exact same components in each, but client set up two so that they would be easier to price. Unfortunately, have two made everything else harder. They have agreed to only have one now and want to eliminate the duplicate. My first thought is to use the IM merge utility but this produces an error message ""No Action Both items would be bills of material"" If I delete the BOM of the item I am removing, run the IM Utility, the merge works. Is there a faster way of removing BOM's aside from the old fashion way of one at a time via maintenance? I am not seeing it. TIA.

You could use a script.

I've not tested this but is seems like it would work. 1.Export all records from BM_Header / Detail ( also include BillOptionHeader/Detail/Category If they are using Option bills) 2.Reinitialize BM_Header/Detail and Option tables 3.Merge the Inventory items using the utility 4.Import your records back into BM_Header/Detail ( BoMs for the missing items should fail)

@JeffSchwenk FWIW I have two clients that I regularly use @DavidOverholt method (sans step 3) to update their BOMs. Sounds scary, but actually is quite easy.

Well, it IS Halloween!!!! Will try this process. Have done it for other tables.

isn't anything simple?? Made a copy of BMHeader/Detail, exported to Excel, reinitialized. Starting getting the attached errors. Changed all items in CI_item to Finished goods. Still getting the error? Have rebuilt the sort tables. Any clue where error is coming from. TIA

IM_salesKitHeader and IM_SalesKitDetail maybe? and in my experience simple seems pretty rare

Bingo!!!! Though I couldn't look at the kits via the menu because BM was active. Reinitialized and now merging.

I'm guessing they had kits setup and later activated BOM module. Sage must have moved the data from IM_SalesKit to the Bill header and detail and left the data behind in sales kit tables. That might be good to know for future reference.

My thoughts exactly. Thanks for the door opener!