Managing Reflex Harmony Accountancy synchronisations in the ReflexBlue Import/Export Service
In the ReflexBlue Import/Export Service, you use Reflex Harmony Accountancy synchronisations to establish a link between Reflex 3000 and external accounting packages. This connection is managed via the Reflex Harmony integration platform from ReflexSystems.
Files containing financial data that have been prepared locally on your PC for export by Reflex 3000 are picked up and sent to Reflex Harmony by the ReflexBlue Import/Export Service. Reflex Harmony processes this data and forwards it to the external accounting package. Outstanding sales transactions are also retrieved from the external accounting package via Reflex Harmony, after which they are stored locally on your PC. These can then be imported into Reflex 3000.
This part of the manual explains how to add, edit, and delete Reflex Harmony Accountancy synchronisations in the ReflexBlue Import/Export Service.
Important: To set up a Reflex Harmony Accountancy synchronisation for the Reflex 3000 Harmony accounting integration, you must first contact ReflexSystems. We will provide you with the necessary access credentials to create the synchronisation and link it to your Reflex Harmony integration.
Adding a Reflex Harmony Accountancy synchronisation
Follow these steps to add a new Reflex Harmony Accountancy synchronisation in the ReflexBlue Import/Export Service:
-
Go to the Synchronisations screen in the ReflexBlue Import/Export Service.
-
Select Add Synchronisation.
-
Choose Reflex Harmony Accountancy from the list of synchronisation types and then select Ok. You’ll be taken to the Create Reflex Harmony Accountancy Synchronisation screen.
-
Fill in all required fields. See the explanation of the required fields later in this manual.
The ReflexBlue Import/Export Service immediately checks whether the provided authentication details are correct. If authentication fails, an error message will appear. In that case, check whether the AWS Key, AWS Secret, and Company Identifier have been entered correctly.
-
Select Save to store the synchronisation.
If you have enabled the Is Active? option during setup, the synchronisation will become active immediately after saving.
Editing a Reflex Harmony Accountancy synchronisation
Follow these steps to edit an existing Reflex Harmony Accountancy synchronisation in the ReflexBlue Import/Export Service:
-
Go to the Synchronisations screen of the ReflexBlue Import/Export Service.
-
Select the accountancy synchronisation you want to edit. You’ll be taken to the Edit Reflex Harmony Accountancy Synchronisation screen.
-
Adjust the desired fields. See the explanation of the required fields later in this manual.
Select Reset to undo your changes and revert to the original values if you want to start over.
-
Select Save to save the changes.
Deleting a Reflex Harmony Accountancy synchronisation
Follow these steps to delete an existing Reflex Harmony Accountancy synchronisation in the ReflexBlue Import/Export Service:
- Go to the Synchronisations screen of the ReflexBlue Import/Export Service.
- Select the accountancy synchronisation you want to delete. You’ll be taken to the Edit Reflex Harmony Accountancy Synchronisation screen.
- Select Delete to delete the synchronisation.
- Confirm that you want to delete the synchronisation.
Required information for Reflex Harmony Accountancy synchronisations
When adding or editing a Reflex Harmony Accountancy synchronisation, you must fill in the information below.
| Name | Description |
|---|---|
| Name | A clear and recognizable name for the synchronisation. |
| Source Directory | The folder on the PC where the ReflexBlue Import/Export Service is installed, from which the files to be exported to the external accounting package are picked up. This may also be a locally configured network location. These files are forwarded to Reflex Harmony for export to the external accounting package. |
| Sales outstanding output path (Full Path) | The full path (including filename) to the CSV file on your PC where open sales transactions, imported from the external accounting package, must be stored. This file is periodically prepared by Reflex Harmony and retrieved by the ReflexBlue Import/Export Service. |
| AWS Key※ | The key used to access Reflex Harmony’s cloud storage for uploading and downloading files. |
| AWS Secret※ | The secret code used together with the key. |
| Company Identifier※ | The company identification code associated with your Reflex Harmony integration. |
| Harmony Integration Id※ | The ID of your Reflex Harmony integration. |
| Is Active? | Indicates whether the synchronisation is active. |
| File masks (Source Directory) | The file masks for the files that can be imported. This is explained further on in this manual. |
The information marked with ※ will be provided to you by ReflexSystems.
The AWS Key and AWS Secret are specifically intended for access to your synchronisations. Handle these credentials with the utmost care and ensure that these secret details do not fall into the hands of third parties.
Using file masks
With file masks, you can dynamically specify in the ReflexBlue Import/Export Service which filenames are allowed. For this, you use Regular Expressions (regex).
For Reflex Harmony Accountancy synchronisations, the following file masks are required:
- FMUTA6: File mask for retrieving files with financial transactions in the FMUTA6 format.
- CREDITOR: File mask for retrieving files with creditors.
- DEBTOR: File mask for retrieving files with debtors.
Files matching these file masks will be retrieved by the ReflexBlue Import/Export Service from the Source Directory you set up for the synchronisation and forwarded to Reflex Harmony for further processing.
For more information about using file masks, see: Using Regular Expressions for importing CSV files.