ItemDetails_DelRow_Validation
Tue Jan 07 2025 15:31:27 GMT+0000 (Coordinated Universal Time)
Saved by @Pooja
aa = 0; gt = 0; it = 0; for each vv in input.Item_Details { if(vv == row) { continue; } else { aa = aa + 1; vv.S_No=aa; gt = gt + ifnull(vv.Sub_Total,0); it = it + ifnull(vv.Item_Total,0); } } input.Gross_Total = gt; input.Overall_Total = it; for each recval in input.Delivery_Schedule { if(recval.Part_No == row.Part_Description) { recval.Part_No=null; recval.Quantity=null; recval.Delivery_Date=null; } } itemlist = List(); qtyList = List(); dateList = List(); remarksList = List(); fullQtyList = List(); for each rec in input.Delivery_Schedule { if(rec.Part_No != null) { itemlist.add(rec.Part_No); qtyList.add(rec.Quantity); dateList.add(rec.Delivery_Date); remarksList.add(rec.Remarks); fullQtyList.add(rec.Full_Quantity); } } input.Delivery_Schedule.clear(); i = 0; s_no = 0; for each items in itemlist { s_no = s_no + 1; row1 = Purchase_Order.Delivery_Schedule(); row1.Part_No=items; row1.S_No=s_no; row1.Quantity=qtyList.get(i); row1.Delivery_Date=dateList.get(i); row1.Remarks=remarksList.get(i); row1.Full_Quantity=fullQtyList.get(i); input.Delivery_Schedule.insert(row1); i = i + 1; } /// check_ven_map = 0; check_ven_lis = List(); for each sub_val in input.Item_Details { if(sub_val.Part_No != row.Part_No) { check_vendor = Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == sub_val.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"]; if(check_vendor.count() == 0) { check_ven_lis.add(sub_val.Part_No.Part_No); check_ven_map = 1; } } } if(check_ven_map == 1) { show asso_vendors; create_tab = "<table border=1 Style ='color:#ff8b3b'><tr><th>S.No</th><th>Part No</th><th>Associated Vendor(s)</th></tr>"; sno = 1; for each tab in check_ven_lis { ven_lis = List(); for each ven in Vendor_Contract_Subform[Part_Description.Part_No == tab && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"] { if(ven.Vendor_Name.Status == "Active") { ven_lis.add(ven.Vendor_Name.Vendor_Name); } } create_tab = create_tab + "<tr><td>" + sno + "</td><td>" + tab + "</td><td>" + if(ven_lis.size() == 0,"<b>Not Associated</b>",ven_lis) + "</td></tr>"; sno = sno + 1; } create_tab = create_tab + "</table>"; str = "Selected Vendor <b>" + input.Vendor_Name.Vendor_Name + "</b> is not mapped against the following Item(s) : <br><br> " + create_tab; input.asso_vendors = str; Do_you_want_to_proceed_anyway = ""; Flag_for_Not_Associated_Vendors = true; } else { hide asso_vendors; Flag_for_Not_Associated_Vendors = false; }
Comments