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
  • User tab
  • Profile tab
  • Profile type
  • User permissions
  • Databases tab
  • CRM Restrictions
  • Add restrictions
  • Remove all restrictions
  • Favorites tab
  • Dashboards tab
  • Usage tab
  • Query Log tabs
  • Other tabs

Was this helpful?

  1. Administration
  2. Users
  3. Add, update or delete a user account

User maintenance form

PreviousAdd, update or delete a user accountNextUser permissions

Last updated 12 days ago

Was this helpful?

You access a user’s account, known as a maintenance form, when you . The form contains several details fields, permissions and other settings, organized into tabs. Depending on your profile, you might not see all the tabs.

If you make any changes to any tabs on this screen (user maintenance form), ensure you click Save to save and apply those changes. If you click Close or move to a different tab, your changes are not saved.


User tab

The User tab displays when you are adding a new user account (other tabs display afterward) and it is the default tab that displays when you open an existing user account. This tab has the following settings:

  • Username (mandatory): This is the name the user will use to sign in to Phocas. This usually matches the user's network sign-in name.

  • LDAP Authenticated?: This setting is only available on LDAP configured implementations. It indicates which authentication method is been used. If the checkbox is selected, the user is authenticated against the LDAP server. If the checkbox is not selected, the user is authenticated against Phocas. If the user is being added from a source other than Active Directory, an additional Password setting is available. See .

  • SAML Authenticated?: This setting is only available if the feature is turned on for your Phocas site, in which case the checkbox is selected by default.

  • Windows or SQL user name: This setting is only required for older desktop versions of Phocas.

  • Email*: This is the user's email address. Users need a valid email address to receive subscriptions. New users on the current version of Phocas will be asked to enter an email address the first time they sign in, unless one has already been entered here.

  • Display Name (mandatory)*: This is the name that displays on the User menu.

  • Phone, Cell and Home*: These are the user’s telephone numbers.

  • Language*: This is the user’s language. Selecting a different language from the list will translate the text when the user next signs in; however, it does not translate the names of measures, properties or dimensions, as these are defined by the data in each . If this setting is left blank, the default system language will be used.

  • Timezone*: This is the user’s timezone.

  • Home: This is the user’s default homepage. You can either leave this blank to present the user with a homepage listing the databases, dashboards and favorites to which they have access, or select a dashboard (to which they have access) as their default home screen.

  • Show splash screen*: This setting controls whether a splash screen displays when the user signs in to Phocas or not.

  • Group, Territory and Team: These settings are only available if you have the Administration > Users: All Users permission. These items make easier and allow filtering in some areas of Phocas.

  • Password: This setting determines if the user receives sign-in details by email.

    • Auto-generate password: If selected, this automatically creates a password that conforms to your site's (as long as your site uses the default Phocas authentication), which is always used in conjunction with the Email details to user setting below. See .

    • Force password change: If selected, when the user first signs in, the system forces them to enter a new password.

    • Email details to user: This is only available if the details are configured and the user has an email address. If selected, it sends the URL, username and password to the user in an email.

  • License: This is the user’s Phocas (Full or Viewer) and access to the CRM and Rebates modules.

CRM license

The ability to assign a CRM license to someone depends on the number of licenses that are available for your Phocas site.

To assign the license to the user, select Yes from the CRM dropdown list and click Save. While in the user's maintenance form, proceed to assign the CRM permissions on the Profile tab.

Rebates license

The ability to assign a Rebates license to a user depends on the number of licenses that are available for your Phocas site. You can assign the license in three ways.

To assign the license to the user, select Yes from the Rebates dropdown list and click Save. While in the user's maintenance form, proceed to assign the Rebates user permission on the Profile tab.

  • Permissions: These are high-level, site-wide settings applicable to the user.

    • General > Account Locked: This setting controls whether the user’s account is locked.

    • General > Detailed Logs: This setting controls whether every query by the user is recorded. If selected, every query is recorded, along with the export activity. The logs are viewable in the user account’s Usage tab (see below). Caution should be used when enabling this option, as it can result in large quantities of data being collected, slowing the system down.

    • Custom Actions: These are special actions the user can access from the Analytics grid, relevant to the CRM and Rebates modules.


Profile tab

The Profile tab contains the user permissions. This is where you control what the user can do in Phocas, from a functionality perspective.

Profile type

The first thing to do is select a profile from the dropdown list. This determines whether permissions are automatically applied to the user or you apply them. You can select one of the pre-defined system (shared) profiles: Viewer, Basic, Advanced, and Administrator, or select the User Specific profile to create a profile specifically tailored for the user by selecting the required user permission checkboxes.

If the user has a Viewer license (set on the User tab), these settings are unavailable.

If you select the blank profile option, the user will have no functionality in Phocas. They can view favorites that are in the folders listed on the User tab and drill down on the resulting data, but they can't create new favorites or change modes within the existing ones.

User permissions


Databases tab


CRM Restrictions

This tab becomes available when the user has a CRM license.

Rules-based CRM user restrictions determine what CRM entities (accounts, contacts, leads, and activities) a CRM user can view or edit.

The basic principles of the CRM restrictions are:

  • You can always view and edit the entities you own. In the following image, you can see the default rule is Owner Equal To <User>, which means that the user (Bert) is restricted from viewing and editing all CRM entities except for those he owns.

  • If you have edit access to an account (or lead), you can edit the entities associated with that account. For example, if your restrictions allow you to edit an account (the parent), you can also edit that account's activities and contacts, and even the contact's activities (the children).

  • If you have view access to an account, you can view its entities and meetings (activities).

  • Campaigns can be viewed by all users, regardless of restrictions.

  • You can view and/or edit other CRM entities if you are linked to the owner of those entities via a restriction rule (as explained in the next section).

  • You can view meetings (activities) created against an account in your calendar. If you have , you can also view any .

Add restrictions

You enable users to view and edit more CRM entities (not just the ones they own) by adding restriction rules that link them to those entities. There are two models for adding restriction rules.

Use single values (static)

Add specific users, groups, territories, and/or teams to a restriction rule, one at a time.

This model is suitable for small organizations that typically have a flat hierarchy or only a few users because:

  • When circumstances change, you need to update the restriction rule for each user manually.

  • It can be difficult to understand who can access what, as the Users page only lists each user’s group, territory, and team, not any others to which they have been linked via a restriction rule. You need to go into each user’s CRM Restrictions tab for such details.

Example: Allow a user to view the CRM entities owned by another user

Suppose you want Bert the sales executive to be able to view the CRM entities owned by his colleague Betty.

  1. Open the user maintenance form and click the CRM Restrictions tab.

  2. In the View section, click the green plus button to add a rule.

  3. In the new rule row, select Owner. <User> automatically displays in the next box.

  4. Start typing the other user’s name (Betty) into the box and select the name in the list that displays.

  5. Click Save. Bert can now view Betty’s CRM entities along with his own.

This is a very basic example; it would be more common to add additional criteria such as territory, team, and so on.

Example: Set a range of CRM view and edit restrictions for a user

Suppose you want Bert the sales executive to be able to view and edit everything within his own team and territory. You also want him to be able to view entities within the neighboring territory (US Central East) but not edit anything relating to that territory.

In Bert’s user maintenance form, you can see that he belongs to the US Central North territory and the Sales team. He also belongs to the Electrical group but you do not want to use that group as the basis for any restrictions.

Open the user maintenance form and click the CRM Restrictions tab.

In the View section, enable Bert to view the additional CRM entities:

  1. Click the green plus button to add a rule and select Owner's Team. <User's Team> automatically displays in the next box. In Bert's case, this is the Sales team.

  2. Click the green plus button to add another rule and select Owner's Territory. <User's Territory> automatically displays in the next box. In Bert's case, this is the US Central North.

  3. Start typing US Central East into the box and select the item in the list that displays.

  4. Click Save. Bert can now view anything he that he owns, entities within his own team (Sales), territory (US Central North), and entities within US Central East, and any campaigns.

In the Edit section, enable Bert to edit the additional CRM entities:

  1. Click the green plus button to add a rule and select Owner's Team. As a result, <User's Team> automatically displays in the next box. In Bert's case, this is the Sales team.

  2. Click the green plus button to add another rule and select Owner's Territory. <User's Territory> automatically displays in the next box. In Bert's case, this is the US Central North.

  3. Click Save. Bert can now edit anything he that he owns, and entities within his own team (Sales) and territory (US Central North).

Multiple values (dynamic)

Use the Group, Territory, and/or Team settings on the User tab to drive the restrictions. Add multiple groups, territories, and/or teams to the user’s maintenance form separated by a semicolon and select the …(as semicolon separated values) option in the rule.

This model is suitable for larger organizations that likely have a more complicated hierarchy because:

  • The set-and-forget approach reduces the need to manually update restrictions for each user.

  • On the Users page, it is easier to see at a glance who can access what, which is handy when you have hundreds of users.

Example: Allow a user to view the CRM entities in two territories

Suppose Bert the sales executive is training new sales executives across the country, therefore, you want to allow him to view the CRM entities in multiple territories. You want to update this access from time to time without having to edit Bert’s restriction rule each time. You also want to have an easy way to see which territories Bert currently has access to view.

  1. In Bert’s user maintenance form > Territory box, type the additional territories after his own territory, separated by a semicolon and click Save.

  2. Click the CRM Restrictions tab.

  3. In the View section, click the green plus button to add another rule and select Owner's Territory. <User's Territory> automatically displays in the next box. In Bert's case, this is the US Central North.

  4. Click the box and select the <User’s Territory (as semicolon separated values)> option in the list that displays.

  5. Click Save. Bert can now view anything he that he owns and all CRM entities in the territories specified on his user maintenance form.

    • Back on the Users page, in the Territory column, you can see all the territories to which Bert is linked.

    • If you change Bert’s territories on the user maintenance form > User tab, the changes will automatically be applied to the rule in the CRM Restriction tab.

Remove all restrictions

Removing all restrictions gives the user full access to all the CRM entities. This action is suitable for administrators and users who require a broad level of access, as they typically need to view and edit all CRM entities.

Open the user’s maintenance form, click the CRM restrictions tab, select the No restriction checkbox, and click Save.


Favorites tab


Dashboards tab


Usage tab


Query Log tabs


Other tabs

The user maintenance form contains some additional tabs not typically available to administrators, which are used by Phocas implementation and support consultants. These include Settings and Audit.

You can also assign a license to multiple users using the or on the Users page.

You can also assign a license to multiple users using the or on the Users page.

Folders: These are the that contain the favorites and dashboards the user can access. You can in the Administration > Folders page.

*Users can change these settings for themselves via their

Learn more about and how to customize them to meet your organization’s needs.

The permissions are organized into the categories. See the page for details on each one.

The Databases tab displays a list of the Phocas databases. This is where you control the data the user can access in Phocas. Even if a user has permission to do something in Phocas, such as view a favorite or dashboard, if that user does not have access to the underlying data, no data will display. See .

While you can assign users to teams, groups, and territories to help you with user management, these settings are also used in CRM restrictions to determine what CRM entities each user can view and edit. If you have connected with , these rules also affect what you can see in your activities calendar.

The Favorites tab displays a list of the favorites to which the user has access, which includes any personal favorites created by the user and the favorites shared with them. You can delete any of these favorites. See .

The Dashboards tab displays a list of the personal dashboards created by the user, if any. You can delete any of these dashboards. See .

The Usage tab displays activity information for the user. See .

The Query Logs tab displays details for each query the user makes. See .

folders
manage these folders
account settings.
profiles
User permissions
Manage user database access and restrictions
Microsoft 365 Outlook calendar
Manage favorites
Manage dashboards
Monitor user activity
Monitor user activity
add and update user
Single sign-on (SSO)
database
license type
bulk updates
bulk update tool
bulk update tool
Manage passwords
Configuration > LDAP
password policy
SMTP
License view
License view