// getEmail = Partner_Details[Partner_Entity_Name == input.CP_Name];
getEmailID = Partner_Onboarding_and_KYC[Partner_Entity_Name == input.CP_Name];
// info getEmailID;
if(getEmailID.count() > 0)
{
	insdata = insert into CP_Internal_Invoice_Backend
	[
		Added_User=zoho.loginuser
		Accumulated_Commission_Amount=input.Accumulated_Commission_Amount
		Internal_Invoice_Created_Date=input.Internal_Invoice_Created_Date
		Books_Journal_ID=input.Books_Journal_ID
		Internal_Invoice_ID=input.Internal_Invoice_ID
		Application_No=input.Application_No
		Enrollment_Date=input.Enrollment_Date
		Tranasaction_ID=input.Tranasaction_ID
		CP_Name=input.CP_Name
		Contracting_Organisation=input.Contracting_Organisation
		Payout=input.Payout
		Total_Amount=input.Total_Amount
		Program_fee=input.Program_fee
		Registration_fee=input.Registration_fee
		Exam_fee=input.Exam_fee
		Loan_subvention_charges=input.Loan_subvention_charges
		Eligible_fee=input.Eligible_fee
		Balance_Amount=input.Balance_Amount
		UTR_number=input.UTR_number
		Mail_CP=input.Mail_CP
		Uploaded_Invoice=input.Uploaded_Invoice
		Tranasaction=input.Tranasaction
		Send_mail_Status=input.Send_mail_Status
		Status=input.Status
		Button_Status=input.Button_Status
		Zoho_Book_Total_Amount=input.Zoho_Book_Total_Amount
		Zoho_Books_Balance_Amount=input.Zoho_Books_Balance_Amount
		Decision_box=input.Decision_box
		Decision_box1=input.Decision_box1
		Internal_Invoice=input.ID
		Balance_Amount_Backend=input.Balance_Amount_Backend
		Bill_Creation_Status="No"
	];
	// 	External_Invoice_Amount=input.External_Invoice_Amount
	// 	External_Invoice_number=input.External_Invoice_number
	// 		External_Invoice=input.External_Invoice
	// 		External_Invoice_Date=input.External_Invoice_Date
	// 	info "inside if";
	// 		Contracting_organisation1=input.Contracting_organisation1
	Content = "<a href='https://creatorapp.zohopublic.in/centralisedprocurement_usdcglobal/usdc1/CP_Internal_Invoice_Backend/record-edit/CP_Internal_Invoice_Backend_Report/" + insdata +  "/A3hQ1AfsuCWn3DPEmaDrQZbdK4B5GsNYUfGemsA3k24Ue1d8NuMxnYrJR21ADe5E84m5N6PHqOkruO6vBR43Sxsf7bUvTqrPyUVQ?&Decision_Box2="+false+"'>Click link to upload the invoice.</a>";
	sendmail
	[
		from :zoho.adminuserid
		to :getEmailID.Partner_Representative_Email
		cc:"indhu@techvaria.com","pooja.s@techvaria.com","vimal@techvaria.com"
		subject :"Action required - Submit invoice for commission finalized to " + getEmailID.Contracting_organisation1.Contracting_organisation
		message :"Commission is finalized " + Content + "<br><br>" + "Payments will be subject to verification of the invoice submitted and completion of necessary approvals."
	]
}
input.Button_Status = "Send to Cp";
input.Mail_CP = true;