Books Custom function - Not executing..
Use case :
Module involved = Invoice
When an Invoice is "Approved", the "current date" is more than "n" days and the "Amount" to be received is more than 0
I want a cliq message to be triggered in a channel and to be executed Daily(Scheduled) at 10:30 am.
That is only if it meets the condition.
I have a custom function written. But daily it is giving an error (failure) when it gets executed.
I am attaching the script. Can anyone help me? I have contacted the ZOHO team n number of times and so far the team have not come out with any solution.
________________________
Writer
Get Started. Write Away!
Module involved = Invoice
When an Invoice is "Approved", the "current date" is more than "n" days and the "Amount" to be received is more than 0
I want a cliq message to be triggered in a channel and to be executed Daily(Scheduled) at 10:30 am.
That is only if it meets the condition.
I have a custom function written. But daily it is giving an error (failure) when it gets executed.
I am attaching the script. Can anyone help me? I have contacted the ZOHO team n number of times and so far the team have not come out with any solution.
________________________
organizationID = organization.get("organization_id");
invoiceID = invoice.get("invoice_id");
invoicenumber = invoice.get("invoice_number");
StatusF = invoice.get("status_formatted");
Status = invoice.get("status");
SalesPersonaname = invoice.get("salesperson_name");
CustName = invoice.get("customer_name");
invoicededate = invoice.get("date");
invoiceBalance = invoice.get("balance");
Currencycode = invoice.get("currency_code");
invodateplus3days = invoicededate.addDay(3);
// can add any nuymber of days within bracket (3)
tday = zoho.currentdate;
Daydiff = invoicededate.daysBetween(tday);
info Daydiff;
info invoicededate;
info invodateplus3days;
info tday;
info invoicenumber;
info StatusF;
info Currencycode;
info invoiceBalance;
if(StatusF.containsIgnoreCase("Approved") && invoiceBalance >= 0 && Daydiff > 3)
{
Message = "Hi, Dear " + " " + " Prabhu (accountant), Balance of " + " " + Currencycode + invoiceBalance + "." + " Looks like though Approved /Sent/Invoiced, payment either not received or details not marked It is " + " " + Daydiff + " " + "days " + " " + invoicenumber + " " + StatusF + " " + " M/s " + CustName + ". " + "" + " Can obtain details if any, from the Salesperson " + " " + SalesPersonaname + " " + "Thanks.";
response = zoho.cliq.postToChannel("arbhuaccounts",Message,"invoicemsgcliq");// msg to be sent to two channels
response = zoho.cliq.postToChannel("aktest",Message,"invoicemsgcliq"); //msg to be sent to two channels
}
else if(StatusF.containsIgnoreCase("Over") && Daydiff > 3)
{
Message1 = "Hi " + " " + SalesPersonaname + " " + invoicenumber + " " + CustName + " " + "overdue by " + "" + Daydiff + " " + "Days. Please send reminder or chase for the payment ";
response = zoho.cliq.postToChannel("arbhuaccounts",Message1,"invoicemsgcliq");
}
_____________________________________________
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Arvind Kumar
Sticky Posts
[Webinar] Understanding the New Invoice Management Systems
Join industry expert CA Pritam Mahure as he discusses the importance of the new Invoice Management System (IMS) and its impact on taxpayers. Topics Covered: - Concept of IMS and pre-requisites - Applicability and Restrictions on Invoices/Records for IMSLatest Updates of the 53rd GST Council Meeting & Its Business Implications
Join industry expert CA Venugopal Gella as he discusses the importance of 53rd GST Council Meeting, the latest notifications and changes introduced by the Finance Act 2024. Register Now: https://zoho.to/GST_WebinarBest practices for financial year-end closing with Zoho Books | Free Webinar
Ready to close your year-end finances like a pro? Join our free webinar and learn how Zoho Books helps you maintain clean accounts, carry forward balances, and get geared up for the new financial year. Register now - https://zoho.to/9f1Zoho Books will discontinue support for older browser versions soon
Hello users, Starting from May 15, 2024, Zoho Books will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than 100Master the art of budgeting with Zoho Books | Free Webinar | 4th & 5th March 2024
We're thrilled to launch the Zoho Books monthly webinar series! Don't wait to conquer your finances in 2024! Budgeting can be easy with Zoho Books. Join our FREE webinar and learn how to set and track goals, master budgeting, and unlock insights to make
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー