To convert amount in words and include the customer currency along with it.. Created a custom field. And enter the below given formula in the default value field. {currencysymbol} is the internal id of currency. {currencysymbol} || ‘ ‘ || CASE WHEN {total}=0 THEN ‘ZERO’ ELSE TO_CHAR(TO_TIMESTAMP(LPAD(TRUNC({total}, 0), 9, ‘0’), ‘FF9’ ), ‘FFSP’) ||’ ‘… Continue reading To convert amount in words and include the customer currency along with it.
Tag: custom field with formula,
To convert amount in INR to words using formula
To convert amount in INR to words using formula. Created a custom field. And enter the below given formula in the default value field. ‘RUPEES’ || ‘ ‘ || CASE WHEN {custbody_amount_in_inr}=0 THEN ‘ZERO’ ELSE TO_CHAR(TO_TIMESTAMP(LPAD(TRUNC({custbody_amount_in_inr}, 0), 9, ‘0’), ‘FF9’ ), ‘FFSP’) ||’ ‘ || (CASE WHEN {custbody_amount_in_inr}-TRUNC({custbody_amount_in_inr}, 0) > 0 THEN ‘ AND ‘… Continue reading To convert amount in INR to words using formula
Map Link Customization
Generate Map link based on the bill address information such as address1, address2 and address3 only. Create custom field to store the map link for the Billing Address with the following parameters specified. Label: Map ID: _map Type: Hyperlink Store Value: Not checked Applies To: Customer Display / Subtab: Main Display / Link Text: Click… Continue reading Map Link Customization