LogoLogo
More help and supportPhocas website
  • Home
  • Getting started
    • Navigation
    • Homepage
    • Data access
    • User licenses, profiles and permissions
    • Account settings
    • Databases
    • Periods
      • Offset dates
      • Default period for a database
    • Sharing and folders
      • Share a dashboard, favorite, or alert
    • Subscriptions
  • Analytics
    • Take a tour of Analytics
    • Work with the grid
    • View a summary of the data
    • Customize your view (Analytics)
      • Change the mode
        • Period mode
        • Period Variance mode
        • Period Stream mode
        • Moving mode
        • Stream mode
        • Total mode
        • Transaction mode
        • Matrix mode
        • Matrix Variance mode
        • Matrix Share mode
        • Variance mode
        • Search mode
        • Market mode
        • Custom mode
      • Change the properties (Analytics)
      • Change the measures (Analytics)
      • Change the stream
      • Use the activity filter
      • Change the data format
      • Change the period (Analytics)
    • Drill down into your data (view transactions)
    • Filter data (use dimensions)
    • Select data (Analytics)
    • Focus on data (Analytics)
    • Copy or export data
    • Search for data
      • Perform a basic search
      • Perform an advanced search
      • Search for similar or comparative data (right-click filter)
    • Add levels to the grid (grid nesting)
    • Compare data with Matrix mode
    • Get more options for viewing data
    • Visualize your data in a chart
      • Bar and Column charts
      • Combo chart
      • Pareto chart
      • Waterfall chart
      • Line chart
      • Area and % Area charts
      • Pie and Donut charts
      • Bubble chart
      • Radar chart
      • Gauge chart
      • Bullet chart
      • Summary and Ring Summary charts
      • Map charts
      • Configure the chart options
      • Select and focus on a chart segment
      • Export a chart as an image
      • Use the chart legend
    • Save favorites and add to dashboards (Analytics)
    • Reset data
    • Phocas AI
    • Flex Modes
      • Switch modes
      • Filter data (Flex Modes)
      • Apply conditional formatting
      • Add levels to the grid (Flex Modes)
      • Manage columns (Flex Modes)
      • Save and share a favorite (Flex Modes)
      • View your data in a chart (Flex Modes)
  • Financial Statements
    • Take a tour of Financial Statements
    • Overview of access to financial statements
    • Customize your view (Financial Statements)
      • Change the properties (Financial Statements)
      • Change the measures (Financial Statements)
      • Change the period (Financial Statements)
      • Change the current data
      • Change the budget data
      • Change the columns
      • Change the style
      • Change the rows (activity filter)
    • Filter the financial information
    • Select and focus on data (Financial Statements)
    • Copy or export financial information
    • Add a level in a financial statement
    • View financial information in a matrix (change column groups)
    • Add and view comments (Financial Statements)
    • View transactions (Financial Statements)
    • View financial information in a chart
      • Create a Pie and Donut chart (Financial Statements)
      • Create a Value card
      • Export a financial chart widget as an image
    • Save and share favorites (Financial Statements)
    • Add financial analysis to a dashboard
    • Manage financial statements
      • Overview of financial statements and dimensions
      • Create a financial statement
      • Delete a financial statement
      • Customize a financial statement
        • Rename a financial statement
        • Reorder a financial statement
        • Customize account groups
        • Customize calculations
          • Functions for Profit & Loss calculations
          • Formulas for financial ratios
        • Customize headings and spacers
        • Set the revenue row in a Profit & Loss statement
        • Customize columns
        • Customize a Cash Flow statement
          • Common account mapping for Cash Flow statements
        • Rebuild the database
      • Set the financial year end date
      • Map the Retained Earnings account(s)
      • Restrict access to accounts
      • Manage budget streams (Financial Statements)
        • Create a budget (Financial Statements)
      • Use statistical streams
      • Use multiple currencies
      • Manage dimension groups
      • Map categories from your Chart of Accounts
  • Budgets & Forecasts
    • Overview of key terms and concepts
      • Budgets versus forecasts
      • Users and data access
      • Relationship with the Financial Statements module
      • 3-statement budgeting
      • Filtering methods
      • Demand planning
      • Loan repayments
    • Take a tour of Budgets & Forecasts
      • Explore the budget workbook
      • Explore the forecast workbook
      • Explore the Balance Sheet and Cash Flow budgets and forecasts
    • Customize your view (Budgets & Forecasts)
      • Filter a worksheet (search for items)
      • Group period columns
      • Use layouts
    • Use session filters
    • Edit values in a worksheet
      • Open workbook notes
      • Use keyboard shortcuts
      • Copy and paste values
      • Use comparison rows
      • Use sum and working lines
      • Use formulas
      • Spread totals
      • Revert to the baseline values
      • Edit the Balance Sheet budget
      • View and use headcount data
    • Refresh a workbook
    • Use workflows
      • Contribute to the workflow
      • View the workflow history
      • View workflow comments
    • View budget information in a chart
    • Open baseline, comparative, or opening balance data
    • Review the budget or forecast
      • Add and view cell comments
      • View and restore the cell history
      • View the audit log
      • Compare actuals, budgets and forecasts
    • Export a workbook or worksheet tab
    • Manage budgets and forecasts
      • Create a budget workbook
        • Filtered budget or forecast
        • Multi-currency budget
        • Unclassified data
        • Period types in budgets
        • Additional measures for driver-based budgeting
      • Create a forecast workbook
      • Clone a workbook
      • Import a budget or forecast
      • Edit the workbook setup
      • Roll a budget forward
      • Add more detail to a budget or forecast
      • Add worksheet tabs (drivers)
        • Balance Sheet and Cash Flow tabs
        • Manual Entry tab
        • Database tab
        • Headcount tab
          • Headcount tab FAQs
        • Reference tab
        • Lookup tab
        • Allocations tab
        • Scratch Pad tab
      • Manage worksheet tabs
      • Add notes to a workbook
      • Customize the format of measures
      • Manage the workflow
      • Manage user access and notifications
      • Publish a budget, forecast or other worksheet tab
      • Fix the baseline in a budget
      • Delete or restore a workbook
      • Delete a stream (Budgets & Forecasts)
      • Troubleshoot performance issues
  • Rebates
    • Overview of rebates
    • Get started with Rebates
    • Projects
    • Rules
      • Parent-child rebate rules
      • Rebates calculation methods
      • Yearly rebates
      • Quarterly rebates
      • Monthly rebates
      • Whole rule period rebates
      • Retrospective rebates
      • Pro rata rebates
    • Calculations
      • Run a calculation
      • Schedule calculations
      • View calculation results and transactions
      • Post calculation results
    • Seasonal calendars
    • Rebates analysis
    • Rebates near miss analysis
  • CRM
    • Overview of CRM
    • Agenda
    • Contacts
    • Accounts
    • Leads
    • Activities
      • Microsoft 365 Outlook calendar integration
    • Campaigns
    • CRM analysis
    • CRM administration
  • Favorites
    • Save a favorite
    • Manage favorites
    • Set a favorite as your default view
    • Use alerts
  • Dashboards
    • Use dashboards
    • Create a dashboard
    • Set a dashboard as your homepage
    • Manage dashboards
  • Administration
    • Overview of access to data (Administration)
    • Users
      • Add, update or delete a user account
        • User maintenance form
        • User permissions
      • Create a user template
      • Manage a user's database access and restrictions
      • Manage user passwords
      • Monitor user activity
      • Lock user accounts
      • Impersonate a user
    • Profiles
    • Folders (Administration)
    • Favorites (Administration)
    • Dashboards (Administration)
    • Subscriptions (Administration)
    • Periods (Administration)
      • Period types
      • Working days
    • Databases (Administration)
    • Sync Sources
    • Connectors
    • Configuration
      • Set up SSO
      • Set up SSO with Microsoft Entra ID
    • Logs
    • Designer
      • Modify a database
      • Get your data into Phocas
      • Design a database
        • Create a database
        • Add (connect) data to a database
        • Map data to the database
        • Save your database design
      • Design a financial database
      • Build a database
      • View and revert to older design versions
      • Add a budget file to a financial database
      • Add a budget file to a non-financial database (easy budget upload)
    • Sync
      • Automatically join or split items during Sync (split view)
      • Schedule the sync process
      • Migrate Sync
      • Test the sync process
    • Reserved words and characters
    • End of year maintenance tips
  • OTHER INFORMATION
    • File upload
    • Encrypt (share secrets)
    • Glossary
    • Release notes
      • Analytics release notes
      • Financial Statements release notes
      • Budgets and Forecasts release notes
      • Rebates release notes
      • Administration release notes
    • System requirements
    • Technical limitations
    • Security information
    • Scheduled upgrade and maintenance periods
    • More help and support
Powered by GitBook

© Phocas Software

On this page
  • Edit the options in CRM dropdown lists (picklists)
  • Customize your CRM module
  • Add the custom item in CRM
  • Map the custom item to the CRM database
  • View the custom item in Analytics
  • Map your CRM account data
  • Add and map the data
  • Update the data
  • Overwrite existing values
  • Manage deleted CRM items

Was this helpful?

  1. CRM

CRM administration

Customize and manage the CRM module in your Phocas site.

PreviousCRM analysisNextFavorites

Last updated 12 days ago

Was this helpful?

User permission: Administration > CRM

The following CRM administration tasks are accessible from the Phocas navigation menu:

  • CRM picklists: Edit options in CRM dropdown lists

  • CRM deleted: Manage deleted CRM items

  • Customizations: Customize your CRM

  • CRM mappings: Map your CRM account data.

Edit the options in CRM dropdown lists (picklists)

You can change the options (values) in some of the dropdown lists in CRM to suit your business needs. For example, you might want to add a new Status called Allocated or remove a status that is not applicable.

Click the Phocas menu button > CRM > CRM picklists to open the Picklists page, where you can view a list of the dropdown lists used in CRM, organized into tabs.

Picklist (tab)
Where it appears in CRM
Typical options

Call Type

Phone Log

Follow Up

Initial Call

Support Call

Sales Call

Quotation

Contact Method

Account Record

Contact Record

Lead Record

Email

Face-to-face

Fax

Instant Messenger

Letter

Phone

Job Title

Contact Record

Lead Record

Director

Manager

Salesperson

Accounts

Sales Manager

Payment Status

Account Record

Current

Overdue

Status

Meeting

Task

Cancelled

Completed

Deferred

In Progress

Not Started

Overdue

Waiting on Someone

On the Picklists page, click the required tab (Call Type, Contact Method, Job Title, Payment Status and Status) then proceed as required:

  • Add an option: Click Add, enter a name for the option and click Save.

  • Delete an option: Select the option row and click Delete > Yes.

  • Set the default option: Select the option row and click Set Default.

Customize your CRM module

You can customize your CRM module for your own business by adding new tabs, tables, and fields to the entity screens. For example, you might want to add social media fields to a contact or a position field to an account. These custom additions allow you to record the exact details you need to manage those entities more effectively. If you map the custom fields to your CRM Analysis database, you can analyze the data entered against those fields in your Analytics module.

While this customization capability is straightforward and flexible, it’s suitable for adding basic additional fields only. It's not designed as a database or inventory management tool and there’s a limit to the number of fields you can add.

Add the custom item in CRM

You can add the following custom items to the CRM Account, Activity, Campaign, Contact, and Lead screens:

  1. Tab of fields: An additional tab in which you can add custom fields.

  2. Table of rows: An additional tab containing a table (grid) in which you can add a list of items.

This tab is only available after the CRM entity (such as an account) has been created and saved. It does not appear during the creation process. This is because the tab is designed to store records related to the CRM entity, which requires the entity to exist first. For example, when adding a new account, this tab will not be visible until the account is saved.

  • Fields on the main tab: Additional fields on the entity's main tab.

  1. Click the Phocas menu button > CRM > CRM Customizations.

  2. Click New.

  3. Enter a name for the custom item, and a description if required.

  4. Select the entity from the dropdown list: Account, Activity, Campaign, Contact, or Lead.

  5. Select the customization type: Tab of fields, Table of rows or Fields on main tab.

  6. Select whether the customization is editable. If it is editable, the Entity and Type cannot be changed.

  7. Click Save.

  8. Click the Fields tab and add the fields:

    1. Click New.

    2. Enter a name for the field, and a group if required.

    3. Select the field type: Date, Date Time, Integer, List (dropdown list), Number, Text, or Text Area. After you save the Field form, you cannot change the field type. If you select the List option, enter the options into the box that displays, separated by a pipe (|) character without space, illustrated in the image below.

    4. Either click Save and New (if you want to add another field) or Save and Close as required.

  9. Click Save and Close. The new custom item displays in the list on the Customization screen and when you open the corresponding entity screen. Your CRM users can now add data against the new item.

  10. (Optional) Proceed to map the custom fields to your CRM Analysis database.

Examples

Click the links to watch the videos. Note the UI is out of date but the context is the same. These examples are continued in the next section.

Map the custom item to the CRM database

To enable the analysis of data entered against custom CRM items, you need to map those items to the CRM Analysis database in Designer.

  1. Open the CRM Analysis database in Designer.

  2. Open the applicable entity (the data displays in the stream section).

  3. Open the data sources panel > locate the CRM custom file in the Auto Generated CRM folder > drag it into the Drag here box in the stream section.

  4. Map the ID in the file (the activity data that you capture in the CRM) to the ID in the database.

  5. Map the new custom item to the required item in the Dimension or Property section and edit the name of the mapped item, if required.

  6. Save and build the database.

Examples

Click the links to watch the videos. Note the UI is out of date but the context is the same. These examples continue from those in the section above.

View the custom item in Analytics

After you build your CRM Analysis database with the custom CRM items, so long as data has been entered against those items in CRM, you can analyze that data in Analytics. Depending on how you mapped the custom items, they might display as a dimension or property.

Examples

Click the links to watch the videos. Note the UI is out of date but the context is the same. These examples continue from those in the section above.

Map your CRM account data

User permissions: Administration > CRM and Sync

Typically, the Phocas Implementations team adds, syncs or connects to your data on your behalf, and designs your CRM database. If you are familiar with using Designer, you can use the CRM mapping tool to keep your CRM data up-to-date. The tool pushes customer data into Phocas CRM as accounts, without the need for scripts or extensive preparatory work.

Add and map the data

  1. Click the Phocas menu button > Administration > CRM Mappings. The CRM mapping tool opens on the Source Mapping tab. This is where you add (connect to) data items from the data sources panel, then map (match) the columns of raw data to their respective item in the account.

  2. On the Source Mapping tab, open the data sources panel > locate the data item (such as a Customer or Ship To sync or a flat file) > drag it into the Drag here box.

  3. Map the data items to the account items. Start with the mandatory items of Name and Number, then map the other items as required.

    • The Number is a unique identifier, like the Code in Analytics. It might be called Linkfield.

    • The Payment Status, Is Active? and Contact Method items are mapped as a best match. If the source data uses different names for these items, you might need to check them.

  4. Add more data items, if required, and map the data (repeat the steps above). This step is necessary if your data comes from more than one source. You can add as many data sources as required. Any duplicate items within a single data source will be skipped and a record will display in the logs. Duplicates in multiple sources will be handled left to right.

  5. Click Save. You might need to close the data sources panel to view this button.

    1. Click the Owner Mapping tab.

    2. Click in the empty box next to each user and select an owner (user) from the list that displays, as applicable. In the example below, there are two lists of owners to map. You can map multiple accounts to users.

    3. Click Save.

  6. Proceed to update the data.

Update the data

The Update tab only becomes available after you map the data and click Save on the Source Mapping tab. The update action works like a database build in Phocas, in that it brings in updated data. An update cannot be undone.

  1. Click the Update tab.

  2. Determine whether you want to overwrite existing values*. If you do, you need to take an additional step, see section below.

  3. Select one of these options:

    • Immediately queue and run the update and display the logs page: Click Update and click Yes to confirm. A progress bar displays during the update process, then when complete, logs relating to the update display.

    • Schedule an update to occur at another time: Click Schedule, select the frequency and click Save.

    • Schedule an update after sync of selected sources: Select the After sync of selected sources option, then select the required sources.

Overwrite existing values

By default, the ability to overwrite existing data is turned off, to avoid accidentally replacing data you want to keep. This also ensures that users who manually input details into CRM don't have their work overwritten.

You might want to turn this on, for example, if you need to do a bulk update of information, but you should use caution.

To turn this option on and overwrite existing values:

  1. Click the Settings button on the top right corner.

  2. Select the Overwrite existing values checkbox and click Save.

  3. Turn this option off again, after the update is complete, to avoid accidentally overwriting anything in the future.

Manage deleted CRM items

Click the Phocas menu button > CRM > CRM Deleted to open the Deleted page, where you can view a list of entities deleted from CRM, along with the entity type, who deleted it and the deletion date.

To restore one or more items to the correct location in CRM, select the required row(s) and click Restore. Restoring an Activity or Contact which is a child of an Account will result in the Account also being restored.

To permanently delete one or more items, select the required row(s) and click Delete. Deleting an Account will result in any child Activity or Contact also being deleted. Deleting a Contact or Lead will result in any child activity also being deleted.

To permanently delete all deleted items, click Purge.

Another CRM-related administration task is the management of , which you do on each user's maintenance form.

Example 1, part 1:

Example 2, part 1:

Generally, the Phocas Implementations team does this type of work for you but if you are familiar with using Designer, you can do it yourself. The steps are summarized below. See the following Designer pages for more information: and .

Proceed to .

Example 1, part 2:

Example 2, part 2:

See the following Analytics pages for more information: and .

Example 1, part 3:

Example 2, part 3:

Watch this Phocas Academy video:

The CRM mapping tool works in a similar way to how you map data to a database in the Designer, therefore, the information on this page is summarized. See the following pages for more information.

(Optional - available only if you mapped data to the Owner element) Map your CRM users with account owners (such as sales reps). It is important to note that if you later want to delete the CRM user’s Phocas account, you will lose access to that user’s CRM accounts. To avoid this, you should reassign the user’s CRM accounts before deleting the user’s Phocas account. See for more information.

Add social media fields to the Contact main tab, and add a tab to the Accounts screen with custom fields, including a dropdown list
Add a Position field to the Account main tab
Add (connect) data to a database
Map data to the database
view the custom item in Analytics
Map the social media fields as properties in the CRM Analysis database
Map the position field as a dimension in the CRM Analysis database
Filter data (use dimensions)
Change the properties
View the CRM social media properties data in the Analytics grid
View the CRM position dimension data in the Analytics grid
CRM account mapping
Designer
Delete a user
CRM restrictions