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