Twinfield Application

🇳🇱 Nederlandse vertaling

With the arrival of the App Store, the accounting link with Twinfield has been converted to an application. In this article we explain how you can install it for your own administration(s).

1. Installing the application
2. Linking administrations
3. Resynchronize failed Journal Entries
4. Resynchronizing synchronized journal entries
5. Error messages

1. Installing the application

In order to install the application you need to have access to the App Store, in this case there will be a market stall at the top of your Booking Experts menu bar. If you don't have this yet, ask Support to activate the App Store for you.

1. Click on the icon for the    App Store;
2. Then choose the    Twinfield Application;

3. Click on   +Install within the application;

4. Here you see an overview of what the application can see in your administration(s);
5. Choose the administration(s) for which this application is to be installed and click on Install;

6. The application has successfully been authorized, click on   OK to continue;

7. Under Commands, choose Authorize Twinfield;

8. Log in with your Wolters Kluwer account or Twinfield login information;

9. Give all permissions and click Yes, Allow;

10. The connection is authorized. Click OK to continue;

The application was installed successfully! 🎉

2. Linking administrations

In order to send the journal entries to Twinfield, the administration must be linked.

1. Under Commands, choose Configurations;

2. Click on + Add;

3. Select the administration you want to link and the corresponding administration in Twinfield;
4. Add the configuration;

5. Click Edit to fine-tune the configuration;

6. Set up the following components as desired:
  • Booking Experts administration;
  • Twinfield administration;
  • Frequency;
    • Monthly;
    • Daily;
  • General ledger;
  • Cost center;
  • Start date;
  • End date; (note! if you set an end date, in combination with a delay of x days your end date will have to be later in order to synchronize the last journal entries)
  • Automatic synchronization on or off;
  • Delay in days.
7. Save the changes;
8. If all settings are correct you need to Activate the configuration;

9. To pre-synchronize past journal entries for a newly created configuration (without waiting for the automatic synchronization), click Synchronize;

10. If there are journal entries, they will be visible in the summary, you can view them by clicking View.

3. Resynchronize failed Journal Entries

It can happen that, due to wrong settings, a journal entry can't be synchronized. These journal entries are shown in the overview of point 10 above. Go to the configuration of the journal entries and click at the journal entries on View.
If the journal entries could not be synchronized, they are displayed in the overview with Synchronized set to No. Click on the journal entry to view the error message.

Here you will find an overview of the failed lines in the journal entry.

After making the necessary adjustments, you can resynchronize the journal entry by clicking Synchronize Again.

It is also possible to resynchronize all failed journal entries in 1 time in the overview.

4. Resynchronizing synchronized journal entries

Due to changes in the past, or an adjustment in your ledger account structure, it may be that the existing synchronizations no longer match the data in Booking Experts.
Of course you want to restore this connection, for this you can resynchronize the already made synchronizations. Go to the relevant configuration and click on View under the journal entries.
All synchronized journal entries, are shown in the overview with Synchronized on Yes and with a Twinfield reference. Click on the journal entry to view it.

Click Synchronize again to resynchronize the journal entry and update it in Twinfield.

Please note! You do not need to delete the journal entry in question in Twinfield before resynchronizing it. With the new synchronization you update the current journal entry with the new data.

5. Error messages

Dimension reservation (XXXX) on level 1 can not be sub analyzed

You can solve this to navigate to the general ledger account in Twinfield:

  1. Financial professionals
  2. Dimensions
  3. Balance / Profit & loss
  4. Search the general ledger account number by entering the code (for example 1300)
  5. Open general ledger account
  6. Navigate to the tab "Links"
  7. Change "further analysis" to "Yes"

Dimension reservation (XXXX) on level 1 can not be sub analyzed

You can solve this to navigate to the general ledger account in Twinfield:

  1. Financial professionals
  2. Dimensions
  3. Balance / Profit & loss
  4. Search the general ledger account number by entering the code (for example 1300)
  5. Open general ledger account
  6. Navigate to the tab "Links"
  7. Change "further analysis" to "Yes"

General ledger account XXXX with number XXXX requires the specification of a relation or cost center.

  1. Financial professionals
  2. Dimensions
  3. Balance / Profit & loss
  4. Find the general ledger account number by searching the code (e.g. 1700)
  5. Open the general ledger account
  6. Navigate to the tab "Links"
  7. Change "further analysis" to "occasionally"

Currency date: The currency date is required.

  1. Go to Cash & Banks
  2. Find the cash or bank book that is causing the problem
  3. Change the field Line date to "allowed"
  4. Save
  5. Try to synchronize again.

The format of dimension type DEB of dimension (XXXXXX) XXXXXX (XXXXXX) at level 2 must conform to the format CRD.

You are probably booking a debtor to a ledger account that has been marked as a creditor account.

  1. Financial professionals
  2. Dimensions
  3. Balance
  4. Search for the debtor / creditor account (e.g.1600)
  5. Open the ledger account
  6. Navigate to tab "Links"
  7. Remove the line "Account is linked to [Type] [CRD]"

error - dim1: It is not permitted to use a combination of accounts on detail lines or VAT lines if the same combination is also used by a bank or cash book. The combination of accounts based on this line is used by the bank or cash book Cash (CASH).

This has been a very common error message with the transition from the synchronization of everything to a journal entry.

Within Booking Experts, we use interim accounts to process the payments. These numbers are often created as cash or bank in Twinfield.

To solve this problem, a new account needs to be created in Twinfield for the various interim accounts. The number chosen here can be used in Booking Experts.

After this, the synchronization can be carried out again.

VAT code of the transaction line does not match the fixed VAT code of the general ledger account

This means that a certain VAT percentage is mandatory in Twinfield. If you set a different VAT percentage, either deliberately or by accident, you will receive an error message. Then you will receive an error message. You want to change this in Twinfield.

You can check this in Twinfield in the following menu:

1. Financial professionals; 
2. Dimensions;
3. Click on Profit & Loss;
4. Click on the desired general ledger account;
5. Go to the Links tab;
6. Uncheck the box next to VAT. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.