Premium Only Content

2020: Automagically Associate Zoho Project Invoice with Deal through Zoho Books workflow
Do you use Zoho Projects to manage your project budgets and performance? If so, you likely invoice through your project in Zoho Projects. Have you noticed that even though the project is associated with the deal, it doesn't attach the invoice to the deal in the Zoho Finance related list in CRM?
Maybe you haven't.
This video shows you how to use a Zoho Books workflow and custom function to re-associate the Project invoice to the associated deal.
The included code:
//This is a sample function. Uncomment to execute or make changes to this function.
invoiceID = invoice.get("invoice_id"); i
nvoicedate = invoice.get("date").toDate();
organizationID = organization.get("organization_id"); t
heLineItems = invoice.get("line_items");
for each li in theLineItems
{
theProjectID = li.get("project_id");
}
info theProjectID; theProject = zoho.books.getRecordsByID("Projects",organizationID,theProjectID);
info theProject;
theProjectName = theProject.getJSON("project").getJSON("project_name");
info theProjectName;
theDealRecord = zoho.crm.searchRecords("Deals","Deal_Name:equals:" + theProjectName);
theCRMProjectID = theDealRecord.getJSON("id");
mp = Map();
mp.put("zcrm_potential_id",theCRMProjectID);
resp = zoho.books.updateRecord("Invoices",organizationID,invoiceID,mp);
Link to start your free trial of Zoho ONE: https://www.edkinsgroup.com/zoho-free-trial.html
The YouTube Zocademy channel is meant to provide educational information regarding business best practices with an emphasis on the Zoho Platform. Our objective is to empower people like yourself to learn how to get more done with less.
We also have a website where you can purchase mini-courses to learn more in depth. We also offer memberships. The memberships include access to all mini-courses each month.
Feel free to visit at: www.zocademy.com
-
LIVE
JuicyJohns
47 minutes ago🟢#1 REBIRTH PLAYER 10.2+ KD🟢$500 GIVEAWAY SATURDAY!
141 watching -
LIVE
LFA TV
12 hours agoLFA TV ALL DAY STREAM - FRIDAY 8/1/25
8,667 watching -
LIVE
The Bubba Army
23 hours agoHulk Hogan had Leukemia? - Bubba the Love Sponge® Show | 8/01/25
2,344 watching -
18:36
DeVory Darkins
8 hours ago $3.55 earnedTrump scores MAJOR WIN with Americas youth as Biden drops HORRIBLE speech
8.44K23 -
14:13
Clickbait Wasteland
14 hours ago $4.28 earnedAsking New Yorkers Who they Support for Mayor: Harlem
29.9K27 -
19:55
The Rad Factory
16 hours ago $1.33 earnedCan I Fix My Fire Damaged F1 Car?
12.8K2 -
1:26:22
Dialogue works
2 days ago $0.36 earnedScott Ritter: Russia Just DEFIED the U.S.: We'll End the War on OUR Terms!
3.35K10 -
2:00:40
BEK TV
1 day agoTrent Loos in the Morning - 8/01/2025
13.5K -
13:08
Dad Saves America
14 hours ago $1.53 earnedTeachers Unions Play Politics While Students Lag Behind - Poisoning of the American Mind: Pt 4
18K13 -
20:05
Preston Stewart
14 hours ago $2.27 earnedCrimea Raid to Chasiv Yar Fight
20K9