Assuming items is required, the following 51 results were found.
-
to determine the cost of each item purchased; including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as to generate meaningful reports....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html
and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument supplied for foreach() in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
update a record using invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently introduced...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
time. How? Through sweat and perseverance. The trick is to update both the sales order id and to update the invoice line items with their respective sales order item id value. For our client's purpose, we are running a custom function off the invoice...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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? By default / out-of-the-box / vanilla, in a Zoho CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
-- 9. jos_content_frontpage -> #__content_frontpage -- -- 10. jos_content_rating -> #__content_rating -- -- 11. jos_core_log_items, jos_core_log_searches -> #__core_log_searches -- -- 12. jos_menu -> #__menu, #__menu_types -- -- 13. jos_menu_types ->...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
+ ".pdf"); r_AttachResponse = zoho.crm.attachFile("Quotes",p_QuoteID,r_DownloadResponse); Use a subform (eg. Product Line Items) If I call my subform "Quoted Items" and specify this having the fields "Ref, Item, SKU, Description, Quantity, RRP,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} // // ---------------------- QUOTE LINE ITEMS ---------------------- // line items get via api v2.1 or greater l_BooksLineItems = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/" + p_QuoteID type :GET...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the price book rate post saving a record in Zoho Deluge would fail because it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. A custom...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the column: SELECT EmployeeNo , DaysOffSick , DateOfSickness ,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND n.number...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Static Itemshttps://joellipman.com/static-items.html
- Type: Category
- Language: *
-
the product "987654321098765432" and p_InvoiceID is the ID of the invoice record: v_Index = 0; m_Update = Map(); l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails = zoho.crm.getRecordById("Invoices",p_InvoiceID); for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
What? So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
The use case here is for a Quote Builder in Zoho Creator: Create a quote record and include a subform containing the line items. You may have tried code where you add a record first and then add the subform afterwards (insert into [...]) but it can be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator who is comfortable with making changes to the database Why? We have a page describing the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
It's been difficult to find an easy solution to hide menu items from registered users. Finally, I found a solution that works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
1 Welcome This is Joomla 2 Copyright This site and its design is property of JoelLipman.com HP Articles (table name: jos_hp_items): id name description -------------------------------------------------------------------------- 1 Welcome This is HP 2...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB