Project Manufacturing

The purpose of this video series is to help you apply iDempiere project management to production/manufacturing.

Project Manufacturing Concepts

Project Manufacturing - Simple Example

Notes:

This demonstration includes code that I wrote and committed to iDempiere - Tickets: 2410, 2412. 2416
This video assumes (1) iDempiere accepted and integrated these tickets, or (2) you have them installed in your system.

Project Manufacturing - Project Line BOM Explosion

Notes:

This demonstration includes code that is only available to current and past ERP Academy users via a private bitbucket repository.
To gain access, send an email to the training mailing list with the repository URL: https://bitbucket.org/cboecking/generate-bom-in-project

Project Manufacturing - Replenishment from Finished Good Production

Project Manufacturing - Replenishment from Project Line

Code - the below code should be placed in the ReplenishReportProduction.java after the section labeled "// add production lines" around line 300.

		// add project lines
		sql = new StringBuilder("UPDATE T_Replenish t SET ");
			sql.append("QtyReserved = QtyReserved + COALESCE((SELECT COALESCE(SUM(pl.PlannedQty),0) "
					+ "FROM C_ProjectLine pl "
					+ "	JOIN C_Project p on (pl.C_Project_ID = p.C_Project_ID) "
					+ "WHERE t.M_Product_ID=pl.M_Product_ID "
					+ "	 AND pl.M_Production_ID is null "
					+ "	 AND pl.C_OrderPO_ID is null "
					+ "  AND t.M_Warehouse_ID=p.M_Warehouse_ID ),0) ");
		sql.append(" WHERE AD_PInstance_ID=").append(getAD_PInstance_ID());
		no = DB.executeUpdate(sql.toString(), get_TrxName());
		if (no != 0)
			if (log.isLoggable(Level.FINE)) log.fine("Update # from project: " + no);