Difference between revisions of "Fields sent to the accountancy package"

From 1Archive help
Jump to: navigation, search
(OIS)
(OIS)
Line 107: Line 107:
 
<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/>
 
<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'''
 
'''Posting line fields'''
* Net amount
+
* Net amnt
 
* Account
 
* Account
 
* VAT code
 
* VAT code

Revision as of 08:43, 14 April 2017

1 EIS

1.1 Incoming invoices

Header fields

  • Journal
  • Invoice type
  • Period
  • Supplier
  • Payment term
  • 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

Info.png 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.

Info.png 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
  • OGM
  • Comment
  • Currency
  • VAT amount
  • Total amount


Posting line fields

  • Net amount
  • Account
  • Cost unit
  • Cost center
  • VAT code
  • Description
  • Quantities

Info.png 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.

Info.png 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

  • Code
  • 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

Note.png 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

Info.png 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

Info.png We also send a sequence number to Octopus, this to be able to add successive bookings to Octopus.

2.3 Supplier/Customer

2.4 Account

3 VIS