Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 Total excl Tax") AS "PO Total excl Tax", SUM(invsopoitm."PO Total incl Tax") AS "PO Total incl Tax", (MAX(if_null(t2."Credit Margin excl Tax", 0)) / MAX(t3."InvCount")) AS "Credit Margin excl Tax", (MAX(if_null(t2."Credit Margin incl Tax", 0)) /...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use the example of a credit application you want to send to your customer, and when they complete it, the PDF version gets attached to their contact...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Terms & Conditionshttps://joellipman.com/static-items/terms-conditions.html

30 May 2009 either version 3 of the License, or (at your option) any later version. You are to maintain copyright information where credit is due. The scripts and programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joe's CSV Chart Generator (JCG)https://joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take any credit for the below as it was copied from http://hosteddocs.ittoolbox.com/ST030504.pdf. A "Crystal Decisions" documentation. Blank...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: *

Webdeveloper-Speakhttps://joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand providing consultation, website design,...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 be followed. An email allegedly from «CompanyName» (or another company) asking for your personal details - logins/passwords/credit card details. You get an email that claims to be from «CompanyName» or another company and requests that you reply or...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 have Windows XP, it's likely you have it anyway. Open Source: Open to view/modify the source code as long as you attribute credit where it's due. License is GNU General Public License v3 (www.opensource.org/licenses/GPL-3.0). FREE / Gratis Did I not...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 opinions vary between "Microsoft Certified Professionals", just a piece of paper and proof you're good at theory IMO, no credit for being the tape monkey that does all the actual work.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Prices get rounded up in Virtuemarthttps://joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card Payment Module (vm-ukcreditcard). A lot of forums were suggesting to change the number_format to convert any number to...

• Type: Article
• Author: Joel Lipman
• Category: Virtuemart
• Language: *

Zoho Deluge - Regex to Strip all non-numeric charactershttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *