MS Dynamics Business Central - how to prepare for hedgeflow API feed

MS Dynamics Business Central users must create Bank accounts, a dedicated Posting Account and Payment Journals for all currencies to export payments and transactions from HedgeFlows via API. This will allow HedgeFlows to automatically export detailed information about transactions and payments instructed via our platform directly into Business Dynamics. For example, Vendor invoices paid via HedgeFlows can have the payment automatically applied to them in your G/L and Vendor journals. Automating this process can save time and remove the risk of manual errors such as paying duplicate invoices or sending incorrect payments.

The following step must be implemented by experienced Dynamics Business Central users. If in doubt, please contact your accounting specialist or Microsoft consultant to assist with this process. HedgeFlows support team can provide assistance with technical integration issues but can't provide guidance on accounting treatment or company specific set up in Business Dynamics. 

The following steps are required to prepare Dynamics successful imports from HedgeFlows:

1. Create a dedicated posting group 
2. Create a G/L account for HedgeFlows
3. Create a Bank account for each currency
4. Create a Payment Journal for each currency

1) Create a dedicated Posting GROUP for HedgeFlows

Creating dedicated Payment Journals and Posting Group will ensure that correct entries are written by HedgeFlows in a compliant manner.  They are recorded in all relevant journals in a fashion, similar to how they would be recorded by Dynamics users manually. For example, creating a G/L Posting Group with direct posting disabled restricts entries into G/L without matching entries in Vendor Ledgers or Bank Ledgers.

To create the posting group, click on the icon in Business Central and search for "Bank Account Posting Groups".

Create a new posting group - enter a Code to name the group such as "HedgeFlows", go to the G/L Account no. column, and Click  on +New to add:

2) Create a G/L Account for HedgeFlows

We recommend entering HedgeFlows as a separate Posting Account as an Asset on your Balance Sheet and disabling Direct Posting by clicking on the relevant toggle:

Make sure the newly created account is mapped to your Posting group:

3) CREATE A BANK ACCOUNT FOR HEDGEFLOWS IN EACH CURRENCY

Go to the Cash Management section in Business Central and select Bank Accounts. Click on +New to start creating a new bank account :

Enter the number and name of the account. We recommend including the currency of the account in its name to simplify the Payments Journal mapping that will follow.

Select the correct currency for this account in Posting > Currency Code. For your main reporting currency, you can leave the Currency Code field empty: 

Next, Select Posting Group for HedgeFlows in Posting > Bank Acc. Posting Group:

Complete this process for all currencies you wish to have Bank Accounts for in Business Central:

4) Create a payment journal for HedgeFlows in each currency.

Go to the Cash Management section in Business Central and select Bank Accounts. Click on +New to start creating a new Payment Journal :

Enter the Name, Description for a Payment Journal in each currency and make sure to map it to Balancing Account Type "Bank Account" and Bal. Account No. that matches the accounts created in Step 3:

Once you have confirmed these settings, you are ready to complete mapping in HedgeFlows as described in Step 5 of our Business Central integration settings guide.