Variable materials on a BOM
The issue I'm current facing involves the bill of materials screen (AM208000). Depending on the customer location, specific components will be included in an assembly. How can I manage one BOM with variable materials? Today, I'm overriding the production order BOM reference which is error prone and tedious. It also requires managing multiple BOMs for the same completed assembly.
If I'm understanding correctly, it sounds like you want to have multiple BOMs in place for different customers. Then, when you create a Production Order from a Sales Order, you want Acumatica to look at the Customer (maybe even the Customer Location) on the Sales Order and automatically pick the correct BOM. Is that correct?
If this is the case, as far as I know you'd need to do a customization for this. You'd also have to associate the Customer to the BOM somehow, maybe put the Customer ID in the BOM ID or add a Customer ID attribute to the BOM?
Tim is correct, to have Acumatica select the location specific BOM, you would need a customization. Depending on the communication and process flow, you could create a revision of the BOM for each customer location and when the production order is created, have the user select the appropriate revision.
But again, as a process this requires communication and human intervention which often falls down.
This may be a little out there and more than you would want to deal with, but what is you used the MFG product configurator? This may be a more suitable solution than a customization since it would operate within the Acumatica MFG framework.
My thought is that you could designate the existing item as a configurable item. You could then create a single configuration with a single feature, the customer/location ID. You within each of those features you would assign the dynamic components. During SO entry, the line item would be configurable and the user would select the appropriate customer/location ID and the BOM associated with the item would be dynamically changed based on the configured items inclusions for that selected feature. You may also be able to leverage the configuration key to further simplify data entry.
@c4 do you have any familiarity with the product configurator or are you already using this with the advanced MFG modules within Acumatica?
That's an interesting idea Kevin to essentially create a "choose your own BOM" workflow.