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