One-to-Many Production Process & Delivery Scheduling Based on Sales Invoices

We are currently facing two issues with ERPNext and would appreciate any solutions you might suggest. Additionally, if anyone is interested in working on future modifications, we would love to explore a potential collaboration.

  1. One-to-Many Production Process

In ERPNext, the current production system handles scrap items but doesn’t support a scenario where a single raw material results in multiple finished goods, each with its own cost valuation. This type of one-to-many production is common in many industries, such as food processing or chemical manufacturing, but the current ERPNext system does not natively handle this.

Suggested Solution:

You may need to customize the production module to allow for a Bill of Materials (BOM) that supports splitting one raw material into multiple finished goods. This could involve creating a custom workflow or script that manages the costing and inventory movement for the one-to-many process.

  1. Delivery Scheduling Based on Sales Invoices

The challenge here is the inability to summarize quantities from selected sales invoices when planning deliveries. Since your deliveries occur on different days, and not all goods from a sales invoice are delivered at the same time, it’s difficult to manage and plan effectively.

Suggested Solution:

This issue may require customization of the Delivery Note or Delivery Planning module to allow for selecting multiple sales invoices and aggregating the quantities for a given delivery day.

You could also explore creating a custom report or screen that summarizes all open deliveries based on sales invoices and groups them by delivery date, allowing for better scheduling and planning.