fetch_inv = Inventory[Part_No == input.Part_No] sort by Available_Qty desc; fet_chk = FG_Block_Stock1[ID == input.FG_Block_Stock_ID]; if(input.Unblock_Qty == fet_chk.Block_Qty || input.Unblock_Qty == fet_chk.Balance_Blocked_Qty) { fet_chk.Quantity_Blocked_So_far=ifnull(fet_chk.Quantity_Blocked_So_far,0) + input.Unblock_Qty; fet_chk.Unblocked_Qty=fet_chk.Block_Qty; fet_chk.Balance_Blocked_Qty=0; fetch_inv.Block_Qty=ifnull(fetch_inv.Block_Qty,0) - input.Unblock_Qty; fetch_inv.Available_Qty=ifnull(fetch_inv.Available_Qty,0) + input.Unblock_Qty; fet_chk.Status="Fully UnBlocked"; input.Status = "Fully UnBlocked"; } else if(input.Unblock_Qty < fet_chk.Block_Qty && input.Unblock_Qty != fet_chk.Balance_Blocked_Qty) { fet_chk.Quantity_Blocked_So_far=ifnull(fet_chk.Quantity_Blocked_So_far,0) + input.Unblock_Qty; fet_chk.Unblocked_Qty=ifnull(fet_chk.Quantity_Blocked_So_far,0); if(fet_chk.Balance_Blocked_Qty == null) { fet_chk.Balance_Blocked_Qty=fet_chk.Block_Qty - input.Unblock_Qty; } else { fet_chk.Balance_Blocked_Qty=fet_chk.Balance_Blocked_Qty - input.Unblock_Qty; } fetch_inv.Block_Qty=ifnull(fetch_inv.Block_Qty,0) - input.Unblock_Qty; fetch_inv.Available_Qty=ifnull(fetch_inv.Available_Qty,0) + input.Unblock_Qty; fet_chk.Status="Partially UnBlocked"; input.Status = "Partially UnBlocked"; } openUrl("#Form:Alert_Messages?Status=" + "UNBlOCK" + "&Value=" + input.Unblock_Qty + "&zc_LoadIn=dialog","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