Datagate: HaloPSA Product & Contract Sync
Table of Contents
Scope
Intended Audience: White Label Partners
The following steps will show you how to sync your HaloPSA products & contracts into Datagage
Requirements:
- Access to Datagate
- HaloPSA Integration Set Up
Datagate: Set Up HaloPSA Integration
Scope
Intended Audience: White Label Partners
The following steps will show you how to set up the HaloPSA integration in Datagate
Requirements
- Access to Datagate
- Access to HaloPSA
- HaloPSA Integration Prerequisites Completed
- Log into Datagate
- Hover over your UserID in the top right-hand corner of the screen and Click Settings
- Click Integrations
- Click Configure for the HaloPSA integration
- Enter the following information gathered from your HaloPSA account and Click Test Account Access
- Client ID: Found in HaloPSA
- Client Secret: Found in HaloPSA
- Tenant: This is the Application Name you entered in HaloPSA
- Authorization Server: Found in HaloPSA
- Resource Server: Found in HaloPSA
"Test Account Access" will also create a Custom field (Datagate) on the Customer in HaloPSA.
Synchronization Options
- Click Details on the HaloPSA integration
- Synchronization Settings
- Enable Product Sync: Allows charges on recurring invoices to be imported and updated into Datagate as Products
-
Use Default Agreement: If Yes, all HaloPSA contracts for a customer are imported into a single Agreement in Datagate. This means Datagate will generate a single invoice per customer each month/billing period. Subtotals per site will be displayed on the invoice. When the invoice is exported to HaloPSA, it will be exported to a single contract.
- If No, each HaloPSA contract imported will be assigned to its own Agreement in Datagate. Datagate will generate a single invoice per contract per month/billing period. Each invoice can be exported back to its associated HaloPSA contract.
- Contract Type: This allows you to import charges from HaloPSA contracts of a particular type. This ensures a customer can have multiple contracts, some of which are invoiced by HaloPSA and others where Datagate creates the invoice.
- In Advance Setting: Typically: One Month in Advance. The monthly charges are a month in advance of any (possible) Usage charges. e.g. An invoice may contain July Usage charges and August monthly charges.
- Enable to Use Site Zip Tax for New Customers: Use the Site's zip code to determine the location if the charge is assigned to a Site and the Site has a zip code. otherwise, the Customer's zip code will be used for the tax engine. Typically: Yes.
- Update Site: Make sure this is checked.
- Allow Pro Rata: Pro rates charges for services that start in the middle of the month. If unchecked, the whole month of services is charged.
- Last Successful Sync: Displays the time the sync last ran successfully.
- Force Sync: Pushes your portal to the top of the Sync list
- Customer Synchronization
- Synchronize Opening Balance: If Yes, Datagate will import the current balance from HaloPSA. Opening balances are not currently displayed on a screen in Datagate.
- Product Synchronization Filters
- This allows you to choose which Items are imported to Datagate. If you leave this blank, all items for the Contract Type will be imported to Datagate.
- Item Group: Choose the Item Group you want to import. If left blank all reoccurring invoice items will be imported
- Basic: Choose a single Item Group. All items in this group will be imported
- Advanced: Choose multiple Items Groups. All items in these groups will be imported
- Item Group: Choose the Item Group you want to import. If left blank all reoccurring invoice items will be imported
- This allows you to choose which Items are imported to Datagate. If you leave this blank, all items for the Contract Type will be imported to Datagate.
Warning: Please contact us before enabling the Product Sync!
Import HaloPSA Products w/Tax Codes
- Log in to Datagate
- Click Import
- Select Product Templates then Click Next
- Choose Ignore and Download/Complete the Template
- Click Choose File, upload the completed template, Click Next
- Review Information looks correct and Click Next
- Click Start Import
Enable HaloPSA Product Sync
- Log in to Datagate
- Hover over your UserID in the top right-hand corner of the screen and Click Settings
- Click Integrations
- Click Details on the HaloPSA integration
- Check Enable Product Sync
- Click Save to start the product sync.
Recurring Invoice lines will now be imported into Datagate into the Customer Product. The contract Site will be imported into Datagate as a Product Site.