getmrp = MRP[Work_Order_Subform_ID == input.ID]; getmrpsub = MRP_Subform_CWPL[MRP_Exis_ID == getmrp.ID]; fet_wosub = Work_Order_Subform[ID == input.ID]; fet_wo = Work_Order[ID == fet_wosub.Work_Order_Exis_ID]; fet_bom = Create_BOM[Part_No == fet_wosub.Part_No]; fetsubbom = BoM_FG_Subform[BOM_FG_Exis_ID == fet_bom.ID]; //info fetsubbom.count(); if(fetsubbom.count() == 0) { openUrl("#Form:Alert_Messages?Status=MRPbom_Alert&Value=BoM not created! Create BoM for this Material. &zc_LoadIn=dialog","same window"); } else if(getmrp.MRP_Status == null && fet_wosub.WO_Qty != 0) { openUrl("#Form:MRP?Work_Order_Subform_ID=" + input.ID,"same window"); } else if(getmrp.MRP_Status == "MRP Reverted") { openUrl("#Form:MRP?Work_Order_Subform_ID=" + input.ID,"same window"); } else if(fet_wosub.Work_Order_Status == "MRP Rejected") { openUrl("#Form:MRP?Work_Order_Subform_ID=" + input.ID,"same window"); } else if(getmrp.MRP_Status == "Draft") { openUrl("#Form:MRP?recLinkID=" + getmrp.ID + "&viewLinkName=MRP_Report&Form_Mode=DraftMRP","same window"); } else if(fet_wosub.WO_Qty <= 0) { openUrl("#Form:Alert_Messages?Status=MRP_Alert&Value=Stock available for this WorkOrder. <br>Not Required MRP! &zc_LoadIn=dialog","same window"); } else { openUrl("#Form:MRP?Work_Order_Subform_ID=" + input.ID,"same window"); }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter