Do you use PowerOffice for your administration? The integration between Tribe CRM and PowerOffice can save you a lot of time. Errors that may arise from manually entering relationships are a thing of the past. Moreover, invoices in Tribe CRM are also automatically created in PowerOffice thanks to the comprehensive integration.
What functionalities does the integration with PowerOffice have?
How do I activate the integration?
Deactivating and deleting data
What data is synchronized?
1. What functionalities does the integration with PowerOffice have?
The PowerOffice integration consists of three components:
Relationship synchronization
Product synchronization
Invoice synchronization
Relationship Synchronization
When the integration is activated, during the initial synchronization, customers and suppliers from PowerOffice are automatically loaded into Tribe CRM. A duplicates check is performed on the existing relationships in Tribe CRM. This check is based on a unique ID from PowerOffice. If this is not found, an additional check is performed based on the debtor or creditor number.
After the initial synchronization, new relationships and changes in existing relationship data are automatically updated. This applies both from Tribe CRM to PowerOffice and vice versa. The synchronization is based on the unique ID in PowerOffice.
A new customer or supplier always receives a debtor or creditor number in Tribe. When you use the PowerOffice integration, this number is overwritten with the debtor or creditor number assigned by PowerOffice.
Note: The synchronization of relation from Tribe to PowerOfice will take place immediately. The synchronisation of relations from PowerOffice to Tribe will take place every 15 minutes. Payment synchronisation from PowerOffice to Tribe will take place every 4 hours.
Product Synchronization
The integration also supports product synchronization. Similar to relationships, products are applied through a two-way synchronization. Duplicate checks are performed based on the ID from PowerOffice.
Invoice Synchronization
When an invoice status is changed to Send in Tribe, it will automatically be synchronized as a (draft) invoice to PowerOffice (is dependant on the integration settings). We ensure that you have all the necessary information complete by adding al relevant information to the booked invoice, such as date, invoice and productlines.
2. How do I activate the integration?
Note! Are there already data in your financial administration and in your Tribe environment? First, make sure that the correct debtor and creditor numbers are entered for the customers and suppliers in Tribe CRM. This is to avoid duplicates due to the initial import.
Open the Marketplace in the upper right corner of your screen.
Go to the Financial tab and select PowerOffice.
Activate the integration by clicking “Activate.”
Enter the secret key which you can find in PowerOffice, and activate the integration.
Activate the necessary settings in the general settings tab. Any activated items will be synchronised between the two systems.
Select the standard ledger account.
Open the Units tab and configure the mapping between Tribe units and Economic Units.
Open the VAT Groups tab and link the correct VAT groups. (The VAT codes defined in Tribe CRM must be linked to the correct VAT codes in PowerOffice. Which VAT codes need to be linked depends on the country of the visit address of your own organization.)
After activation, the initial synchronization from PowerOffice to Tribe CRM will start immediately. Depending on the size of your administration, this may take some time.
3. Deactivating and deleting data
Over time, you may need to clean up your relationship or product data.
Deleting Data
If you delete data from Tribe, it’s important to know that the integration will never delete data from PowerOffice. The same applies in the opposite direction. When you delete data from PowerOffice, it will never be removed from Tribe CRM.
Deactivating Data
When you deactivate a relationship in PowerOffice, it is not yet processed with the status "former" in Tribe CRM. The relationship remains active.
When you deactivate a product in PowerOffice, it is processed in Tribe CRM with the status "inactive."
4. What data is synchronized?
The following fields are synchronised from PowerOffice to Tribe CRM.
Organisation (Customer/Supplier)
PowerOffice | Tribe |
Name | Organization Name |
Website | Website |
CustomerNumber | Debtor Number |
Address | Invoice Address |
Email Address | |
Phone | Phone Number |
Organisation Number | VAT number |
SupplierNumber | Debtor Number |
Contact
PowerOffice | Tribe |
Name | First Name, Middle Name, Last Name |
Telephone | Phone Number |
Email Address |
Person (individual customer)
PowerOffice | Tribe |
Name | First Name, Middle Name, Last Name |
Customer contact number | Debtor Number |
Telephone | Private Phone Number |
Private Email Address |
Products
PowerOffice | Tribe |
No. | Code |
Name | Name |
Product group | VAT |
Unit price | Sales Price |
Description | Description |
Unit cost price | Purchase price |
VAT group | Product group |
Unit | Unit |
Invoice
PowerOffice | Tribe |
Contact Number | Number |
Payment terms | Payment Terms in days |
Delivery date | Invoice Date |
Invoice lines | Product Lines |