COM Interface Definition

---

The COM Interface lists the interface points available in CRM, SCM, and HR. You select an interface code to view the list of defined bookmarks.

You can navigate to the database to select additional bookmarks you require. You can also navigate and select user-defined trees and fields.

SCM

The COM interface enables you to define the list of fields that you want to export through the Sales Analysis Export feature. These COM Interfaces are available in SCM:

SCM Analytics Export Customer

This COM interface is used in SCM > Analytics > Sales Analysis Export, if the Masterfile Information option is selected. Gives access to the Accounts Receivable Customer Masterfile.

SCM Analytics Export Supplier

This COM interface is used in SCM > Analytics > Sales Analysis Export, if the Masterfile Information option is selected. Gives access to the Accounts Payable Supplier Masterfile.

SCM Analytics Export Inventory

This COM interface is used in SCM > Analytics > Sales Analysis Export, if the Masterfile Information option is selected. Gives access to the Inventory Item Masterfile.

SCM Analytics Export Sales Analysis

This COM interface is used in SCM > Analytics > Sales Analysis Export, if the Sales Analysis option is selected. This COM Interface enables you to define the Sales Analysis Header (AR Invoice header level) fields that you want to include when performing a Sales Analysis export through SCM > Analytics or the Workflow > Interface Manager.

SCM Analytics Export Sales Transaction Lines

This COM interface is used in SCM > Analytics > Sales Analysis Export, if the Sales Transactions option is selected. The Sales Transaction Lines COM Interface gives access to the Sales Analysis Line item fields (AR Invoice line items) by default. A number of other sub-classes (fields related to the AR Invoice) can be accessed, for example the Sales Order linked to the AR Invoice.

Bookmark Name is used as column header when exporting the fields through the Sales Analysis Export.

CRM

The Bookmarks are used in CRM when using Word, Excel or Email Templates. For example:

• Write Letter - Personalise an individual letter to a contact, when in the Contact forms. This uses a Word template.dot document with bookmarks matching the ones you selected in the COM Interface. For example you could personalise a letter to the customer or log a support call and send a confirmation letter.
• Mail Merge - Mail merge a list of organisations/contacts details into a standard marketing offer letter. This uses a Word template .dot document with mail merge fields matching the ones you selected in the COM Interface. For example you could send a marketing campaign letter to a list of customers or prospects.
• email - Send an individual email to a contact. This uses a Greentree email template which can include fields from the COM Interface.
• Bulk email - Similar to mail merge but will send out emails in bulk. This uses a Greentree email template which can include fields from the COM Interface.

The COM Interface Set-up form lists all the interfaces available in CRM:

Mail Merge

Accessed through the Mail Merge button from these forms: Relationships > Lists, Relationships > View > Contacts, Sales & Marketing > Campaigns, Bookings Management > Invitations, and Bookings Management > View > Individual Booking.

Mail Merge Booking List

Accessed through the Mail Merge button on the Bookings Management > Bookings form. This COM interface gives access to the Contact fields, and the Booking Activity.

Print Booking Activity Table using Word/Excel

Accessed through the Hotprint feature on the Bookings Management > Bookings form. This COM interface gives access to the booking activities. Hotprint is also available from Sales & Marketing > Campaigns, Bookings Management > Invitations.

In order for the interface to function correctly, the Table Bookmark needs to be defined as CRMBookingActivitytable.

Print Booking Bookings List Table using Word/Excel

Accessed through the Hotprint feature on the Bookings Management > Bookings form. This COM interface gives access to the individual bookings.

In order for the interface to function correctly, the Table Bookmark must be defined as CRMBookingBookingtable.

Print Booking ( /Lists/Campaigns/Invitations ) using Word/Excel

Accessed through the Hotprint feature on the Bookings Management > Bookings, Relationships > Lists, Sales & Marketing > Campaigns, Bookings Management > Invitations. This COM interface gives access to the generic fields, which are available to all these items, such as criteria, trees and user-defined fields.

Print Communication using Word

Accessed through the Write Letter feature on the various Communication forms. This COM interface gives access to the various fields captured on a communication

Print Contract Table using Word

Accessed through the Hotprint feature on the Contracts > Contract Maintenance form. This COM interface gives access to the Service Level fields on the contract.

 The Table Bookmark must be defined as CRMSVContractServiceLevel.

Print Contract using Word

Accessed through the Hotprint feature on the Contracts > Contract Maintenance form. This COM interface gives access to the general Contract fields, such as the organisation that the contract is with.

Print Debt Collection Letter

Accessed by clicking the Create Letter/Email button on the Debt Collection > Generate Letters or Calls forms. This COM interface gives access to the AR Customer and CRM Organisation detail for the overdue AR Invoices.

Print Debt Collection Letter Table using Word

Accessed through the Create Letter/Email button on the Debt Collection: Generate Letters or Calls form. This COM Interface gives access to the overdue AR Invoice line items using the various sub-classes listed on the COM interface. You must select the specific subclass for the line item you want to include in the COM Interface, then select the fields you want to expose.

Print Knowledge Base Page using Word

Accessed through the Letter feature on the Knowledge Base > Search Knowledge Base form, Results tab. This COM interface gives access to the Organisation and Contact fields for the selected Org/Contact to whom the Page is sent.

Print Quote Job Activity Table using Word/Excel

Accessed through the Hotprint feature on the Sales & Marketing > Quote Maintenance form, Service & Support > Quote Maintenance. The Activity table is only available for Job Quotes. This COM interface gives access to the Activities entered as estimates for the Job.

The selection of a Job quote is also available on Counter Sales and Fund Raising (Pledges and Donations). For the interface to function correctly, the Table Bookmark must be defined as CRMQuoteJCActivityTable.

Print Quote Job Employee Table using Word/Excel

Accessed through the Hotprint feature on the Sales & Marketing > Quote Maintenance form, Service & Support > Quote Maintenance. The Employee table is only available for Job Quotes. This COM interface gives access to the employee detail entered as estimates for the Job.

The selection of a Job quote is also available on Counter Sales and Fund Raising (Pledges and Donations). In order for the interface to function correctly, the Table Bookmark must be defined as CRMQuoteJCEmployeeTable.

Print Quote Job Inventory Table using Word/Excel

Accessed through the Hotprint feature on the Sales & Marketing > Quote Maintenance form, Service & Support > Quote Maintenance. The Inventory table is only available for Job Quotes. This COM interface gives access to the Inventory items entered as estimates for the Job.

The selection of a Job quote is also available on Counter Sales and Fund Raising (Pledges and Donations). In order for the interface to function correctly, the Table Bookmark must be defined as CRMQuoteJCInventoryTable.

Print Quote Job Sales Table using Word/Excel

Accessed through the Hotprint feature on the Sales & Marketing > Quote Maintenance form, Service & Support > Quote Maintenance. The Sales table is only available for Job Quotes. This COM interface gives access to the items on the Sales tab.

The selection of a Job quote is also available on Counter Sales and Fund Raising (Pledges and Donations). In order for the interface to function correctly, the Table Bookmark needs to be defined as CRMQuoteJCARSalesTable.

Print Quote (Counter Sale/Pledge/Donation) Table using Word/Excel

Accessed through the Hotprint feature on Sales & Marketing > Quote Maintenance, Service & Support > Quote Maintenance, Bookings Management > Quote Maintenance, Counter Sales > Counter Sales, Fund Raising > Pledges, Fund Raising > Donations. This COM interface gives access to the Line items entered on the Quote.

In order for the interface to function correctly, the Table Bookmark needs to be defined as CRMQuoteTable.

Print Quote using Word/Excel

Accessed through the Hotprint feature on the Sales & Marketing > Quote Maintenance, Service & Support > Quote Maintenance, Counter Sales > Counter Sales, Fund Raising > Pledges, Fund Raising > Donations. This COM interface gives access to the general Quote fields, such as the Organisation that the Quote is for.

Print Service Call using Word

Accessed through the Hotprint feature on the Service & Support > Calls form. This COM interface gives access to the general Call fields, such as the Organisation that the Call is for.

Print Service Request using Word

Accessed through the Hotprint feature on the Service & Support > Service Request form. This COM interface gives access to the general Service Request fields, such as the Organisation that the Service Request is for. This interface includes access to the Secondary Assets, Items and Products.

Print Call/Service Request Asset Table using Word

Accessed through the Hotprint feature on the Service & Support > Calls and Service & Support > Service Requests forms. This COM interface gives access to the Secondary Assets on the Call or Service Request (Additional tab). Note: In order for the interface to function correctly, the Table Bookmark must be defined as CRMSVRequestAssetTable.

Print Action Plans Table using Word

This COM Interface gives access to the Action Plan lines for a Service Request/Call, as accessed by clicking the Service Request/Call > Action Plans button, located in the Action Plan Maintenance table.

The Table Bookmark must be defined as CRMSVRequestActionPlansTable. for the interface to function correctly. You can also access the Call/Service Request fields.

Send Email from Communication

Accessed through the Send Email button available on the various Communication forms. This COM interface gives access to the general Communication fields, and the related record.

Send Email from Knowledge Base Page

Accessed through the Email button available on the Information tab of the Knowledge Base page. This email is hardcoded, no individual COM interface fields can be defined.

Send Email from List

Accessed through the Bulk Email button available on the Relationships > Lists, Sales & Marketing > Campaigns, Bookings Management > Invitations, Bookings Management > Bookings forms. For Bookings, You can generate bulk email on either the list of invitees or the list of booked individuals. This is achieved through setting focus on the Invitees or Bookings tab. This COM Interface gives access to the general campaign fields.

Send Email to Contact

Accessed through the Bulk Email button available on the Relationships > Lists, Relationships > View > Contacts, Sales & Marketing > Campaigns, Bookings Management > Invitations, Bookings Management > Bookings, Bookings Management > View > Individual Bookings forms.

For Bookings, you can perform the bulk email on either the list of Invitees or the list of booked Individuals. This is achieved through setting focus on the Invitees tab or the Bookings tab. This COM Interface gives access to the CRM contact fields, allowing you to create an email template containing Contact fields, to send a personalised email from the List/Campaign/Invitation/Booking.

HR

The HR list of COM Interfaces are not included in this document.

The BPM module can merge data with Word/Excel from any data within Greentree Desktop.

Code

This field lists all the available Interfaces between HR /SCM/CRM and Word/Excel/Email. Select the nterface for which you want to view/maintain/create Bookmark Names.

Bookmark Name

Enter a Bookmark Name for the selected Field. The Bookmark Name is used in Word/Excel/Email Templates.

Subclass

This field lists the Class that the Field is retrieved from. Subclass enables you to access the detail from another Class, for example: Inventory detail for an Inventory item selected on the Quote.

Field

Select the field for which you want to create a Bookmark Name. Navigate to the required fields. Click the Navigate button to display a list of available properties for the selected code.

Type

The field type displays, for example: String, Boolean.

Type Format

This field displays if the selected field is a date or a timestamp. Enter the format you require for the selected bookmark. A sample of the entered format displays on the form.

For example, the timestamp format hh:mm:ss MMM dddd yyy applies this timestamp to bookmarks: 12:30:03 July Monday 2018

Decimal Places

This field displays if the selected field is of type decimal. Enter the number of decimal places you require for the selected Bookmark.

Bookmark Table

This table lists all the defined bookmarks for the selected Code. The bookmarks represent the fields that are available for use on templates. The bookmark's name is used in Word, Excel, and email templates.

New Bookmarks are defined using the Data Entry fields and the Save Line button. Each new bookmark is listed in a new line in this table.

• How to Create and Maintain Templates

---