Introduction
Ervaren Expert

In this article we explain which Coachview fields are used to export the debtor, invoice and invoice line(s) to Exact-Online and in which Exact-Online fields they are placed.




Debtor:
Exact Online

Coachview
Note
Account:@code
Invoice:Debtor:Debtor number
Maximum 18 characters
Account:@status
-
  • "A": None
  • "S": Suspect
  • "P":stat Prospect
  • "C": Customer (debiteur)
Account:Address:@default
-
"1"
Account:Address:@type
-
"INV"
Account:Address:AddressLine1
Invoice:Debtor:InvoiceAddress
Sometimes re-created, when changing address
Account:Address:AddressLine2
Invoice:Debtor:InvoiceAddress2

Account:Address:AddressLine3
Invoice:Debtor:InvoiceAddress3

Account:Address:City
Invoice:Debtor:InvoicePlace

Account:Address:Country:@code
Invoice:Debtor:InvoiceLandCode2Prefix

Account:Address:PostalCode
Invoice:Debtor:InvoicePostcode
Sometimes re-created, when changing address
Account:BankAccount:@code
Invoice:Debtor:Bank account number

Only withdraw bank account element if the code (=account number) has been filled.

If filled, it will be validated.

Component [AccountBankAccount] Mandatory: Bank account: Number

<Bank account code="063-0123456-10" default="1" format="NL10">


Account:BankAccount:@default
-
"1"
Account:BankAccount:@format
-
Factuur:Debiteur:FactuurLandCode2Prefix  + 10 dus "NL10" of “BE10”
Account:BankAccount:BICCode
Invoice:Debtor:BIC code

Account:BankAccount:Holder:Name
Invoice:Debtor:Account numberName

Account:BankAccount:IBAN
Invoice:Debtor:IBAN

Account:Contact:@gender
Invoice:Debtor:PersonGender
“M”, “V” of “O”
Account:Contact:@number
Factuur:Debiteur:PersonId

Contact element only if number (=PersonID) is greater than 0.

Contact number already exists in account:

Must not occur with other debtor.

Leave empty is not possible, because then the contact person is always created at the debtor.


Account:Contact:BirthName
Invoice:Debtor:PersonSurname

Account:Contact:FirstName
Invoice:Debtor:Person First name

Account:Contact:Initials
Invoice:Debtor:Person Initials

Account:Contact:LastName
Invoice:Debtor:PersonSurname

Account:Contact:MiddleName
Invoice:Debtor:PersonPrefixes

Account:Email
Invoice:Debtor:Email

Account:Name
Invoice:Debtor:Name

Account:Note
Invoice:Debtor:Note

Account:Phone
Invoice:Debtor:Phone

Account:VATNumber
Invoice:Debtor:VAT number




Invoice and invoicing rules:
An invoice (GLTransaction) consists of several invoice lines (GLTransactionLine).
  1. The first line of the invoice is in reality the header where the full amount is stated.
  2. The sub lines consist of (negative) amounts or (negative) VAT amounts. 
  3. A combination is not possible.

Example 1:
If the subline is about an amount of 5 euro with a VAT amount of 0 euro, then one invoice line is created with the amount "5" and the VATType "S" (No VAT).

Example 2:
If the subline concerns an amount of 5 euro with a VAT amount of 28 cents (6% VAT), then two invoice lines will be created. The first contains only the amount (€-4,72) with VATType "V" (Sales basis) and the last one must contain a list of all VAT amounts with a VAT amount of 28 cents (€-0,28) indicated with VATType "A" (Sales VAT). It is important that the correct VAT sales ledger account is specified.

  1. In the case of PaymentCondition, if added, the code and description are mandatory.
  2. In the case of PaymentTerms, a general ledger account number and book piece number are mandatory. 
  3. The general ledger accounttype can contain one of the following numeric values:
    1. 10: Cash
    2. 12: Bank
    3. 20: Debtors
    4. 22: Creditors
    5. 24: VAT
    6. 25: Employee payments
    7. 26: Prepayments
    8. 27: Provisions
    9. 29: Income tax payable
    10. 30: Fixed assets
    11. 32: Other assets
    12. 35: Cumulative depreciation
    13. 40: Stock
    14. 50: Shareholders' equity
    15. 52: Result still to be distributed
    16. 55: Non-current liabilities
    17. 60: Other debts
    18. 90: General
    19. 110: Sales
    20. 111: Cost of sales
    21. 120: Other costs
    22. 121: General expenses
    23. 122: Depreciation expenses
    24. 123: Research and Development
    25. 125: Employee costs
    26. 130: Extraordinary expenses
    27. 140: Extraordinary income
    28. 150: Taxes
    29. 160: Interest income

Invoice:
Exact Online
Coachview
Note
GLTransaction:@entry
InvoicePrefix + Invoice:InvoiceNumber

Journal part number (=integer, so prefix + invoice number must be typecast to integer. Max +- 2 billion)

if the value is wrong, Exact Online will automatically generate a valid number

GLTransaction:Date
Invoice:Date
Format: YYYY-MM-DD
GLTransaction:Description
Invoice:Description

GLTransaction:Journal:@code
-
Adjustable in parameters (sales) journal


Invoice header:
This is always the first GLTransactionLine.

Exact Online
Coachview
Note
GLTransaction:GLTransactionLine:Account:@code
Invoice:Debtor:@Debtor number

GLTransaction:GLTransactionLine:Amount:Value
Invoice:AmountInclVAT

GLTransaction:GLTransactionLine:Date
Afhankelijk van gekozen optie:
  • Factuur:StartDatumOrder
  • Factuur:EindDatumOrder
  • Factuur:Datum
  • DateTime.Now
Adjustable in web.config:
  • StartOrder
  • EndOrder
  • InvoiceDate
  • Now
Format: YYYY-MM-DD
This is the booking year and period
GLTransaction:GLTransactionLine:DueDate
Invoice:Expiry date
Format: YYYY-MM-DD
Depending on the settings in Exact-Online, Exact-Online will calculate it itself
GLTransaction:GLTransactionLine:GLAccount:@code
Invoice:InvoiceJournal[type="total"]:General LedgerAccountNumber
Must match in Coachview and Exact-Online.
GLTransaction:GLTransactionLine:References:YourRef
Invoice:Reference

GLTransaction:GLTransactionLine:VATType
-
S


Invoice line:
A GLTransactionLine is created for each invoice line.



Exact Online
Coachview
Note
GLTransaction:GLTransactionLine:Amount:Value
Invoice:Invoice Rule:Amount
Amount is negative
GLTransaction:GLTransactionLine:Amount:VAT:@code
Invoice:Invoice Rule:VAT Code
Must match in Coachview and Exact-Online.
GLTransaction:GLTransactionLine:Costcenter:@code
Invoice:Invoice Rule:Cost centreCode

GLTransaction:GLTransactionLine:Costcenter:Description
Invoice:Invoice Rule:Cost centreDeduction

GLTransaction:GLTransactionLine:Description
Invoice:Invoice Rule:Name
Optional: Name
GLTransaction:GLTransactionLine:GLAccount:@code
Invoice:InvoiceLine:General LedgerAccountNumber
Must match in Coachview and Exact-Online.
GLTransaction:GLTransactionLine:GLAccount:Description
Invoice:InvoiceLine:General LedgerAccountDeduction

GLTransaction:GLTransactionLine:Quantity
Invoice:Invoice Rule:Number

GLTransaction:GLTransactionLine:VATType
-
V


Invoice footer (VAT summons):

These are the last GLTransactionLines. A GLTransactionLine is created for each Invoice element.

Exact-Online calculates the VAT amount per invoice line and not per VAT percentage such as Coachview.

Exact Online
Coachview
Note
GLTransaction:GLTransactionLine:Amount:Value
Factuur:FactuurRegel:Bedrag
Amount is negative
GLTransaction:GLTransactionLine:Amount:VAT:@code
Factuur:FactuurRegel:Code
Must match in Coachview and Exact-Online.
GLTransaction:GLTransactionLine:FinPeriod
Zie FinYear
See FinYear (month of the specified date packs)
GLTransaction:GLTransactionLine:FinYear
Afhankelijk van gekozen optie:
  • Factuur:StartDatumOrder
  • Factuur:EindDatumOrder
  • Factuur:Datum
  • DateTime.Now
Adjustable in web.config:
  • StartOrder
  • EndOrder
  • InvoiceDate
  • Now
GLTransaction:GLTransactionLine:GLAccount:@code
Invoice:InvoiceLine:General LedgerAccountNumber
Must match in Coachview and Exact-Online.
GLTransaction:GLTransactionLine:VATType
-
A