Category: Advanced PDF Templates

Advanced PDF Templates designs – PDF samples and xml codes

Convert Total to Words in PDF

Solution Create a custom text field and apply formula for converting the amount to wordsThe formula is given below CASE WHEN {total}=0 THEN ‘ZERO’ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({total}, 0)),’J’),’JSP’) || ‘ ‘ || ‘AND ‘ || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”))) = 1 THENTO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”), 0)*10),’J’),’JSP’) || ‘ ONLY’ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, ‘^[0-9]+.’, ”), 0)),’J’),’JSP’) || ‘  ONLY’END)END Then… Continue reading Convert Total to Words in PDF

Body level discount at the line level in PDF Template

We can print the body level discount at the line level in the print PDF template. There is a preference for Print Discount and Shipping Lines in Column available in the account. If we enabled the Print Discount and Shipping Lines in Column feature at Setup > Company > Printing & Fax > Printing &… Continue reading Body level discount at the line level in PDF Template

PDF Template for Packing slip from Supplier Return Authorization.

Scenario 1: Printing the Terms on the packing slip PDF wasn’t possible since the purchase order terms is not accessible from the advanced PDF/HTML markup. Solution: In the Advance PDF template, not possible to get the terms value directly from Purchase order. We need to create two custom fields ( custbody_jj_po, custbody_jj_terms ) in packing slip for… Continue reading PDF Template for Packing slip from Supplier Return Authorization.