The Issue
After modifying a report and on running it, Report Builder 2.0 returns the following error:
An error occurred during local report processing.
An error has occurred ...
... Report in ZohoCreator
l_CsvLines = List();
l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name;
for each c_Product in l_ApplicableProducts
{
l_CsvRow = List();
l_CsvRow.add(c_Product.Photo);
l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ...
... }
// Setup a config to find this record (use a custom report that only has the 2 searchable fields)
var config = {
appName : "joes_quote_builder",
...
... void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID)
Trigger: On Demand when button in report is clicked
Purpose: This will send a ZohoBooks invoice directly to its recipient
Inputs: ...
... we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year the week is in. Weeks which ...
... Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62)
Date Modified: 2023-02-23 (Joel Lipman)
- Check if ebay Order ID already exists on ...
What?
A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts.
Why?
Simply the client wanted a report on customers ...
... in a JSON or ZohoDeluge Map format
m_Response = Map();
l_JsonProducts = List();
//
// start preparing CSV file to email for export
v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated";
l_CsvFileRows ...
What?
This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit.
Why?
We're creating a custom module ...
... in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order.
I' ...
... to the same school and updates some number fields on the matched CRM account.
Why?
For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...
... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report.
How?
We would think it similar to a picklist/dropdown where ...
...
Publish it by going to Settings > Publish > Publish Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string.
Create a ...
... Admin API scopes": This will be dependent on what your app needs to do. In this example, mine needs to sync orders, products, customers, and some reports; the other things like discounts, fulfillment ...
... Zoho Creator says that public link exists. Let's say I have a field called Main_Photo and this is in a form called Portal_Listing with a report/view called Portal_Listing_Report and I have a publish key ...
... photo to CRM:
// init
v_AppOwner = "joel_the_awesomest";
v_AppName = "joels_app";
v_ReportName = "My_Report";
// specify your CRM record ID for this product
v_CrmProductID = 1234567890123456789;
// ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.