New Process mapping (Leather Processing Units)

Hello Team,

I would like to propose/seek guidance on a new process requirement in ERPNext:

  • Starting from a Sales Order, we need to generate a Chemical Recipe specific to that order.

  • The recipe should:

    • Create a new item for the recipe with batch tracking.

    • Handle stock reduction of raw materials used.

    • Maintain a link between the Sales Order and the Recipe for traceability.

  • Similar to our existing Adhesive Recipe preparation, this new recipe should follow the same workflow.

  • After preparation, we need an Internal FG Item that combines the outputs of the first two recipes plus crust.

  • This FG item then moves to another location/warehouse.

  • Finally, a Work Order should be generated for the Sales Order item, with proper linkage across all these steps.

In short, the flow is:
Sales Order → Recipe Creation (with batch & stock reduction) → Adhesive Recipe → Internal FG Item (combined) → Transfer → Work Order for SO Item (linked).

Could you please advise if this can be achieved through existing ERPNext features (like BOM, Work Order, Manufacturing Flow), or if customization is required? Any suggestions or best practices would be highly appreciated.

Thanks in advance!