Getter error message Number of statement execution limit exceed Line:(216)
Hi, this script is giving me error message "Number of statement execution limit exceed Line:(216)". Please advise
Get Started. Write Away!
htmlpage Pay_Period_Details(PayPeriodID,AgentID,ShowPrint,start_range,end_range)
displayname = "Pay Period Details"
content
<%{
/* Get The current Pay Period Record */
Int_Pay_Period_ID = PayPeriodID.toLong();
Current_Pay_Period_Record = Pay_Period[ID == Int_Pay_Period_ID];
Previous_Pay_Period_ID = thisapp.Application.GetPreviousPayPeriodID(Current_Pay_Period_Record.ID);
/* Checking Agent ID is a valid Agent ID */
if(input.AgentID != null && input.AgentID != "" && FormA[ID == AgentID.toLong()].count() == 1)
{
//This input parameter is a valid Agent ID
Int_Agent_ID = AgentID.toLong();
}
%>
<style>
.centerAlign
{
text-align:center;
}
.rightAlign
{
text-align:right;
}
.rightAlignTd td
{
text-align:right;
}
.boldTd td
{
font-weight:bold;
}
.leftAlign
{
text-align:left;
}
.width33
{
width:33%;
}
.width12
{
width:12%;
}
.width8
{
width:8%;
}
.customBodyStyle
{
margin:10px 10px 10px 10px;
}
.floatRight
{
float:right;
margin-right:10px;
}
</style>
<style media="print">
.pageBreakBefore
{
page-break-before:always;
}
</style>
<div style="customBodyStyle">
<%
/* EACH AGENT CONTAINER */
Int_Start_Range = start_range.toLong();
Int_End_Range = end_range.toLong();
Total_Record_Count = FormA[ID != 0].count();
//Initilize Agent Counter
Agent_Index = 0;
for each Agent_Record in FormA sort by Last_Name range from Int_Start_Range to Int_End_Range
{
//When Agent ID has been provided, we render only for that agent or when input agent id is not provided
//we loop for all existing agents
if(Int_Agent_ID == null || Agent_Record.ID == Int_Agent_ID)
{
Agent_Daily_Record_Count = FormB[Agent == Agent_Record.ID && Date_field >= Current_Pay_Period_Record.Start_Date && Date_field <= Current_Pay_Period_Record.End_Date].count();
// Now we have to include those agents who are either active or have atleast one record in the pay period
if(Agent_Record.Status == "Active" || Agent_Daily_Record_Count > 0)
{
//Initilize
/* Previous_Pay_Period_Payout = 0.0; */
Running_Total = 0.0;
//Determine the previous payout for the agent
//Accounting for the fact that Agent counld not have existed in the previous pay period
if(Previous_Pay_Period_ID != -1 && Pay_Period_Agent[Pay_Period_ID == Previous_Pay_Period_ID && Agent_ID == Agent_Record.ID].count() == 1)
{
//if ((Previous_Pay_Period_ID != -1) && (Pay_Period_Agent[(Pay_Period_ID == Int_Pay_Period_ID && Agent_ID == Agent_Record.ID)].count() == 1))
Previous_Pay_Period_Agent_Record = Pay_Period_Agent[Pay_Period_ID == Previous_Pay_Period_ID && Agent_ID == Agent_Record.ID];
//Previous_Pay_Period_Agent_Record = Pay_Period_Agent [(Pay_Period_ID == Int_Pay_Period_ID && Agent_ID == Agent_Record.ID)];
/* Previous_Pay_Period_Payout = Previous_Pay_Period_Agent_Record.Payout; */
// Running_Total = (Previous_Pay_Period_Agent_Record.Pay_Period_Balance - Previous_Pay_Period_Agent_Record.Payout);
Running_Total = Previous_Pay_Period_Agent_Record.Pay_Period_Balance;
}
%>
<div
<%
if(Agent_Index > 0)
{
%>
class="pageBreakBefore"
<%
}
%>
>
<%
Agent_Index = Agent_Index + 1;
%>
<br/>
<table class="zc-viewtable zc-viewrow">
<%
if(input.ShowPrint == "False")
{
%>
<tr class="zc-grouprow">
<td colspan="3">
Pay Period <%=Current_Pay_Period_Record.Start_Date%> to <%=Current_Pay_Period_Record.End_Date%>
</td>
</tr>
<%
}
%>
<tr class="zc-grouprow">
<td class="width33"><%=Agent_Record.Last_Name%>, <%=Agent_Record.Name%> - <%=Agent_Record.Position%>
<%
if(input.ShowPrint != "False")
{
%>
<div class="floatRight"><a target="_blank" href="
https://creator.zoho.com/<%=zoho.adminuser%>/<%=zoho.appname%>/print/Pay_Period_Details/PayPeriodID=<%=PayPeriodID%>&AgentID=<%=Agent_Record.ID%>&ShowPrint=False&start_range=1&end_range=<%=Total_Record_Count%>">Print</a></div>
<%
}
%>
</td>
<td class="rightAlign width33"></td>
<%
/* Previous Payout: $ <%=Previous_Pay_Period_Payout%> */
%>
<td class="rightAlign width33">Previous Balance:$ <%=Running_Total%></td>
</tr>
</table>
<table class="zc-viewtable">
<tr class="zc-viewrowheader">
<th class="width12 centerAlign">Date</th>
<th class="width8 centerAlign">Sales</th>
<th class="width8 centerAlign">Front</th>
<th class="width8 centerAlign">Comm<br/>pay</th>
<th class="width8 centerAlign">Bonus</th>
<th class="width8 centerAlign">Cash<br/>Recieved</th>
<th class="width8 centerAlign">Supp/<br/>Trans</th>
<th class="width8 centerAlign">Total<br/>Cancel</th>
<th class="width8 centerAlign">Cancel<br/>comm</th>
<th class="width8 centerAlign">Bonuses<br/>Lost</th>
<th class="width8 centerAlign">Day Total</th>
<th class="width8 centerAlign">End Balance</th>
</tr>
<%
//Initilize the Day Index
Date_Index = Current_Pay_Period_Record.Start_Date;
//Initilize all Total variables
Total_Sales = 0;
Total_Commission = 0.0;
Total_Total = 0.0;
Total_Bonus = 0.0;
Total_Draw = 0.0;
Total_S_T = 0.0;
Total_Total_Cancelations = 0.0;
Total_Cancellation_1_Commission_amount = 0.0;
Total_Bonus_Lost = 0.0;
Total_Ending_Balance = 0.0;
for each Dummy_Record in Dummy
{
//Making sure that we remain in the bounds of the pay period
if(Date_Index <= Current_Pay_Period_Record.End_Date)
{
//Account for the condition when there are no records for the agent for a given day
if(FormB[Agent == Agent_Record.ID && Date_field = Date_Index].count() > 0)
{
//In this case we pull the records from the database.
//There could be multiple day records per agent per day
for each Agent_Day_Record in FormB[Agent == Agent_Record.ID && Date_field = Date_Index] sort by Added_Time
{
%>
<tr class="zc-viewrow rightAlignTd">
<td class="leftAlign"><%=Agent_Day_Record.Date_field%></td>
<%
Total_Sales = Total_Sales + ifnull(Agent_Day_Record.Sales,0);
%>
<td><%=ifnull(Agent_Day_Record.Sales,0)%></td>
<%
Total_Commission = Total_Commission + ifnull(Agent_Day_Record.Commission,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Commission,0.0)%></td>
<%
Total_Total = Total_Total + ifnull(Agent_Day_Record.Total,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Total,0.0)%></td>
<%
Total_Bonus = Total_Bonus + ifnull(Agent_Day_Record.Bonus,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Bonus,0.0)%></td>
<%
Total_Draw = Total_Draw + ifnull(Agent_Day_Record.Draw,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Draw,0.0)%></td>
<%
Total_S_T = Total_S_T + ifnull(Agent_Day_Record.S_T,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.S_T,0.0)%></td>
<%
Total_Total_Cancelations = Total_Total_Cancelations + ifnull(Agent_Day_Record.Total_Cancelations,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Total_Cancelations,0.0)%></td>
<%
Total_Cancellation_1_Commission_amount = Total_Cancellation_1_Commission_amount + ifnull(Agent_Day_Record.Cancellation_1_Commission_amount,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Cancellation_1_Commission_amount,0.0)%></td>
<%
Total_Bonus_Lost = Total_Bonus_Lost + ifnull(Agent_Day_Record.Bonus_Lost,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Bonus_Lost,0.0)%></td>
<%
Total_Ending_Balance = Total_Ending_Balance + ifnull(Agent_Day_Record.Ending_Balance,0.0);
%>
<td>$ <%=ifnull(Agent_Day_Record.Ending_Balance,0.0)%></td>
<%
Running_Total = Running_Total + ifnull(Agent_Day_Record.Ending_Balance,0.0);
%>
<td>$ <%=Running_Total%></td>
</tr>
<%
}
/*END - For each day record */
}
else
{
//There is no database record. So we dummy up a 0.0 record
%>
<tr class="zc-viewrow rightAlignTd">
<td class="leftAlign"><%=Date_Index%></td>
<td>0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ 0.0</td>
<td>$ <%=Running_Total%></td>
</tr>
<%
}
/*END - Actual Day Record(s) OR dummy up record */
Date_Index = Date_Index.addDay(1);
}
/* END - Check that Date Index remains in bounds */
}
/* END - Running Counter on Dummy Record */
%>
<tr class="zc-viewrow rightAlignTd boldTd">
<td></td>
<td><%=Total_Sales%></td>
<td>$ <%=Total_Commission%></td>
<td>$ <%=Total_Total%></td>
<td>$ <%=Total_Bonus%></td>
<td>$ <%=Total_Draw%></td>
<td>$ <%=Total_S_T%></td>
<td>$ <%=Total_Total_Cancelations%></td>
<td>$ <%=Total_Cancellation_1_Commission_amount%></td>
<td>$ <%=Total_Bonus_Lost%></td>
<td>$ <%=Total_Ending_Balance%></td>
<td>$ <%=Running_Total%></td>
</tr>
</table>
</div>
<%
}
else
{
if(!input.ShowPrint == "False" && Int_Agent_ID != null)
{
%>
<div class="centerAlign">Agent is Inactive.</div>
<%
}
/* END - Ensure that is not Print */
}
/* END - If Agent is active or has at least one day record */
}
/* END - Check on presence of Agent ID */
}
/* END - Loop on all agents on Agent Table */
/* END == EACH AGENT CONTAINER */
%>
</div>
<%
}%>
Access your files securely from anywhere
New to Zoho Recruit?
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
Michael Mcclain
Anbu (Creator)
Joe Sweeney
Jota Eme
Karunakaran G
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator 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セミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
External download link limit
Can You please help us to understand this For Zoho WorkDrive external users, the download limit is a maximum of 5 GB total download size and a maximum of 50 first-level files and folders What is the meaning of first level? We are using these files inCRM verify details pop-up
Was there a UI change recently that involves the Verify Details pop-up when changing the Stage of a Deal to certain things? I can't for the life of me find a workflow or function, blueprint, validation rule, layout rule ect that would randomly make itAutomatically Add Recurring Zoho Meeting Events to Zoho Calendar / Zoho Meeting Calendar
Hello Zoho Meeting Team, Hope you are doing well. We would like to request an enhancement regarding recurring meetings created inside Zoho Meeting. At the moment, when we schedule a recurring meeting in Zoho Meeting, it does not appear in Zoho CalendarThe difference between Zoho Marketing Automation and Zoho Campaigns
Greetings Marketers! This post aims to differentiate between Zoho Marketing Automation and Zoho Campaigns. By the time you get to the end of the post, you will be able to choose a product that objectively suits you. What is Zoho Marketing Automation?Custom templates for calendar report
What about being able to design custom templates for the calendar report, as well as for other types of reports? I think more users are waiting for this.Print a price list or price book
Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (moreDisable payment thank-you emails
Hello, can someone please tell me how to disable sending of the "Payment Thank-You" emails?Maximum tags possible in Contacts Records
I read in some documentation that Zoho allows a total of 200 tags across all records. Is this correct? So is it not possible to have one tag per record for 500 records?Any way to "Pay with Check" or "Refund with Check" for Credit Notes?
When we have a Bill in Zoho Books, we can select the "Pay with Check" option which then allows us to print/cut the check directly out of Zoho Books. When we created a Credit Note and want to refund the customer, is there any way to Refund with Check,CRM Mobile reports
When our engineers finish a job they like to email the customer a job report. This is best done todate as an email template but we can find no way to include an image field from that module. Is there any other options?When Zoho Tables Beta will be open to EU data center
Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!Start Form on a different page (i.e., hide form pages)?
I have a Zoho form that uses the `Field Alias - Prefill URL` feature. My goal is to have a pre-filled field that directs the user to a specific starting page in the form. For example: The URL will have a field alias that will auto-populate a field withHow can we disable "My Requests"?
We are not using this functionality in our system at all and our users get confused.PayPal payment received recording problem
Hi, A little while back one of our customers used the PayPal payment option to pay an invoice For some reason though the payment is showing up twice within the Payments section of the invoice! Instead of setting the invoice value to ZERO, it now shows a negative value Anyone else face this problem? I've checked PayPal and there is only 1 payment in reality... A bug? Actonia ps: for anyone from Zoho Customer Service or tech team, its Invoice 785 in our accountstring(87) "{"code":"INVALID_TOKEN","details":{},"message":"invalid oauth token","status":"error"} " grtting this error
Using access token i am trying to add sales orders through api but it is throwing errors like the above i have mentioned. Please help me for thatHow to mute chat notification sound by default in Zoho SalesIQ?
We’ve recently embedded the Zoho SalesIQ chatbot on our website, and we’ve noticed that notification sounds sometimes play even when the visitor hasn’t interacted with the chat widget yet. We’re trying to understand two things: Why do these sounds occurKanban View for Projects.
At our organization, we describe active projects with various statuses like "In Proofing" or "Printing" or "Mailing". In the Projects view, one can set these project statuses by selecting from the appropriate drop-down. While this works, it's difficult to view and comprehend the progress of all of your projects relative to each other in a table. Creating a Kanban view for projects where I can move them from one status to another allows me to see where each project is in the order of our workflow.How to Hide Article Links in SalesIQ Answer Bot Responses
I have published an article in SalesIQ, and the Answer Bot is fetching the data and responding correctly. However, it is also displaying the article link, which I don’t want. How can I remove the link so that only the message is shown?Add RECURRING option when adding email to calendar events
When you add an email to a calendar event, there is no option to make that new calendar event into a recurring event. It is counterproductive to make an event from your email to then have to go to your calendar, find the event, and make it recurring.Using Contains as a filter
We are using Zoho Reports, ServiceDesk Plus analytics. I do not see how to create a report filter using Contains comparison of a string values, is one string contained in another. For example, Task Title contains the word Monitor. Is this possible in Zoho Reports? This reporting feature is available in SDP reporting. Thanks in advance, Craig RiceLINE Auto Message Connect to Zoho
When I integrated LINE into the CRM, I was prompted to disable “Chat,” “Auto Response,” and “Greeting Messages,” and to enable the webhook. However, since I have already set up some auto-reply features in LINE, including Rich Messages and greeting automation,Option to block bookings from specific email address or ip adresss in zoho booking
Sometime few of our client keep booking irrelevant booking service just to resolve their queries and they keep booking it again and again whenever they have queries. Currently its disturbing our current communication process and hierarchy which we haveThreaded conversations for emails sent via automation
Hi Guys, I hope you are doing well. Don't you guys think we should have an option in a workflow to notify users either as a new email or the previous email thread. For example, if you have one deal in the process and there are 10 different stages duringAll new Address Field in Zoho CRM: maintain structured and accurate address inputs
The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Managing addressesCreate folder is fetch fails
coming from zapier... zapier has a google drive task that searches for a specific folder in google drive, and if it fails to find the folder it will create a folder based on the search criteria, and contine along the singluar path of the flow. TryingMeetups de Usuarios de Zoho - Noviembre 2025
¡Hola, Comunidad! Durante el mes de noviembre celebraremos los Meetups de usuarios de Zoho, encuentros presenciales pensados para quienes queráis mejorar vuestras estrategias de lead nurturing y aprender a sacar el máximo partido a herramientas como ZohoIntroducing 7 New Connectors in Zoho DataPrep!
We’ve just made data management even easier - Zoho DataPrep now supports 7 new external connectors to help you build more robust, scalable ETL pipelines. Why it matters: ✅ Broader data access ✅ More automation, less manual work ✅ Smarter pipelines, betterSales Order, Invoice and Payment numbers
Hi zoho friends, it is me again, the slow learner. I'm wondering if there is a way to have it so the Sales order, invoice and payment numbers are all the same? It would be easier for me if they were the same number so there is not so many reference numbersMissing information data Zoho inventory
there some missing data in Zoho inventory connection. pick list stock counts bin location we have requested it via mail and the support team doesn’t gove feedback. has anyone achieve to get these info or to ask other ya lesFirst day of trying FSM in the field.
What we found. 1. with out a network connection we were unable to start a service call? 2. if you go to an appointment and then want to add an asset it does not seem possible. 3. disappointed not to be able to actually take a payment from within the appZoho Desk app update: AI powered features
Hello everyone! We’ve introduced various AI-powered services on the Zoho Desk app. Let's take a look at what's new. Generate Content: Generate Content uses AI to formulate responses based on the your query and provides a ready-to-use reply which can beHow to Automate Email Sequence
I'm having trouble trying to set up a workflow to automate an email sequence. Once a group of emails in a Task has been tagged by a certain tag, I want an instant email template to be sent. After 7 days with no response, another email template would beTurning off the new UI
Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?Zoho Sprints Android v2.0.4 app update: Item reminders, archive Epics, Kanban projects, Epic progress
Hello everyone! In the latest version(v2.0.4) of the Zoho Sprints Android app update, we have introduced various new features. Let's take a look at what's new! Item Reminder Stay organized and never miss an important date with the all-new Item ReminderCredit Management: #3 Setting Credit Limit for Customers
Think about that one familiar customer of yours who always buys on credit. They usually pay on time, maybe a little late here and there, but not alarming. So, you are fine saying, "Sure, pay later." Then, one day, they place a significantly bigger orderCanvas View in Zoho Recruit
Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?Adding Reports to Portals
Is there a way to add Reports to portals so only the user can see report templates relevant to them?Update on the client portal URL for Guest users
We’re updating the way Guest users access their Connect network. As part of this change, all client organization portals used by Guest users will now be accessible through a dedicated domain specific to each data center. The access URLs mentioned herePreserve Ticket Issue Mapping When Migrating from Jira to Zoho Projects
Hello Zoho Projects Team, We hope you are doing well. We are currently exploring a full migration from Jira to Zoho Projects, and we identified a critical limitation during the migration process involving Zoho Desk integration. Current Situation: We useEnhancements to Zoho Maps integration tasks
Hello everyone, We're excited to announce enhancements to the Zoho Maps integration tasks in Deluge, which will boost its performance. This post will walk you through the upcoming changes, explain why we're making them, and detail the steps you need toNext Page