Best way to Eliminate a Circular Reference for Mixed Lots

Here are a few possible solutions,

1. Manual Lot Addition: As you have indicated, adding the mixed lots to the Production Order by hand is legitimate strategy that might continue to be the simplest choice. Usually, you manually add the lots as components to a production order for the final product.
2. Custom Automation or Workflow: Take into account putting in place an automation, or custom workflw that manages the addition of lots to production orders in accordance with specific standards. For instance, after the relevant lots are combined, a bespoke proces might automatically combine to a new production order. Although this method would need adjustments, it might automate the process and cut down on manual labor
3. Super Batch/Mixed Lots: During production, several lots of the same product are combined into a singl lot, creating a customized kind of super batching. By doing this, the system would be able to handle the process as though it were a brand-new final product without breaking the circular reference constraint.
4. Lot Splitting: Using the lot splitting feature is an additional choice that can enable the blending of several lot into one new lot. This might be modified to handle merging numerous lots into a new lot number, even though it is typically used to separate vast quantities of goods.
5. Production Orders in Multiple Stage: It is possible to establish a production order in which the lots are mixd in the first stage and a finished product is made from the mixed batch in the second stage. The procedure could be streamlined, but efficient handling of the transition between stages may require some manul intervention.

The particular requirements of the customer would need to be taken into consideration while evaluating each of these options, and some might call for custom development. In the long run, automating lot mixing could save time and lower erors, depending on the products complexity and process frequency.