How to integrate Projectworks with Salesforce

Projectworks offers integration with Salesforce to pull in Salesforce Opportunities into Projectworks as projects, automatically.

Configure the integration

Synchronisation configuration

Project defaults configuration

Disconnect the integration

 

Configure the integration

To get started, connect your Projectworks instance to your Salesforce account by navigating to Settings > CRM, select to ‘Connect’ in the Salesforce tile and follow the prompts in Salesforce.

image-20240614-034852

After successfully connected, you can configure how you want to the integration to operate by selecting the ‘Configure Sync’ button in Projectworks.

46711413-e538-4ed9-b0fd-7eddc8d510dc

Synchronisation configuration

The configuration allows you select up to two Salesforce sales processes to pull opportunities from. Use the dropdown to select the opportunity stage you want the system to turn Salesforce deals into Projectworks projects.

If you have multiple Salesforce Sales Processes, and more than one contains the same Opportunity Stage that is synced in Projectworks, the Salesforce Opportunity from any Sales Process will be pulled in to Projectworks when it reaches the earliest shared Stage.

You must also select sync frequency to tell the system whether;

  • you want the system automatically retrieve new opportunities from Salesforce

  • or whether you wish to keep the sync manual.

SFProject Defaults

Configure Project defaults

Additionally, you need to select your project defaults. These determine how the new opportunities are created as projects in Projectworks.

Organisation - the default organisation all new companies from Salesforce are created under.

At the moment we only support one organisation as the default. If you are operating a multi-organisation Projectworks instance, you can always re-parent the projects to the appropriate organisation at later stage.

Account Manager - The default Account Manager for all new companies, unless you’ve selected the tickbox to use Salesforce Company Owner instead.

If you have made this selection, the system will use Salesforce Company Owner as the Account Manager, unless the person does not exist in Projectworks. In that case, the default Account Manager will be used as the fallback.

Project Manager - The default Project Manager for all new projects, unless you’ve selected the tickbox to use Salesforce Opportunity Owner instead.

If you have made this selection, the system will use Salesforce Opportunity Owner as the Project Manager, unless the person does not exist in Projectworks. In that case, the default Project Manager will be used as the fallback.

Project Status - The default status for any new projects created from Salesforce deals.

 

You will also see two selection boxes;

Use Salesforce Opportunity Currency as Project Currency - If this is selected, then the system will create the new projects using the Salesforce currency if the currency is enabled in Projectworks. If left unticked (or if the currency isn’t enabled in Projectworks), the system will use the organisation default currency instead.

If your Salesforce doesn’t have multicurrency enabled, the system will use the Organisation default currency instead.

Use Salesforce Opportunity Amount As Budget Amount - If this is selected, the system will create a single budget for the project for the Salesforce Opportunity amount. You will also need to select an appropriate default GL Code for the budget.

 

Once you have configured the sync, you will see a new Sync status panel that gives you key information about the sync, such as when the last successful sync ran, the sync frequency and if you have selected to automatically sync ,when the next scheduled sync is due to run.

A panel below will show you the latest five projects created by the sync, along with information of when they were created. You can easily navigate to the project using the Project number or Project Name links. There is always the option to manually trigger the sync as well.

The system will use the Salesforce Opportunity Name as the Project Name

9d4a3b62-104f-4ab4-85d6-946889a60693

Disconnect Salesforce

To disconnect the integration, select the ‘Disconnect’ button on the right hand panel, and the integration is disconnected immediately - after disconnecting, you will have the option to reconnect is you want to.

3ebbc5ee-ddf5-4d81-9f48-57589cd6ea9d