Synced fields - Exact
The following tables list the data values that are synced between VOGSY and Exact.
| Every day VOGSY reads all book entries and journal entries from Exact and creates them in VOGSY if they do not already exist. |
Some of the data that is synced displays on a form in VOGSY or the target software. If the data value is associated with a field that displays to the user, the name of the field is listed in the Field name column in bold. If the data value is not associated with a field that displays to the user, the data name is listed in the Field name column in a monospace font. These conventions are used in order to give you a complete understanding of the data that is synced.
|
| The During setup column indicates whether or not the listed item is fetched from Quickbooks Online during the mapping stage of the integration setup. These items are not stored in VOGSY’s database during the setup. |
Organization data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Organization name |
|
|
|
Organization email |
|
|
|
Customer |
|
|
|
Supplier |
|
|
|
Organization website |
|
|
|
Organization phone number |
|
|
|
Organization VAT number |
|
|
|
Organization VAT type |
|
|
|
Organization payment condition |
|
|
|
|
|
|
|
To the attention of |
|
|
|
Invoice email address 1 |
|
|
|
Invoice address |
|
|
|
Invoice address zipcode |
|
|
|
Invoice address city |
|
|
|
Invoice address country |
|
|
|
Supplier number |
|
|
|
Debtor number |
|
|
|
Person (Organization Contact) data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Person name |
|
|
|
Person last name |
|
|
|
Person email |
|
|
|
|
|
|
|
|
|
|
|
Address |
|
|
|
City |
|
|
|
Zipcode |
|
|
|
Country |
|
|
|
Invoice data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Project number |
|
|
|
Invoice number |
|
|
|
Project name |
|
|
|
Invoice date |
|
|
|
Due date |
|
|
|
|
|
|
|
|
|
|
|
Amounts |
|
|
|
Payment condition |
|
|
|
Invoice Line data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Line description |
|
|
|
Line amount |
|
|
|
VAT amount |
|
|
|
VAT type |
|
|
|
VAT percentage |
|
|
|
Invoice line total |
|
|
|
Invoice line quantity |
|
|
|
Purchase invoice data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Project number |
|
|
|
Supplier name |
|
|
|
Creditor invoice number |
|
|
|
Invoice number |
|
|
|
Project name |
|
|
|
Invoice date |
|
|
|
Due date |
|
|
|
Currency code |
|
|
|
Currency rate |
|
|
|
Amount |
|
|
|
Inclusive amount |
|
|
|
Purchase invoice line data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
|
|
|
|
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
Project name |
|
|
|
Invoice date |
|
|
|
Due date |
|
|
|
|
|
|
|
|
|
|
|
Description |
|
|
|
Amount |
|
|
|
VAT amount |
|
|
|
VAT type |
|
|
|
|
|
|
|
VAT type data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Description |
|
|
|
Name |
|
|
|
Percentage |
|
|
|
Second description |
|
|
|
Second percentage |
|
|
|
Archived |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ledger account data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Description |
|
|
|
Account type |
|
|
|
Account number |
|
|
|
Distribute to project |
|
|
|
Department data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
|
|
|
|
Name |
|
|
|
Accounts payable data
| Accounts payable and accounts receivable data are only synced to check if the outstanding amounts are paid. |
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
Status |
|
|
|
Accounts receivable data
| Accounts payable and accounts receivable data are only synced to check if the outstanding amounts are paid. |
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
Status |
|
|
|
Journal entries data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Payment conditions data
| This data is imported to VOGSY from Exact, replacing any previous VOGSY data. |
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Name |
|
|
|
Days till Due Date |
|
|
|
Invoice text |
|
|
|
Book entry data
| Field name | During setup | VOGSY → Exact | Exact → VOGSY |
|---|---|---|---|
Journal |
|
|
|
Book entry number |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|