These are the most common messages you will find in the list of invoices (column = 'Confirmed description' or 'Paid description') or in the invoice itself in Coachview:
Ervaren Expert
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Mandatory: Payment condition"
In the export to Exact Online, the payment term (payment condition) is not included, and this is not set by default in the Exact Online administration. In Exact Online you have to fill in a standard payment condition (Sales) via 'Settings' -> tab 'Financial'.
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Mandatory: journal'.
In the Exact Online administration the diaries are not set. In Exact online you have to fill in the diaries via 'Settings' -> tab 'Financial'.
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Input 17: The amount of the VAT line with VAT code 4 does not correspond to the total amount of VAT in the basic payment rules.
Invoice lines/sales bookings are sent from Coachview excluding VAT. For the specific VAT-Code the type in Exact-Online is set as 'Included'. Convert the type of the VAT Code in the Master data -> Overview | VAT Codes > Maintenance to 'Included'.
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Invalid: Customer (Type).

A new debtor is sent to Exact Online, but the debtor number already corresponds to a relation number in Exact Online. This relation is either a debtor or a creditor. It is also possible that the relationship is listed on 'Prospect' in Exact Online. Change this to 'Client'.


There are two possibilities to solve this:


  1. Make sure that a prefix is placed in front of the debtor number of Coachview or
  2. That the debtor number starts with a certain range so that the number can never correspond with a relation number in Exact Online.
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Invalid: Customer condition.
A new debtor is sent to Exact Online with a prefix consisting of letters. It is possible that Exact Online does not accept these letters. Make sure that in the Service center the prefix is changed from letters to numbers.
Account Invalid VAT number. The number must be entered in the following format: NL999999999B99 - 1 block of 14 characters. (The 12th position is always 'B'). Example: NL000000000B00
An error was made in the debtor file when entering the VAT number.
Message: Nullable object must have a value
In the options (menu 'Service center') it is specified that the start and order date of the invoice is determined by the start and end date of the course. However, this is an invoice for an online course, where no start and end date of the course is determined. In the service center is indicated that to determine the VAT booking type the InvoiceStartDateOrder must be used. However, this is empty.
Exception factuur '99000002': GetDebiteurCodeAndAddIfNotExists(50003): DebtorExists: DoWebRequest: _CreateWebRequest: The remote server returned an error: (403) Forbidden.
The administration have not been found. Check if the correct administration number has been entered (also called division code).
Invoice with number '00001' cannot be exported because debtor with number 00004 has not yet been confirmed (possibly with the correct batch number) or debtor has changed.
Note:

This isn't an Exact Error message, it's a Coachview message.

The parameter (function 'Options') InvoiceExportDebtorConfirmedModified (Only export invoices of which the debtor has been confirmed and not changed. Value true or false) is checked (true).

Delete this option.


Missing: VAT code.
The VAT codes set in Coachview do not match the codes known in Exact Online. You need to change the VAT codes in Coachview to the code in Exact Online.
Can't compile debtor code. Check debtor and/or settings.
Note:

This isn't an Exact Error message, it's a Coachview message.

In this case, external source/id was not (correctly) filled in in the company and/or personal file.


Error: Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Blocked: General Ledger Account: 8000 - Sales.

In Exactly, the general ledger account is blocked.

Possible solutions:


  1. Lift this blockage in Exact-Online,
  2. Create a new general ledger account number in Coachview and change the sales rule templates and sales rules for the course definition or requests.
Note: Do not change the old general ledger account number to the new number via the menu 'Financial' and 'General ledger account'. All sales line templates, sales lines (whether or not invoiced), invoicing lines will be adjusted to this new number.
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] This booking is incorrect. One or more VAT rules are missing.''.
Cause currently unknown.
Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Mandatory: Customer'..
The following causes are possible:
  1. In Exact-Online the debtor is not characterised as a 'Customer'.
  2. The debtor ledger account recorded in the service centre is not correct.
Error: Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] The booking is unbalanced at: 2018 / 6 (Type: Sales booking) - Difference: EUR -876.65'.
Link the correct general ledger account to the VAT codes.
Error: Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Not found: Relationship (Security Academy) - General Ledger Account: Sales'.

The account with which the link to Exact Online was authenticated did not have sufficient rights.

Please note: It is not sufficient to have someone else re-authenticate the link (via Service Center). You must first disable the link via Exact Online and then re-authenticate it.


Error: Element: GLTransaction, Topic: GLTransactions, Message: 'Subject [GLTransactions] Period closed: 2018 - 4 The booking is unbalanced at: 2018 / 4 (Type: Sales booking) - Difference: EUR -1,577.96'.
The period in which the invoice is booked is already closed.
ExactOnline - Invoice is not found in banking transactions.
Payment received back: solution still unknown.
ExactOnline - Invoice is set to paid from ExactOnline - Invoice not processed: bank transaction status is not 'Processed
Payment received back: solution still unknown.
ExactOnline Error: Element: Account, Topic: Accounts, Message: 'Account Mandatory: Code'.
This error message is caused by the 'External debtor number' field entered in the debtor file. If you have set this up in the service centre and it has been filled in, it will be sent along as the debtor number. It seems that the external debtor number is not known in Exact Online or is filled in incorrectly.