Month: May 2023

Saved Search Formula: Date/Time Difference in Days – Hours – Minutes – Seconds format

DAYS TRUNC({date1}-{date2}) HOURS MOD(TRUNC(({date1}-{date2})*24),24) MINUTES TRUNC(60*((({date1}-{date2})*24)-TRUNC(({date1}-{date2})*24))) SECONDS ROUND(60*((((({date1}-{date2})*24)-TRUNC(({date1}-{date2})*24))*60)-TRUNC(((({date1}-{date2})*24)-TRUNC(({date1}-{date2})*24))*60)),0) Create a formulae text field and then concatenate all the above formula using || as a result column.

Convert Numerical Sum From Integer to Currency in Advanced PDF/HTML Template

Advanced PDF/HTML templates allows simple computations through the use of the Freemarker language. For instances where values needs to be compared or displayed on a certain format, the Freemarker language has a built in function that converts the type casting of variables. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Advanced PDF/HTML Template: Click Edit Create a variable to… Continue reading Convert Numerical Sum From Integer to Currency in Advanced PDF/HTML Template

Quoting Tool

Quote PDF Template for Foam Sealant Pty Ltd  Foam Sealant would like to create the Quote PDF template as to be very similar to the Invoice PDF layout  Deliverables  We will provide new custom Quote form which generate print based on the given layout and field mapping. So, the users can generate the print by… Continue reading Quoting Tool

Use of Billing Transaction in Saved Searches.

The “Billing Transaction” field in saved searches can be used to link transactions to their corresponding invoices. This field contains the internal ID of the invoice that is associated with a particular transaction. For example, in a saved search for sales orders, the “Billing Transaction” field can be used to retrieve details of the corresponding… Continue reading Use of Billing Transaction in Saved Searches.