Created -> OnLoad
Tue Jan 07 2025 13:55:16 GMT+0000 (Coordinated Universal Time)
Saved by @Pooja
disable Product_Details.Ordered_Qty; disable Product_Details.UoM; //hide Product_Details.Individual; hide CDNF_ID; hide Currency_Code; hide Actual_Date_Time; disable Plan_Date_Time; hide Export_Information_ID; //hide Disptach_Status; hide Sale_Order_Subform_RECID; disable Incoterms; hide Product_Details.Block_Qty; disable Incoterms_Location; hide DN_No; disable Product_Details.Packing_Details1; hide Product_Details.Export_Information_Exis_ID; hide Product_Details.Reason; hide Sales_Order_ID; hide Inventory_ID; hide Create_Dispatch_Note_Plan_ID; hide Check_Inventory_ID; hide Unblock_Inventory_ID; hide Product_Details.Actual_Qty_so_far; hide Product_Details.Plan_Qty_so_far; hide Product_Details.Ac_so_far; hide Product_Details.Stock_Qty; disable Product_Details.Customer_Product_Code; disable Product_Details.Product_Weight; disable Sales_Type; disable Product_Details.Remarks; //hide Product_Details.Actual_Qty; hide Product_Details.Create_Dispatch_Note_Plan_RECID; hide Disptach_Status; if(input.Dispatch_Type == "Plan") { input.Plan_Date_Time = zoho.currenttime; hide Transportation_Details; hide Returnable_Packing_Material; hide Product_Details.Ordered_Qty; hide Product_Details.Actual_Qty; hide Product_Details.Actual_Weight; } if(input.Dispatch_Type == "Actual") { hide Product_Details.Ordered_Qty; hide Out_Time; hide In_Time; disable Product_Details.Actual_Qty; } if(input.Sale_Order_Subform_RECID != null) { getSosub = Sale_Order_Subform[ID == input.Sale_Order_Subform_RECID]; input.Sales_Order_ID = getSosub.Sales_Order_Exis_ID; input.Sales_Order_No = getSosub.Sales_Order_Exis_ID; disable Sales_Order_No; so = Sales_Order[ID == getSosub.Sales_Order_Exis_ID]; input.Expected_Shipping_Date = so.Expected_Shipment_Date; //var = Check_Inventory[ID == input.ID]; fet_so = Sales_Order[ID == input.Sales_Order_ID]; getsosub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID]; fet_chk = Check_Inventory[Sale_Order_Subform_ID == input.Sale_Order_Subform_RECID]; if(fet_chk.count() > 0) { input.Check_Inventory_ID = fet_chk.ID; } fet_pro = Proforma_Invoice[Customer_Name == fet_so.Customer_Name && Sales_Order_No == getsosub.Sales_Order_Exis_ID]; //fetch_inve = Inventory[Part_No == getsosub.Part_No]; input.Customer_Name = fet_so.Customer_Name; input.Customer_Address = fet_so.Shipping_Address; input.Incoterms = fet_so.Incoterms1; input.Incoterms_Location = fet_so.Incoterms_Location; input.Currency_Code = fet_so.Currency_Code; input.Sales_Type = fet_so.Sales_Type; input.Packing_Forwarding = fet_so.Packing_Forwarding; if(input.Sales_Type == "Direct Order" || input.Sales_Type == "Tooling" || input.Sales_Type == "Research & Development Charges") { input.Expected_Shipping_Date = so.Expected_Shipment_Date; hide Product_Details; hide Total_Qty; hide Total_Weight; sublistdo = List(); sosub1 = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && Balance_Qty > 0]; for each recsodo in sosub1 { planvardo = ifNull(recsodo.Balance_Qty,0) - ifNull(recsodo.Planned_Qty_So_far,0); if(planvardo > 0) { sublistdo.add(recsodo.Part_No); } } input.Product_List:ui.add(sublistdo); if(fet_pro.Proforma_Invoice_Status == "Over Due") { alert "Proforma Invoice is in OverDue for this Customer"; } else if(fet_pro.Proforma_Invoice_Status == "Due") { alert "Proforma Invoice is in Due for this Customer"; } else if(fet_pro.Proforma_Invoice_Status == "Partially Paid") { alert "Proforma Invoice is in Partially Paid for this Customer"; } //input.Invoice_Address = fet_so.Billing_Address.state_province; // sno = 0; // for each a1 in fet_so.Item_Details // { // fetch_inven = Inventory[Part_No == a1.Part_No].sum(Available_Qty); // row1 = Create_Dispatch_Note_Format.Product_Details(); // row1.Product_Description=a1.Part_Description; // row1.Product_Code=a1.Part_No; // row1.Customer_Product_Code=a1.Customer_Part_Code; // row1.Remarks=a1.Remarks; // row1.UoM=a1.UoM; // row1.Packing_Details1=a1.Packing_Std; // //row1.Planned_Qty=a1.Qty; // row1.Ordered_Qty=a1.Qty; // // row1.Stock_Qty=fetch_inven; // row1.Plan_Qty_so_far=a1.Planned_Qty_So_far; // planvar = ifNull(a1.Balance_Qty,0) - ifNull(a1.Planned_Qty_So_far,0); // if(a1.Balance_Qty > 0 && planvar > 0) // { // row1.S_NO=sno + 1; // sno = sno + 1; // input.Product_Details.insert(row1); // } // disable Sale_Order_Subform_RECID; // disable Product_Details.S_NO; // disable Product_Details.Product_Code; // disable Product_Details.Product_Description; // } // if(input.Dispatch_Type == "Plan") // { // Tot = 0; // wt = 0; // for each rec in input.Product_Details // { // rec.Disp_Plan_Date_Time=zoho.currenttime; // fet_item = Materials[ID = rec.Product_Code]; // salesub = Sale_Order_Subform[Sales_Order_Exis_ID == input.Sales_Order_ID && Part_No == rec.Product_Code]; // rec.Planned_Qty=ifNull(salesub.Balance_Qty,0) - ifNull(salesub.Planned_Qty_So_far,0); // // rec.Stock_Qty=fetch_inven; // Tot = Tot + ifNull(rec.Planned_Qty,0); // rec.Product_Weight=ifNull(fet_item.Final_Weight,0.0) * ifNull(rec.Planned_Qty,0.0); // wt = wt + rec.Product_Weight; // disable Total_Qty; // disable Total_Weight; // } // input.Total_Qty = Tot; // input.Total_Weight = wt; // } } else if(input.Sales_Type == "Contract") { hide Product_Details; hide Total_Qty; hide Total_Weight; sublist = List(); sosub = Sale_Order_Subform[Sales_Order_Exis_ID == fet_so.ID && Balance_Qty > 0]; for each recso in sosub { planvar1 = ifNull(recso.Balance_Qty,0) - ifNull(recso.Planned_Qty_So_far,0); if(planvar1 > 0) { sublist.add(recso.Part_No); } } input.Product_List:ui.add(sublist); } }
Comments