... you can lock it down to just the scopes you need.
void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID)
{
v_OrderID = ifnull(input.p_OrderID,0).toLong();
/* *******************************************************************************
Function: ...
... has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below ...
... but in the United Kingdom, the week generally starts on a Monday. So let's say there's a schedule that has to be run weekly and include all the orders of a specific week...
Just to confuse everyone ...
... adding label because -3 often displays "Net 56" instead.
m_InvoiceDetails.put("payment_terms_label","Due end of next month");
//
// loop through line items and populate
for each m_SOLineItem in l_SalesOrderLineItems
{
...
... key here to enable inventory tracking
m_CreateBooksItem.put("item_type","inventory");
//
// other less important values to include re purchase information
m_CreateBooksItem.put("product_type","goods");
m_CreateBooksItem.put("reorder_level",0);
m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong());
m_CreateBooksItem.put("initial_stock",v_Quantity.toLong());
m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal());
m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...
... "id": "123456789000000123456789",
"type": "custom"
}
}
Tidied Up
Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal wee ...
What?
A quick note here on how to connect to the DHL API and check on a package given a tracking number.
Why?
In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...
... build up COQL query
v_CoqlQuery = "select Content, Role from GPT_Chats where Owner='" + v_LoggedInUserID + "' order by Created_Time asc";
//
// build up parameters
m_Params = Map();
m_Params.put("select_query",v_CoqlQuery);
//
// ...
... ", ",").toList();
for each index v_Increment in l_AddPages
{
l_Pages.add(v_StartingPageIndex + v_Increment);
}
v_TotalNumberOfPages = l_Pages.size();
//
// declare variables to store order details ...
... to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried this.
Source(s):
Shopify Dev - Paginating results with GraphQL
...
... = (v_Page - 1) * v_PerPage;
v_ToIndex = v_FromIndex + v_PerPage - 1;
//
// note that ordering here seemed to do nothing... it's in an order, not sure what order. Let's loop through every page anyway.
l_Candidates ...
... that will be attached to Contact records and Sales Orders, you will need to include at this step the "Contacts_001.csv" and "Sales Orders_001.csv" (preferably taken from a backup):
Watch the spinning ...
... for future use. The use-case is the client has their own delivery drivers and want them to mark a sales order & package as shipped and delivered.
How?
Here's a code snippet that works for me. It ...
What?
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page.
Why?
Cos
How?
The below is a template ...
... form to download the attachments and upload them to the Creator "Document" form:
//
// get attachments
v_NoteAttachments = "";
m_SortCriteria = Map();
m_SortCriteria.put("sort_by","Created_Time");
m_SortCriteria.put("sort_order","desc");
l_Attachments ...
... store with a pre-built description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app ...
What?
A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this).
Why? ...
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.