Created -> OnLoad

PHOTO EMBED

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);
	}
}
content_copyCOPY