Difference between revisions of "Fields sent to the accountancy package"
From 1Archive help
(Created page with "==EIS== ===Incoming invoices=== '''Header fields''' * Journal * Invoice type * Period * Supplier * Payment term * Invoice number * Invoice date * Due date * OGM * Comment * C...") |
(→NIS) |
||
| (17 intermediate revisions by one other user not shown) | |||
| Line 7: | Line 7: | ||
* Period | * Period | ||
* Supplier | * Supplier | ||
| − | |||
* Invoice number | * Invoice number | ||
* Invoice date | * Invoice date | ||
| Line 23: | Line 22: | ||
* Cost center | * Cost center | ||
* VAT code | * VAT code | ||
| + | * Non ded % | ||
* Description | * Description | ||
* Quantities | * Quantities | ||
| Line 37: | Line 37: | ||
* Invoice number | * Invoice number | ||
* Invoice date | * Invoice date | ||
| + | * Due date | ||
* OGM | * OGM | ||
* Comment | * Comment | ||
| Line 82: | Line 83: | ||
When a new/updated account is used for booking a document, it is sent to Exact and added there.<br/> | When a new/updated account is used for booking a document, it is sent to Exact and added there.<br/> | ||
'''Fields''' | '''Fields''' | ||
| − | |||
* Name | * Name | ||
* Cost unit | * Cost unit | ||
| Line 92: | Line 92: | ||
* VAT code | * VAT code | ||
<br/> | <br/> | ||
| + | |||
==OIS== | ==OIS== | ||
| + | |||
| + | ===Incoming invoices=== | ||
| + | '''Header fields''' | ||
| + | * Journal | ||
| + | * Period | ||
| + | * Supplier | ||
| + | * Invoice date | ||
| + | * Due date | ||
| + | * OGM / Invoice number | ||
| + | * Comment | ||
| + | * Currency | ||
| + | * Total amount | ||
| + | <br/>{{note|The ''"OGM"'' field will be sent when it contains a value. If it doesn't contain a value, the ''"Invoice number"'' field will be sent.}}<br/> | ||
| + | '''Posting line fields''' | ||
| + | * Net amnt | ||
| + | * Account | ||
| + | * VAT code | ||
| + | * Non ded % | ||
| + | * Description | ||
| + | * Line Vat Amount | ||
| + | * Cost place | ||
| + | <br/>{{info|We also send a sequence number to Octopus, this to be able to add successive bookings to Octopus.}}<br/> | ||
| + | ===Outgoing invoices=== | ||
| + | '''Header fields''' | ||
| + | * Journal | ||
| + | * Period | ||
| + | * Customer | ||
| + | * Invoice number | ||
| + | * Invoice date | ||
| + | * Due date | ||
| + | * Comment | ||
| + | * Currency | ||
| + | * Total amount | ||
| + | <br/> | ||
| + | '''Posting line fields''' | ||
| + | * Net amnt | ||
| + | * Account | ||
| + | * VAT code | ||
| + | * Description | ||
| + | * Line Vat amount | ||
| + | * Cost place | ||
| + | <br/>{{info|We also send a sequence number to Octopus, this to be able to add successive bookings to Octopus.}}<br/> | ||
| + | ===Supplier/Customer=== | ||
| + | When there is a new/updated supplier/customer available, it is sent to Octopus and added/updated there.<br/> | ||
| + | * Name | ||
| + | * Address 1 | ||
| + | * Zip | ||
| + | * City | ||
| + | * Country | ||
| + | * VAT ID | ||
| + | * Bank account 1 | ||
| + | * Payment term | ||
| + | * Account 1 | ||
| + | * Currency | ||
| + | * Supplier/Customer E-mail | ||
| + | * Website | ||
| + | <br/> | ||
| + | |||
==VIS== | ==VIS== | ||
| + | |||
| + | ===Incoming invoices=== | ||
| + | '''Header fields''' | ||
| + | * Category | ||
| + | * Journal | ||
| + | * Bookyear | ||
| + | * Supplier | ||
| + | * Invoice nr | ||
| + | * Invoice date | ||
| + | * Due date | ||
| + | * Remark | ||
| + | * OGM | ||
| + | * Net amount | ||
| + | * VAT amount | ||
| + | * Total amount | ||
| + | * Currency | ||
| + | * Discount % | ||
| + | * Quick VAT | ||
| + | * Include in payment | ||
| + | * Margin | ||
| + | '''Posting line fields''' | ||
| + | * Net amnt | ||
| + | * Account | ||
| + | * VAT type | ||
| + | * VAT % | ||
| + | * Non ded % | ||
| + | * Place | ||
| + | * Unit | ||
| + | * Sort | ||
| + | * Description | ||
| + | * Non ded. account | ||
| + | * Quantities | ||
| + | <br/> | ||
| + | |||
| + | ===Outgoing invoices=== | ||
| + | '''Header fields''' | ||
| + | * Category | ||
| + | * Journal | ||
| + | * Bookyear | ||
| + | * Customer | ||
| + | * Invoice nr | ||
| + | * Invoice date | ||
| + | * Remark | ||
| + | * Net amount | ||
| + | * VAT amount | ||
| + | * Total amount | ||
| + | * Currency | ||
| + | * ABC | ||
| + | * Margin | ||
| + | * Purchase price | ||
| + | '''Posting line fields''' | ||
| + | * Net amnt | ||
| + | * Account | ||
| + | * VAT type | ||
| + | * Place | ||
| + | * Unit | ||
| + | * Sort | ||
| + | * Description | ||
| + | * Quantities | ||
| + | <br/> | ||
| + | ===Supplier/Customer=== | ||
| + | When a new/updated supplier/customer is used for booking a document, it is sent to Venice and added there.<br/> | ||
| + | '''Supplier and customer''' | ||
| + | * Name | ||
| + | * Address 1 | ||
| + | * Zip | ||
| + | * City | ||
| + | * Country | ||
| + | * VAT ID | ||
| + | * Account | ||
| + | * Currency | ||
| + | * Subject to VAT | ||
| + | * Required field | ||
| + | * Validate amount | ||
| + | * STP | ||
| + | * Supplier/Customer E-mail | ||
| + | * Website | ||
| + | <br/> | ||
| + | '''Supplier specific fields''' | ||
| + | * Bank account 1 | ||
| + | * BIC | ||
| + | * Payment term | ||
| + | * VAT type | ||
| + | * VAT % | ||
| + | * Quick VAT | ||
| + | <br/> | ||
| + | ===Account=== | ||
| + | When a new/updated account is used for booking a document, it is sent to Venice and added there.<br/> | ||
| + | '''Fields''' | ||
| + | * Name (English) | ||
| + | * Name (Nederlands) | ||
| + | * Name (Français) | ||
| + | * Verworpen % | ||
| + | * Private % | ||
| + | * Class subgroup | ||
| + | * PRC invoice | ||
| + | * PRC credit note | ||
| + | * SLS invoice | ||
| + | * SLS credit note | ||
| + | * Financial | ||
| + | * Sundry | ||
| + | <br/> | ||
| + | |||
| + | ==Connected== | ||
| + | Connected is not linked to any accountancy package, so no fields are exported. | ||
| + | |||
| + | ==MIS== | ||
| + | |||
| + | ===Incoming invoices=== | ||
| + | '''Header fields''' | ||
| + | * Journal | ||
| + | * Invoice type | ||
| + | * Period | ||
| + | * Supplier | ||
| + | * Invoice number | ||
| + | * Invoice date | ||
| + | * Due date | ||
| + | * OGM | ||
| + | * VAT amount | ||
| + | * Total amount | ||
| + | <br/> | ||
| + | '''Posting line fields''' | ||
| + | * Net amount | ||
| + | * Account | ||
| + | * Cost unit | ||
| + | * VAT regime | ||
| + | * VAT % | ||
| + | * Description | ||
| + | <br/> | ||
| + | {{warning|When you have multiple posting lines, you can only use 1 type of VAT regime. This because this is added to the header of the document in Multivers and we cannot send multiple values!}}<br/> | ||
| + | {{info|We also send a link of the document to Multivers, so you can go directly to the right document in MIS.}}<br/> | ||
| + | |||
| + | ==NIS== | ||
| + | |||
| + | ===Incoming invoices=== | ||
| + | '''Header fields''' | ||
| + | * Journal | ||
| + | * Invoice type | ||
| + | * Period | ||
| + | * Supplier | ||
| + | * Invoice number | ||
| + | * Invoice date | ||
| + | * Due date | ||
| + | * Comment | ||
| + | * VAT amount | ||
| + | * Total amount | ||
| + | * Discount due date | ||
| + | <br/> | ||
| + | '''Posting line fields''' | ||
| + | * Net amount | ||
| + | * Account | ||
| + | * VAT code | ||
| + | * Department | ||
| + | * Customer | ||
| + | * Product segment | ||
| + | * Product line | ||
| + | * Description | ||
| + | * IFRS | ||
| + | * Cutoff start date | ||
| + | * Cutoff end date | ||
| + | <br/> | ||
| + | {{info|We also send a link of the document to NetSuite, so you can go directly to the right document in NIS.}}<br/> | ||
Latest revision as of 15:58, 16 February 2021
1 EIS
1.1 Incoming invoices
Header fields
- Journal
- Invoice type
- Period
- Supplier
- Invoice number
- Invoice date
- Due date
- OGM
- Comment
- Currency
- VAT amount
- Total amount
Posting line fields
- Net amount
- Account
- Cost unit
- Cost center
- VAT code
- Non ded %
- Description
- Quantities
 |
Only when the "Add tolerance to highest VAT amount" setting on company is set to true, the VAT amount per line is sent too. Otherwise we will let Exact to the calculations. |
|
The image of the document is sent to Exact too. This together with a link to EIS, so you can open the document in Exact and go directly to the right document in EIS. |
1.2 Outgoing invoices
Header fields
- Journal
- Invoice type
- Period
- Customer
- Invoice number
- Invoice date
- Due date
- OGM
- Comment
- Currency
- VAT amount
- Total amount
Posting line fields
- Net amount
- Account
- Cost unit
- Cost center
- VAT code
- Description
- Quantities
|
Only when the "Add tolerance to highest VAT amount" setting on company is set to true, the VAT amount per line is sent too. Otherwise we will let Exact to the calculations. |
|
The image of the document is sent to Exact too. This together with a link to EIS, so you can open the document in Exact and go directly to the right document in EIS. |
1.3 Supplier/Customer
When a new/updated supplier/customer is used for booking a document, it is sent to Exact and added there.
Supplier and customer
- Active
- Name
- Address 1
- Address 2
- Address 3
- Zip
- City
- Country
- VAT ID
- VAT liability
- Supplier/Customer E-mail
- Payment term
- Currency
- VAT code
- Account
Supplier specific fields
- Chamber of commerce (Only in case of Exact NL!)
- IBAN
- BIC
- Website
1.4 Account
When a new/updated account is used for booking a document, it is sent to Exact and added there.
Fields
- Name
- Cost unit
- Cost unit required
- Cost center
- Cost center required
- % non deductable
- Non ded. account
- VAT code
2 OIS
2.1 Incoming invoices
Header fields
- Journal
- Period
- Supplier
- Invoice date
- Due date
- OGM / Invoice number
- Comment
- Currency
- Total amount
 |
The "OGM" field will be sent when it contains a value. If it doesn't contain a value, the "Invoice number" field will be sent. |
Posting line fields
- Net amnt
- Account
- VAT code
- Non ded %
- Description
- Line Vat Amount
- Cost place
|
We also send a sequence number to Octopus, this to be able to add successive bookings to Octopus. |
2.2 Outgoing invoices
Header fields
- Journal
- Period
- Customer
- Invoice number
- Invoice date
- Due date
- Comment
- Currency
- Total amount
Posting line fields
- Net amnt
- Account
- VAT code
- Description
- Line Vat amount
- Cost place
|
We also send a sequence number to Octopus, this to be able to add successive bookings to Octopus. |
2.3 Supplier/Customer
When there is a new/updated supplier/customer available, it is sent to Octopus and added/updated there.
- Name
- Address 1
- Zip
- City
- Country
- VAT ID
- Bank account 1
- Payment term
- Account 1
- Currency
- Supplier/Customer E-mail
- Website
3 VIS
3.1 Incoming invoices
Header fields
- Category
- Journal
- Bookyear
- Supplier
- Invoice nr
- Invoice date
- Due date
- Remark
- OGM
- Net amount
- VAT amount
- Total amount
- Currency
- Discount %
- Quick VAT
- Include in payment
- Margin
Posting line fields
- Net amnt
- Account
- VAT type
- VAT %
- Non ded %
- Place
- Unit
- Sort
- Description
- Non ded. account
- Quantities
3.2 Outgoing invoices
Header fields
- Category
- Journal
- Bookyear
- Customer
- Invoice nr
- Invoice date
- Remark
- Net amount
- VAT amount
- Total amount
- Currency
- ABC
- Margin
- Purchase price
Posting line fields
- Net amnt
- Account
- VAT type
- Place
- Unit
- Sort
- Description
- Quantities
3.3 Supplier/Customer
When a new/updated supplier/customer is used for booking a document, it is sent to Venice and added there.
Supplier and customer
- Name
- Address 1
- Zip
- City
- Country
- VAT ID
- Account
- Currency
- Subject to VAT
- Required field
- Validate amount
- STP
- Supplier/Customer E-mail
- Website
Supplier specific fields
- Bank account 1
- BIC
- Payment term
- VAT type
- VAT %
- Quick VAT
3.4 Account
When a new/updated account is used for booking a document, it is sent to Venice and added there.
Fields
- Name (English)
- Name (Nederlands)
- Name (Français)
- Verworpen %
- Private %
- Class subgroup
- PRC invoice
- PRC credit note
- SLS invoice
- SLS credit note
- Financial
- Sundry
4 Connected
Connected is not linked to any accountancy package, so no fields are exported.
5 MIS
5.1 Incoming invoices
Header fields
- Journal
- Invoice type
- Period
- Supplier
- Invoice number
- Invoice date
- Due date
- OGM
- VAT amount
- Total amount
Posting line fields
- Net amount
- Account
- Cost unit
- VAT regime
- VAT %
- Description
 |
When you have multiple posting lines, you can only use 1 type of VAT regime. This because this is added to the header of the document in Multivers and we cannot send multiple values! |
|
We also send a link of the document to Multivers, so you can go directly to the right document in MIS. |
6 NIS
6.1 Incoming invoices
Header fields
- Journal
- Invoice type
- Period
- Supplier
- Invoice number
- Invoice date
- Due date
- Comment
- VAT amount
- Total amount
- Discount due date
Posting line fields
- Net amount
- Account
- VAT code
- Department
- Customer
- Product segment
- Product line
- Description
- IFRS
- Cutoff start date
- Cutoff end date
|
We also send a link of the document to NetSuite, so you can go directly to the right document in NIS. |
