I have 3 large configurators that were created calling out Pull As Assembly materials, and production has requested switching these to normal material, not Sub Assemblies.
The issue is we have set qty expressions on these:
The lookup tables? I, too, have come to this conclusion. I ended up exporting them to Excel and making changes as needed and copy/paste, etc. Then paste update.
This may have back in the Vantage days, but I thought I tried putting the part on twice, once as an assembly and once as material and used a Keep When (at the time) to choose one or the other. Again, this was long ago and the configurator has been updated a couple of times since then…
Okay, I found a semi-automatic solution for this and thought I’d share it in case anything else runs into the same issue. First, I should say I opened a support ticket with Epicor, who confirmed there was no built-in way to do this in the system.
I created an Updatable dashboard to pull the configurator and BOM rules.
Exported the results to excel and made the code changes (replace JobAsmbl with JobMtl)
Paste updated into the Dashboard
Updated the engineered BOM to remove the PullAsAsm on those MTLs. I exported the MTL list to excel, made the changes, and paste updated them back in.
A note:
If you change the BOM first, all of the code you have on the MtlSeq will be removed. However, if you do it in the order above, you might get a pop-up warning in the engineering workbench saying this will happen, but it won’t because the code is now referencing the correct target.