Knowledgebase

How do I use the RTF (Rich Text Format) option to create document templates in OpenCRM? What field merge tags are available for Rich text (RTF) document template merging?
	Updated: 16 May 2012 17:26:28	OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies OpenCRM::Documents OpenCRM::Settings::Templates OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice

Within OpenCRM we have a feature that allows you to use RTF documents (from Word or Open Office) as merge templates, please read the PDF document attached (link at the bottom of the FAQ) for an overview of how this works.

Any field which is available to the user in the interface of OpenCRM is available to be merged into a RTF document. Below is a list of all field tags and where they can be used.

As of OpenCRM v 3.02 it is also possible to use various date fields:

The following tags are available to allow you to add the current date information (the date of merge) into an ODT/RTF/DOC template:

CURRENT_DATE(e.g. 12-12-2012)
CURRENT_TIME (e.g. 12:12)
DAY_SHORT (e.g. Mon)
DAY_LONG (e.g Monday)
DAY_NUM (e.g 21)
MONTH_SHORT (e.g. Jan)
MONTH_LONG (e.g. January)
MONTH_NUM(e.g. 11)
YEAR_SHORT (e.g 12)
YEAR_LONG (e.g. 2012)

Company Fields

• Please note: merging RTF to a company will generate an RTF document for every linked contact

You can also include fields from the following modules:

• Contacts (any linked contact - as above, it will generate an RTF document for each contact linked
• Assigned Users
• Current User
• My Company Details
• Custom text tags

Annual Revenue: ACCOUNT_ANNUALREVENUE
Assigned To: ACCOUNT_ASSIGNEDTO
Billing Address (Street): ACCOUNT_BILLINGADDRESS
Billing City: ACCOUNT_BILLINGCITY
Billing State: ACCOUNT_BILLINGSTATE
Billing Postcode: ACCOUNT_BILLINGCODE
Billing Country: ACCOUNT_BILLINGCOUNTRY
Billing Email: ACCOUNT_BILLINGEMAIL
Company Name: ACCOUNT_ACCOUNTNAME
Company Number: ACCOUNT_COMPANYNUMBER
Coordinates: ACCOUNT_COORDINATES
Credit Check By: ACCOUNT_CREDITCHECKBY
Credit Check On: ACCOUNT_CREDITCHECKON
Credit Limit: ACCOUNT_CREDITLIMIT
Credit Status: ACCOUNT_CREDITSTATUS
Current Spend: ACCOUNT_CURRENTSPEND
Default Currency: ACCOUNT_DEFAULTCURRENCY
Description: ACCOUNT_DESCRIPTION
Do Not Email: ACCOUNT_DONOTEMAIL
Do Not Fax: ACCOUNT_DONOTFAX
Do Not Phone: ACCOUNT_DONOTPHONE
Email: ACCOUNT_EMAIL
Employees: ACCOUNT_EMPLOYEES
Fax: ACCOUNT_FAX
Include In Sync: ACCOUNT_INCLUDEINSYNC
Industry: ACCOUNT_INDUSTRY
Last Action: ACCOUNT_LASTACTION
Last Action Date: ACCOUNT_LASTACTIONDATE
Major Account: ACCOUNT_MAJORACCOUNT
Other Email: ACCOUNT_OTHEREMAIL
Outstanding Balance: ACCOUNT_OUTSTANDINGBALANCE
Overdue Balance: ACCOUNT_OVERDUEBALANCE
Ownership: ACCOUNT_OWNERSHIP
Payment Type: ACCOUNT_PAYMENTTYPE
Phone: ACCOUNT_PHONE
Phone (Other): ACCOUNT_OTHERPHONE
Portal Terms Accepted: ACCOUNT_PORTALTERMSACCEPT
Pricebook: ACCOUNT_PRICEBOOK
Proprietor: ACCOUNT_PROPRIETOR
Registered Address (Street): ACCOUNT_REGISTEREDADDRESS
Registered City: ACCOUNT_REGISTEREDCITY
Registered State: ACCOUNT_REGISTEREDSTATE
Registered Postcode: ACCOUNT_REGISTEREDCODE
Registered Country: ACCOUNT_REGISTEREDCOUNTRY
Rating: ACCOUNT_RATING
Sage Install: ACCOUNT_SAGEINSTALL
Sage Reference: ACCOUNT_SAGEREFERENCE
Security: ACCOUNT_SECURITY
Send To Sage: ACCOUNT_SENDTOSAGE
Sent To Sage On: ACCOUNT_SENTTOSAGEON
Share With Groups: ACCOUNT_SHAREWITHGROUPS
Shipping Address (Street): ACCOUNT_SHIPPINGADDRESS
Shipping City: ACCOUNT_SHIPPINGCITY
Shipping State: ACCOUNT_SHIPPINGSTATE
Shipping Postcode: ACCOUNT_SHIPPINGCODE
Shipping Country: ACCOUNT_SHIPPINGCOUNTRY
Shipping Email: ACCOUNT_SHIPPINGEMAIL
SIC Code: ACCOUNT_SICCODE
Spend Variance: ACCOUNT_SPENDVARIANCE
Ticker Symbol: ACCOUNT_TICKERSYMBOL
Time To Pay: ACCOUNT_TIMETOPAY
Type: ACCOUNT_TYPE
VAT Exempt: ACCOUNT_VATEXEMPT
VAT Number: ACCOUNT_VATNUMBER
Website: ACCOUNT_WEBSITE

 

Contact Fields

You can also include fields from the following modules:

• Company (primary linked company)
• Assigned users
• Current User
• My company details
• Custom text tags

Address Inherit: CONTACT_ADDRESSINHERIT
Assigned To: CONTACT_ASSIGNEDTO
Assistant: CONTACT_ASSISTANT
Birthdate: CONTACT_BIRTHDATE
Can eSign: CONTACT_CANESIGN
Contact Type: CONTACT_CONTACTTYPE
Coordinates: CONTACT_COORDINATES
Created Time: CONTACT_CREATEDTIME
Department: CONTACT_DEPARTMENT
Description: CONTACT_DESCRIPTION
Do Not Call: CONTACT_DONOTCALL
Do Not Email: CONTACT_DONOTEMAIL
Do Not Fax: CONTACT_DONOTFAX
Do Not Phone: CONTACT_DONOTPHONE
Email (Business): CONTACT_EMAIL
Email (Private): CONTACT_EMAIL2
Email Opt Out: CONTACT_EMAILOPTOUT
Fax: CONTACT_FAX
First Name: CONTACT_FIRSTNAME
Greeting: CONTACT_GREETING
Include In Sync: CONTACT_INCLUDEINSYNC
Job Title: CONTACT_TITLE
Last Action: CONTACT_LASTACTION
Last Action Date: CONTACT_LASTACTIONDATE
Last Name: CONTACT_LASTNAME
Lead Source: CONTACT_LEADSOURCE
Login: CONTACT_LOGIN
Mailing Street: CONTACT_MAILINGSTREET
Mailing Country: CONTACT_MAILINGCOUNTRY
Mailing City: CONTACT_MAILINGCITY
Mailing State: CONTACT_MAILINGSTATE
Mailing Zip: CONTACT_MAILINGZIP
Middle Name: CONTACT_MIDDLENAME
Modified Time: CONTACT_MODIFIEDTIME
Other Street: CONTACT_OTHERSTREET
Other City: CONTACT_OTHERCITY
Other State: CONTACT_OTHERSTATE
Other Zip: CONTACT_OTHERZIP
Other Country: CONTACT_OTHERCOUNTRY
Password (for Portal): CONTACT_PASSWORD
Phone (Assistant): CONTACT_ASSISTANTPHONE
Phone (Home): CONTACT_HOMEPHONE
Phone (Mobile): CONTACT_MOBILE
Phone (Office): CONTACT_OFFICEPHONE
PIN (for Portal): CONTACT_PIN
PIN Reset (for Portal): CONTACT_PINRESET
Portal Components: CONTACT_PORTALCOMPONENTS
Portal User: CONTACT_PORTALUSER
Preferred Contact Method: CONTACT_PREFERREDCONTACTMETHOD
Reports To: CONTACT_REPORTSTO
Salutation: CONTACT_SALUTATION
Security: CONTACT_SECURITY
Share With Groups: CONTACT_SHAREWITHGROUPS
Support End Date: CONTACT_SUPPORTENDDATE
Support Start Date: CONTACT_SUPPORTSTARTDATE
Yahoo Id: CONTACT_YAHOOID

 

Lead Fields

City: LEAD_CITY
Company: LEAD_COMPANY
Country: LEAD_COUNTRY
Email: LEAD_EMAIL
Fax: LEAD_FAX
First Name: LEAD_FIRSTNAME
Greeting: LEAD_GREETING
Industry: LEAD_INDUSTRY
Job Title: LEAD_DESIGNATION
Last Name: LEAD_LASTNAME
Lead Source: LEAD_LEADSOURCE
Lead Status: LEAD_LEADSTATUS
Mobile: LEAD_MOBILE
No. of Employees: LEAD_NOOFEMPLOYEES
Phone: LEAD_PHONE
Postcode: LEAD_POSTALCODE
Rating: LEAD_RATING
Salutation: LEAD_SALUTATION
Street: LEAD_STREET

 

Quote Fields

From a quote, you can also include fields from the following modules:

• Company (main linked company on quote record)
• Contact (main linked contact on quote record)
• Products (products linked to quote)
• Quote -> product relationship
• Assigned users
• Current User
• My company details
• Custom text tags

Adjustment: QUOTE_ADJUSTMENT
Billing Address (Street): QUOTE_BILLINGADDRESS
Billing City: QUOTE_BILLINGCITY
Billing State: QUOTE_BILLINGSTATE
Billing Postcode: QUOTE_BILLINGCODE
Billing Country: QUOTE_BILLINGCOUNTRY
Billing Email: QUOTE_BILLINGEMAIL
Campaign: QUOTE_CAMPAIGN
Carrier: QUOTE_CARRIER
Cost Centre: QUOTE_COSTCENTRE
Default Currency: QUOTE_DEFAULTCURRENCY
Discount: QUOTE_DISCOUNT
Estimated Cost: QUOTE_ESTIMATEDCOST
Include VAT: QUOTE_INCLUDEVAT
Inventory Manager: QUOTE_INVENTORYMANAGER
Pricebook: QUOTE_PRICEBOOK
Products Per Page: QUOTE_PRODUCTSPERPAGE
Project Name: QUOTE_PROJECTNAME
Quote ID: QUOTE_QUOTE_ID
Quote Stage: QUOTE_QUOTESTAGE
Quote Type: QUOTE_QUOTETYPE
Sales Commission: QUOTE_SALESCOMMISSION
Shipping: QUOTE_SHIPPING
Shipping Address (Street) : QUOTE_SHIPPINGADDRESS
Shipping City: QUOTE_SHIPPINGCITY
Shipping State: QUOTE_SHIPPINGSTATE
Shipping Code: QUOTE_SHIPPINGCODE
Shipping Country: QUOTE_SHIPPINGCOUNTRY
Shipping Email: QUOTE_SHIPPINGEMAIL
Show On Portal: QUOTE_SHOWONPORTAL
Show Quantities: QUOTE_SHOWQUANTITIES
Sub Total: QUOTE_SUBTOTAL
Subject: QUOTE_SUBJECT
Tax: QUOTE_TAX
Terms & Conditions: QUOTE_TERMS&CONDITIONS
Total: QUOTE_TOTAL
Total Margin: QUOTE_TOTALMARGIN
Valid Till: QUOTE_VALIDTILL
VAT Rate: QUOTE_VAT_RATE
Carrier: QUOTE_CARRIER

Sales Order Fields

From a sales order, you can also include fields from the following modules:

• Company (main linked company on sales order record)
• Contact (main linked contact on sales order record)
• Products (products linked to sales order)
• Sales Order -> product relationship
• Assigned users
• Current User
• My company details
• Custom text tags

Billing Address (Street): SALESORDER_BILLINGADDRESS
Billing City: SALESORDER_BILLINGCITY
Billing State: SALESORDER_BILLINGSTATE
Billing Code: SALESORDER_BILLINGCODE
Billing Country: SALESORDER_BILLINGCOUNTRY
Billing Email: SALESORDER_BILLINGEMAIL
Campaign: SALESORDER_CAMPAIGN
Carrier: SALESORDER_CARRIER
Cost Centre: SALESORDER_COSTCENTRE
Customer No: SALESORDER_CUSTOMERNO
Discount: SALESORDER_DISCOUNT
Default Currency: SALESORDER_DEFAULTCURRENCY
Due Date: SALESORDER_DUEDATE
e-Signed By: SALESORDER_E-SIGNEDBY
e-Signed Date: SALESORDER_E-SIGNEDDATE
Excise Duty: SALESORDER_EXCISEDUTY
Fulfil By: SALESORDER_FULFILBY
Include VAT: SALESORDER_INCLUDEVAT
Job Accepted: SALESORDER_JOBACCEPTED
Job Completed: SALESORDER_JOBCOMPLETED
Job Date: SALESORDER_JOBDATE
Job Status: SALESORDER_JOBSTATUS
Job Time: SALESORDER_JOBTIME
Last Invoiced: SALESORDER_LASTINVOICED
Lease Acceptance Date: SALESORDER_LEASEACCEPTANCEDATE
Leased by: SALESORDER_LEASEDBY
Lock Products: SALESORDER_LOCKPRODUCTS
Order Weight: SALESORDER_ORDERWEIGHT
Partner: SALESORDER_PARTNER
Payment Day: SALESORDER_PAYMENTDAY
Payment Type: SALESORDER_PAYMENTTYPE
Pending: SALESORDER_PENDING
Pricebook: SALESORDER_PRICEBOOK
Products Per Page: SALESORDER_PRODUCTSPERPAGE
Purchase Order: SALESORDER_PURCHASEORDER
Recurs: SALESORDER_RECURS
Recur From: SALESORDER_RECURFROM
Recur Interval: SALESORDER_RECURINTERVAL
Recur Type: SALESORDER_RECURTYPE
Recur Until: SALESORDER_RECURUNTIL
Require Financial Authorisation: SALESORDER_REQUIREFINANCIALAUTH
Sage Install: SALESORDER_SAGEINSTALL
Sales Commission: SALESORDER_SALESCOMMISSION
Sales Order As Job: SALESORDER_SALESORDERASJOB
Sales Order ID: SALESORDER_SALESORDER_ID
Sales Tax: SALESORDER_SALESTAX
Security: SALESORDER_SECURITY
Sent To Sage: SALESORDER_SENTTOSAGE
Sent To Sage On: SALESORDER_SENTTOSAGEON
Share With Groups: SALESORDER_SHAREWITHGROUPS
Shipping Address (Street): SALESORDER_SHIPPINGADDRESS
Shipping City: SALESORDER_SHIPPINGCITY
Shipping State: SALESORDER_SHIPPINGSTATE
Shipping Code: SALESORDER_SHIPPINGCODE
Shipping Country: SALESORDER_SHIPPINGCOUNTRY
Shipping Email: SALESORDER_SHIPPINGEMAIL
Show On Portal: SALESORDER_SHOWONPORTAL
SO Value Figure: SALESORDER_SOVALUEFIGURE
SO Value Words: SALESORDER_SOVALUEWORDS
SO Value Figure: SALESORDER_SOVALUEFIGURE
Status: SALESORDER_STATUS
Sub-Total: SALESORDER_SUB-TOTAL
Subject: SALESORDER_SUBJECT
Terms & Conditions: SALESORDER_TERMS&CONDITIONS
Total: SALESORDER_TOTAL
Total Margin: SALESORDER_TOTALMARGIN
VAT Rate: SALESORDER_VAT_RATE

Invoice Fields

From a invoice, you can also include fields from the following modules:

• Company (main linked company on sales order record)
• Contact (main linked contact on sales order record)
• Products (products linked to sales order)
• Invoice -> product relationship
• Assigned users
• Current User
• My company details
• Custom text tags

Account Name: INVOICE_ACCOUNTNAME
Billing Address (Street): INVOICE_BILLINGADDRESS
Billing City: INVOICE_BILLINGCITY
Billing State: INVOICE_BILLINGSTATE
Billing Postcode: INVOICE_BILLINGCODE
Billing Country: INVOICE_BILLINGCOUNTRY
Billing Email: INVOICE_BILLINGEMAIL
Campaign: INVOICE_CAMPAIGN
Company VAT Num: INVOICE_COMPANYVATNUM
Contact Name: INVOICE_CONTACTNAME
Customer No: INVOICE_CUSTOMERNO
Default Currency: INVOICE_DEFAULTCURRENCY
Discount: INVOICE_DISCOUNT
Due Date: INVOICE_DUEDATE
Excise Duty: INVOICE_EXCISEDUTY
Include VAT: INVOICE_INCLUDEVAT
Invoice Date: INVOICE_INVOICEDATE
Invoice ID: INVOICE_INVOICE_ID
Invoice Number: INVOICE_INVOICENUMBER
Lease Acceptance Date: INVOICE_LEASEACCEPTANCEDATE
Leased by: INVOICE_LEASEDBY
Outstanding: INVOICE_OUTSTANDING
Paid Date: INVOICE_PAIDDATE
Payment Date: INVOICE_PAYMENTDATE
Payment Day: INVOICE_PAYMENTDAY
Payment Type: INVOICE_PAYMENTTYPE
Potential Name: INVOICE_POTENTIALNAME
Products Per Page: INVOICE_PRODUCTSPERPAGE
Pricebook: INVOICE_PRICEBOOK
Project Name: INVOICE_PROJECTNAME
Purchase Order: INVOICE_PURCHASEORDER
Quote Name: INVOICE_QUOTENAME
Recur Interval: INVOICE_RECURINTERVAL
Requires Financial Authorisation: INVOICE_REQUIREFINANCIALAUTH
Sage Install: INVOICE_SAGEINSTALL
Sales Commission: INVOICE_SALESCOMMISSION
Sales Order: INVOICE_SALESORDER
Sales Tax: INVOICE_SALESTAX
Send To Sage: INVOICE_SENDTOSAGE
Sent To Sage On: INVOICE_SENTTOSAGEON
Shipping Address (Street): INVOICE_SHIPPINGADDRESS
Shipping City: INVOICE_SHIPPINGCITY
Shipping State: INVOICE_SHIPPINGSTATE
Shipping Postcode: INVOICE_SHIPPINGCODE
Shipping Country: INVOICE_SHIPPINGCOUNTRY
Shipping Email: INVOICE_SHIPPINGEMAIL
Show On Portal: INVOICE_SHOWONPORTAL
Status: INVOICE_STATUS
Sub Total: INVOICE_SUBTOTAL
Subject: INVOICE_SUBJECT
Terms & Conditions: INVOICE_TERMS&CONDITIONS
Total: INVOICE_TOTAL
Total Margin: INVOICE_TOTALMARGIN
VAT Rate: INVOICE_VAT_RATE

Purchase Order Fields

From a purchase order, you can also include fields from the following modules:

• Company (main linked supplier on order record)
• Contact (main linked contact on order record)
• Products (products linked to order)
• Purchase Order -> product relationship
• Assigned users
• Current User
• My company details
• Custom text tags

Account Name: PURCHASEORDER_ACCOUNTNAME
Adjustment: PURCHASEORDER_ADJUSTMENT
Bill To: PURCHASEORDER_BILL_TO
Billing Address (Street): PURCHASEORDER_BILLINGADDRESS
Billing City: PURCHASEORDER_BILLINGCITY
Billing State: PURCHASEORDER_BILLINGSTATE
Billing Postcode: PURCHASEORDER_BILLINGCODE
Billing Country: PURCHASEORDER_BILLINGCOUNTRY
Billing Email: PURCHASEORDER_BILLINGEMAIL
Carrier: PURCHASEORDER_CARRIER
Contact Name: PURCHASEORDER_CONTACTNAME
Cost Centre: PURCHASEORDER_COSTCENTRE
Default Currency: PURCHASEORDER_DEFAULTCURRENCY
Discount: PURCHASEORDER_DISCOUNT
Due Date: PURCHASEORDER_DUEDATE
Excise Duty: PURCHASEORDER_EXCISEDUTY
Include VAT: PURCHASEORDER_INCLUDEVAT
Opportunity Name: PURCHASEORDER_POTENTIALNAME
Outstanding: PURCHASEORDER_OUTSTANDING
Products Per Page: PURCHASEORDER_PRODUCTSPERPAGE
Project Name: PURCHASEORDER_PROJECTNAME
Purchase Order ID: PURCHASEORDER_PURCHASEORDER_ID
Requisition No: PURCHASEORDER_REQUISITIONNO
Sage Install: PURCHASEORDER_SAGEINSTALL
Sales Commission: PURCHASEORDER_SALESCOMMISSION
Sales Order: PURCHASEORDER_SALESORDER
Sales Tax: PURCHASEORDER_SALESTAX
Sent To Sage: PURCHASEORDER_SENTTOSAGE
Sent To Sage On: PURCHASEORDER_SENTTOSAGEON
Shipping Address (Street): PURCHASEORDER_SHIPPINGADDRESS
Shipping City: PURCHASEORDER_SHIPPINGCITY
Shipping State: PURCHASEORDER_SHIPPINGSTATE
Shipping Postcode: PURCHASEORDER_SHIPPINGCODE
Shipping Country: PURCHASEORDER_SHIPPINGCOUNTRY
Shipping Email: PURCHASEORDER_SHIPPINGEMAIL
Ship To: PURCHASEORDER_SHIP_TO
Status: PURCHASEORDER_STATUS
Sub Total: PURCHASEORDER_SUBTOTAL
Subject: PURCHASEORDER_SUBJECT
Terms & Conditions: PURCHASEORDER_TERMS&CONDITIONS
Total: PURCHASEORDER_TOTAL
Tracking Number: PURCHASEORDER_TRACKINGNUMBER
VAT Rate: PURCHASEORDER_VAT_RATE
Vendor Name: PURCHASEORDER_VENDORNAME

Product Fields

Product fields can be used in RTF merges for Quote, Sales order, Invoice, Purchase Orders

Allocated Stock: PRODUCT_ALLOCATEDSTOCK
Auto Generated Title: PRODUCT_AUTOGENERATEDTITLE
Backordered Stock: PRODUCT_BACKORDEREDSTOCK
Backorder - Ordered Stock: PRODUCT_BACKORDER-ORDEREDSTOCK
Bin: PRODUCT_BIN
Buy Price: PRODUCT_BUYPRICE
Buyer: PRODUCT_BUYER
Commission Rate: PRODUCT_COMMISSIONRATE
Created Time: PRODUCT_CREATEDTIME
Customer: PRODUCT_CUSTOMER
Cust Part Number: PRODUCT_CUSTPARTNUMBER
Date In: PRODUCT_DATEIN
Default Currency: PRODUCT_DEFAULTCURRENCY
Description: PRODUCT_DESCRIPTION
Despatch Date: PRODUCT_DESPATCHDATE
Est Cost (Supplier) Price: PRODUCT_ESTCOST(SUPPLIER)PRICE
GL Account: PRODUCT_GLACCOUNT
Handler: PRODUCT_HANDLER
Installer: PRODUCT_INSTALLER
Manage Stock: PRODUCT_MANAGESTOCK
Manufacturer: PRODUCT_MANUFACTURER
Manufacturer Part No: PRODUCT_MFRPARTNO
Mini Description: PRODUCT_MINIDESCRIPTION
Model Revision: PRODUCT_MODELREVISION
Modified Time: PRODUCT_MODIFIEDTIME
Nominal Code: PRODUCT_NOMINALCODE
Ordered Stock: PRODUCT_ORDEREDSTOCK
Parent Product: PRODUCT_PARENTPRODUCT
Price Check Date: PRODUCT_PRICECHECKDATE
Product Active: PRODUCT_PRODUCTACTIVE
Product Category: PRODUCT_PRODUCTCATEGORY
Product Code: PRODUCT_PRODUCTCODE
Product Image: PRODUCT_PRODUCTIMAGE
Product Name: PRODUCT_PRODUCTNAME
Product Status: PRODUCT_PRODUCTSTATUS
Product Type: PRODUCT_PRODUCTTYPE
Purchase Nominal Code: PRODUCT_PURCHASENOMINALCODE
Purchase Nominal Description: PRODUCT_PURCHASENOMINALDESCRIPTION
Quantity In Demand: PRODUCT_QTYINDEMAND
Quantity In Stock: PRODUCT_QTYINSTOCK
Quantity/ Unit: PRODUCT_QTY/UNIT
Reccuring Period: PRODUCT_RECCURINGPERIOD
Reorder Level: PRODUCT_REORDERLEVEL
Returned Stock: PRODUCT_RETURNEDSTOCK
Sales End Date: PRODUCT_SALESENDDATE
Sales Start Date: PRODUCT_SALESSTARTDATE
Sell Price: PRODUCT_SELLPRICE
Serial No: PRODUCT_SERIALNO
Shelf: PRODUCT_SHELF
Shipped Stock: PRODUCT_SHIPPEDSTOCK
Size: PRODUCT_SIZE
Sub Product Type: PRODUCT_SUBPRODUCTTYPE
Support Expiry Date: PRODUCT_SUPPORTEXPIRYDATE
Support Start Date: PRODUCT_SUPPORTSTARTDATE
Tax Class: PRODUCT_TAXCLASS
Total Stock: PRODUCT_TOTALSTOCK
Unallocated Stock: PRODUCT_UNALLOCATEDSTOCK
Unit Price: PRODUCT_UNITPRICE
Usage Unit: PRODUCT_USAGEUNIT
Vendor Name: PRODUCT_VENDORNAME
Vendor Part No: PRODUCT_VENDORPARTNO
Warehouse: PRODUCT_WAREHOUSE
Website: PRODUCT_WEBSITE
Weight: PRODUCT_WEIGHT

Product -> Quote Relationship fields

buyprice: REL_PRODUCT_BUYPRICE
buyprice2: REL_PRODUCT_BUYPRICE2
buyprice3: REL_PRODUCT_BUYPRICE3
buyprice4: REL_PRODUCT_BUYPRICE4
buyprice5: REL_PRODUCT_BUYPRICE5
category: REL_PRODUCT_CATEGORY
discount: REL_PRODUCT_DISCOUNT
listprice: REL_PRODUCT_LISTPRICE
listprice2: REL_PRODUCT_LISTPRICE2
listprice3: REL_PRODUCT_LISTPRICE3
listprice4: REL_PRODUCT_LISTPRICE4
listprice5: REL_PRODUCT_LISTPRICE5
markup: REL_PRODUCT_MARKUP
margin: REL_PRODUCT_MARGIN
productcode: REL_PRODUCT_PRODUCTCODE
prd_cf_1: REL_PRODUCT_PRD_CF_1
prd_cf_2: REL_PRODUCT_PRD_CF_2
prd_cf_3: REL_PRODUCT_PRD_CF_3
prd_cf_4: REL_PRODUCT_PRD_CF_4
prd_cf_5: REL_PRODUCT_PRD_CF_5
quoteid: REL_PRODUCT_QUOTEID
quoteproductid: REL_PRODUCT_QUOTEPRODUCTID
quantity: REL_PRODUCT_QUANTITY
productid: REL_PRODUCT_PRODUCTID
taxclass: REL_PRODUCT_TAXCLASS
taxpercent: REL_PRODUCT_TAXPERCENT
taxvalue: REL_PRODUCT_TAXVALUE
UOM: REL_PRODUCT_UOM

Product -> Invoice Relationship fields

buyprice: REL_PRODUCT_BUYPRICE
buyprice2: REL_PRODUCT_BUYPRICE2
buyprice3: REL_PRODUCT_BUYPRICE3
buyprice4: REL_PRODUCT_BUYPRICE4
buyprice5: REL_PRODUCT_BUYPRICE5
category: REL_PRODUCT_CATEGORY
description: REL_PRODUCT_DESCRIPTION
discount: REL_PRODUCT_DISCOUNT
invoiceproductid: REL_PRODUCT_INVOICEPRODUCTID
listprice: REL_PRODUCT_LISTPRICE
listprice2: REL_PRODUCT_LISTPRICE2
listprice3: REL_PRODUCT_LISTPRICE3
listprice4: REL_PRODUCT_LISTPRICE4
listprice5: REL_PRODUCT_LISTPRICE5
margin: REL_PRODUCT_MARGIN
markup: REL_PRODUCT_MARKUP
prd_cf_1: REL_PRODUCT_PRD_CF_1
prd_cf_2: REL_PRODUCT_PRD_CF_2
prd_cf_3: REL_PRODUCT_PRD_CF_3
prd_cf_4: REL_PRODUCT_PRD_CF_4
prd_cf_5: REL_PRODUCT_PRD_CF_5
productcode: REL_PRODUCT_PRODUCTCODE
productid: REL_PRODUCT_PRODUCTID
quantity: REL_PRODUCT_QUANTITY
remarks: REL_PRODUCT_REMARKS
taxclass: REL_PRODUCT_TAXCLASS
taxpercent: REL_PRODUCT_TAXPERCENT
taxvalue: REL_PRODUCT_TAXVALUE
UOM: REL_PRODUCT_UOM

Product -> Sales Order Relationship Fields

buyprice: REL_PRODUCT_BUYPRICE
buyprice2: REL_PRODUCT_BUYPRICE2
buyprice3: REL_PRODUCT_BUYPRICE3
buyprice4: REL_PRODUCT_BUYPRICE4
buyprice5: REL_PRODUCT_BUYPRICE5
category: REL_PRODUCT_CATEGORY
description: REL_PRODUCT_DESCRIPTION
discount: REL_PRODUCT_DISCOUNT
listprice: REL_PRODUCT_LISTPRICE
listprice2: REL_PRODUCT_LISTPRICE2
listprice3: REL_PRODUCT_LISTPRICE3
listprice4: REL_PRODUCT_LISTPRICE4
listprice5: REL_PRODUCT_LISTPRICE5
markup: REL_PRODUCT_MARKUP
margin: REL_PRODUCT_MARGIN
prd_cf_1: REL_PRODUCT_PRD_CF_1
prd_cf_2: REL_PRODUCT_PRD_CF_2
prd_cf_3: REL_PRODUCT_PRD_CF_3
prd_cf_4: REL_PRODUCT_PRD_CF_4
prd_cf_5: REL_PRODUCT_PRD_CF_5
productcode: REL_PRODUCT_PRODUCTCODE
productid: REL_PRODUCT_PRODUCTID
quantity: REL_PRODUCT_QUANTITY
salesorderid: REL_PRODUCT_SALESORDERID
soproductid: REL_PRODUCT_SOPRODUCTID
taxclass: REL_PRODUCT_TAXCLASS
taxpercent: REL_PRODUCT_TAXPERCENT
taxvalue: REL_PRODUCT_TAXVALUE
UOM: REL_PRODUCT_UOM

Product -> Purchase Order Relationship Fields

buyprice2: REL_PRODUCT_BUYPRICE2
buyprice3: REL_PRODUCT_BUYPRICE3
buyprice4: REL_PRODUCT_BUYPRICE4
buyprice5: REL_PRODUCT_BUYPRICE5
category: REL_PRODUCT_CATEGORY
description: REL_PRODUCT_DESCRIPTION
listprice: REL_PRODUCT_LISTPRICE
listprice2: REL_PRODUCT_LISTPRICE2
listprice3: REL_PRODUCT_LISTPRICE3
listprice4: REL_PRODUCT_LISTPRICE4
listprice5: REL_PRODUCT_LISTPRICE5
poproductid: REL_PRODUCT_POPRODUCTID
productcode: REL_PRODUCT_PRODUCTCODE
productid: REL_PRODUCT_PRODUCTID
purchaseorderid: REL_PRODUCT_PURCHASEORDERID
quantity: REL_PRODUCT_QUANTITY
taxclass: REL_PRODUCT_TAXCLASS
taxpercent: REL_PRODUCT_TAXPERCENT
taxvalue: REL_PRODUCT_TAXVALUE
UOM: REL_PRODUCT_UOM

Opportunity Fields

Account Name: POTENTIALS_ACCOUNTNAME
Active Time: POTENTIALS_ACTIVETIME
Amount: POTENTIALS_AMOUNT
Assigned To: POTENTIALS_ASSIGNEDTO
Campaign: POTENTIALS_CAMPAIGN
Cost Centre: POTENTIALS_COSTCENTRE
Created Time: POTENTIALS_CREATEDTIME
Default Currency: POTENTIALS_DEFAULTCURRENCY
Description: POTENTIALS_DESCRIPTION
Email: POTENTIALS_EMAIL
Expected Close Date: POTENTIALS_EXPECTEDCLOSEDATE
Expected Revenue: POTENTIALS_EXPECTEDREVENUE
Fiscal Quarter: POTENTIALS_FISCALQUARTER
Fiscal Year: POTENTIALS_FISCALYEAR
Forecast Category: POTENTIALS_FORECASTCATEGORY
Last Action: POTENTIALS_LASTACTION
Last Action Date: POTENTIALS_LASTACTIONDATE
Lead Source: POTENTIALS_LEADSOURCE
Modified Time: POTENTIALS_MODIFIEDTIME
Next Step: POTENTIALS_NEXTSTEP
Potential Name: POTENTIALS_POTENTIALNAME
Probability: POTENTIALS_PROBABILITY
Project Name: POTENTIALS_PROJECTNAME
Sales Stage: POTENTIALS_SALESSTAGE
Start Date: POTENTIALS_STARTDATE
Total Linked Amount: POTENTIALS_TOTALLINKEDAMOUNT
Total Opportunity Quantity: POTENTIALS_TOTALOPPORTUNITYQUANTITY
Type: POTENTIALS_TYPE
Weighted Amount: POTENTIALS_WEIGHTEDAMOUNT

Assigned User

USER_FIRSTNAME,
USER_LASTNAME,
USER_USERNAME,
USER_YAHOOID,
USER_TITLE,
USER_OFFICEPHONE,
USER_DEPARTMENT
USER_MOBILE,
USER_OTHERPHONE,
USER_FAX,
USER_EMAIL,
USER_HOMEPHONE,
USER_OTHEREMAIL,
USER_PRIMARYADDRESS
USER_CITY,
USER_STATE,
USER_POSTALCODE,
USER_COUNTRY

Current User

First Name =CURRENTUSER_FIRST_NAME
Last Name =CURRENTUSER_LAST_NAME
Username =CURRENTUSER_USER_NAME
Title=CURRENTUSER_TITLE
Department=CURRENTUSER_DEPARTMENT
Office Phone=CURRENTUSER_PHONE_WORK
Home Phone= CURRENTUSER_PHONE_HOME
Other Phone= CURRENTUSER_PHONE_OTHER
Fax= CURRENTUSER_FAX
Email=CURRENTUSER_EMAIL1
Street=CURRENTUSER_ADDRESS_STREET
City=CURRENTUSER_ADDRESS_CITY
State=CURRENTUSER_ADDRESS_STATE
Country=CURRENTUSER_ADDRESS_COUNTRY
Postcode=CURRENTUSER_ADDRESS_POSTALCODE

My Company Fields

Organization Name: MYCY_ORGANIZATIONAME
Street Address: MYCY_ADDRESS
City: MYCY_CITY
State: MYCY_STATE
Country: MYCY_COUNTRY
Postcode: MYCY_CODE
Phone: MYCY_PHONE
Fax: MYCY_FAX
Website: MYCY_WEBSITE
Logo Name: MYCY_LOGONAME
Logo: MYCY_LOGO
VAT: MYCY_VAT
Reg: MYCY_REG
Email: MYCY_EMAIL
Address2: MYCY_ADDRESS2

Custom Text Tags

When launching the template, you can enter text into up three text boxes which are then also merged into the template. You can use the following 3 custom tags in your template. The tag names are only used as a guideline to help you logically structure your templates, but can actually be inserted anywhere in the template (so, for example CUSTOM_HEADER does not necessarily be in the template header)

CUSTOM_HEADER
CUSTOM_BODY
CUSTOM_FOOTER

Custom Fields

The RTF Merge has been tested and should work fine on custom fields too. Please use your field label as reference ie: if I create a custom field on the Leads module and call it MoonAddress I should be able to merge it using the LEAD_MOONADDRESS label

The merge will not work on custom fields with a  label containing white spaces (ie Moon Address)

 

• Rate This Article

  
  
• Feedback and Comments

  Name:

  
  

Files:

• OpenCRM RTF document merging v3.pdf 

You may also be interested in:

• I want choose some records from a list and export these records only, is there a simple way of doing this?  Updated : 14-05-2012 10:01
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies
• How can I change the fields visible on the Basic and Advanced Search screens?  Updated : 03-04-2012 15:11
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk
• I need to bulk update a set of records in OpenCRM, how do I do this?  Updated : 17-02-2012 12:47
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Documents OpenCRM::Contracts OpenCRM::Events OpenCRM::Campaigns
• How do I code emails in order to track click throughs, enquiries and to automatically manage remove me requests?  Updated : 17-02-2012 11:53
  OpenCRM::Leads OpenCRM::Emails OpenCRM::Contacts OpenCRM::Companies OpenCRM::Settings::Templates Hosted::Portal
• 

  What are Action Plans in OpenCRM and how can I use them to get the most out of my OpenCRM solution? And what are Conditional Action Plans?

    Updated : 14-05-2012 16:34
  OpenCRM::Leads OpenCRM::Emails OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk OpenCRM::Documents OpenCRM::Events OpenCRM::Campaigns OpenCRM::Settings OpenCRM::Settings::Additional
• Can round-robin be used to assign records when importing data?  Updated : 14-11-2011 11:00
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies OpenCRM::Helpdesk OpenCRM::Settings::Users OpenCRM::Settings::Additional
• How can I get Leads into OpenCRM from a contact form on my website? How do the OpenCRM contact forms work and how do I customise them? Applies to Version 3.02+  Updated : 31-10-2011 11:20
  OpenCRM::Leads OpenCRM::Data Import-Export
• How can I get Leads into OpenCRM from a contact form on my website? How do the OpenCRM contact forms work and how do I customise them? Applies to All versions  Updated : 31-10-2011 11:19
  OpenCRM::Leads OpenCRM::Data Import-Export
• How do I set up OpenCRM to assign records by Round Robin?  Updated : 22-09-2011 15:48
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies OpenCRM::Helpdesk OpenCRM::Personnel OpenCRM::Settings
• How do I create a Lead in OpenCRM?  Updated : 24-03-2011 09:54
  OpenCRM::Leads

More..