| 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 | - |
|
| 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).
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.
|
| 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:
| Adjustable in web.config:
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:
| Adjustable in web.config:
|
| GLTransaction:GLTransactionLine:GLAccount:@code | Invoice:InvoiceLine:General LedgerAccountNumber | Must match in Coachview and Exact-Online. |
| GLTransaction:GLTransactionLine:VATType | - | A |
