Deal_Details = zoho.crm.getRecordById("Deals",deal_id);
Deal_Name = Deal_Details.get("Deal_Name");
Deal_Number = Deal_Details.get("Deal_Number");
//===================================================================================//
searchParam = {"reference_number":Deal_Number};
related_purchase_orders = zoho.books.getRecords("purchaseorders","689149759",searchParam);
info related_purchase_orders;
count = 0;
Total_of_all = 0.0;
if(related_purchase_orders.get("purchaseorders").size() > 0)
{
responseXML = "<record>";
for each purchase_order in related_purchase_orders.get("purchaseorders")
{
purchaseorder_number = purchase_order.get("purchaseorder_number");
created_date = purchase_order.get("date");
status = purchase_order.get("status");
vendor_name = purchase_order.get("vendor_name");
total = purchase_order.get("total");
Total_of_all = Total_of_all + total;
po_id = purchase_order.get("purchaseorder_id");
html = "<a href='www.google.com'>click here</a>";
//===================================================================================//
responseXML = responseXML + "<row no='" + count + "'>";
responseXML = responseXML + "<FL val='PO Number'>" + purchaseorder_number + "</FL>";
responseXML = responseXML + "<FL val='Status'>" + status.proper() + "</FL>";
responseXML = responseXML + "<FL val='Vendor'>" + vendor_name.replaceAll("[\"#%&+;<=>\[\]^`(){}|~]","") + "</FL>";
responseXML = responseXML + "<FL val='Total'>$ " + total + "</FL>";
responseXML = responseXML + "<FL val='Created Date'>" + created_date + "</FL>";
// responseXML = responseXML + "<FL val='PO Link'>https://books.zoho.com/app#/purchaseorders/" + po_id + "</FL>";
responseXML = responseXML + "<FL val='PO Link' link='true' url='https://books.zoho.com/app#/purchaseorders/" + po_id + "'>Open</FL>";
responseXML = responseXML + "</row>";
count = count + 1;
}
responseXML = responseXML + "</record>";
}
else
{
responseXML = "";
responseXML = responseXML + "<record><error>=><message>There are no POs found against this Deal!</message></error></record>";
}
return responseXML;