Revert-OnLoad
Tue Jan 07 2025 15:34:31 GMT+0000 (Coordinated Universal Time)
Saved by @Pooja
if(input.MRP_RECID != null) { get_mrp = MRP[ID == input.MRP_RECID]; //info get_mrp + "mrp"; fet_cwpl = MRP_Subform_CWPL[MRP_Biderection_ID == get_mrp.ID]; fet_gp = MRP_Subform_GP[MRP_Biderection_ID == get_mrp.ID]; input.Revert_By = Employee_Details[Employee_Email == zoho.loginuserid].ID; input.Revert_Date = zoho.currentdate; input.Work_Order_No = get_mrp.Work_Order_No1; input.Sales_Order_No = get_mrp.Sales_Order_No; input.Part_No = get_mrp.Part_No; input.Part_Name = get_mrp.Part_Name; input.MRP_Qty = get_mrp.MRP_Qty; input.Factory_Warehouse = get_mrp.Factory_Warehouse; input.Created_By = get_mrp.Created_By.ID; input.Customer_Name = get_mrp.Customer_Name; input.Specification = get_mrp.Specification; hide WO_Qty; } i = 0; //info "outside for"; //info fet_cwpl + "subform"; for each mrpcwpl in fet_cwpl { //info "1st for"; i = i + 1; getrow = Revert_Process1.Revert_MRP_Subform_CWPL(); getrow.S_No=i; getrow.Part_No=mrpcwpl.Part_No; getrow.Part_Name=mrpcwpl.Part_Name; getrow.UoM=mrpcwpl.UoM; getrow.BoM_Qty=mrpcwpl.BoM_Qty_Old; getrow.Stock_Qty=mrpcwpl.Stock_Qty; getrow.Req_Qty=mrpcwpl.Req_Qty; getrow.Plan_Qty=mrpcwpl.Actual_Qty; getrow.Blocked_Qty=mrpcwpl.Blocked_Qty; getrow.Block_Qty=mrpcwpl.Block_Qty; getrow.bom_stk_qty=mrpcwpl.bom_stk_qty; cwplCol = Collection(); cwplCol.insert(getrow); input.Revert_MRP_Subform_CWPL.insert(cwplCol); } j = 0; for each gp in fet_gp { j = j + 1; genral = Revert_Process1.Revert_MRP_Subform_GP(); genral.S_No=j; genral.Part_No=gp.Part_No; genral.Part_Name=gp.Part_Name; genral.UoM=gp.UoM; genral.Purchase_Qty=gp.Purchase_Qty; genral.Stock_Qty=gp.Stock_Qty; genral.Indent_Qty=gp.Indent_Qty; genral.BoM_Qty=gp.BoM_Qty; genral.Req_Qty=gp.Plan_Qty; genral.Blocked_Qty=gp.Blocked_Qty; genral.Block_Qty=gp.Block_Qty; gencol = Collection(); gencol.insert(genral); input.Revert_MRP_Subform_GP.insert(gencol); } if(input.Work_Order_Subform_ID != null) { fet_wosub = Work_Order_Subform[ID == input.Work_Order_Subform_ID]; get_wo = Work_Order[ID == fet_wosub.Work_Order_Exis_ID]; input.Create_Work_Order_ID = get_wo.ID; input.WO_Qty = fet_wosub.WO_Qty; input.Revert_By = Employee_Details[Employee_Email == zoho.loginuserid].ID; input.Revert_Date = zoho.currentdate; input.Work_Order_No = get_wo.ID; input.Sales_Order_No = get_wo.Sales_Order_Nos; input.Part_No = fet_wosub.Part_No; input.Part_Name = fet_wosub.Part_Description; input.Customer_Name = get_wo.Customer_Name; input.Specification = fet_wosub.Specification; hide MRP_Qty; hide Factory_Warehouse; hide Specification; hide Created_By; disable WO_Qty; } wosno = 0; for each wosf in fet_wosub { wosno = wosno + 1; inswo = Revert_Process1.Revert_WO_Subform(); inswo.S_No=wosno; inswo.Part_No=wosf.Part_No; inswo.Part_Description=wosf.Part_Description; inswo.UOM=wosf.UOM; inswo.SO_Quantity=wosf.SO_Quantity; inswo.Stock_Qty=wosf.Stock_Qty; inswo.WO_Pipeline=wosf.WO_Pipeline; inswo.Required_Qty=wosf.Required_Qty; inswo.WO_Qty=wosf.WO_Qty; inswo.Block_Qty=wosf.Block_Qty; inswo.Balance_Qty=wosf.Balance_Qty; inswo.WO_Qty_with_buffer=wosf.WO_Qty_with_buffer; inswo.Specification=wosf.Specification; wocol = Collection(); wocol.insert(inswo); input.Revert_WO_Subform.insert(wocol); }
Comments