Even geduld a.u.b...

Exact Online REST API - Journals

Endpoint

Journals

Good to know

Journals are used to create different types of entries in the most efficient way.
Use this endpoint to create, update, view or delete journals.
Note: Journals can only be deleted if they are not used in entries! Depending on type of journal different fields are relevant for setting up a journal code.
Payment service provider types are depending on legislation and package.

Scope

Financial generalledgers

URI

/api/v1/{division}/financial/Journals


GET POST PUT DELETE

Example usage

/api/v1/{division}/financial/Journals

/api/v1/{division}/financial/Journals

/api/v1/{division}/financial/Journals

/api/v1/{division}/financial/Journals


Properties

Name Mandatory Value Value Type Description
ID False Edm.Guid Primary Key
AllowVariableCurrency False Edm.Boolean Indicates if the journal allows variable currency
AllowVariableExchangeRate False Edm.Boolean Indicates if the journal allows the exchange rate of the currency of the amounts in the journal entry to be changed
AllowVAT False Edm.Boolean Indicates if the journal allows the use of VAT in the financial entry. Applicable only for General Journals
AutoSave False Edm.Boolean Indicates if the journal automatically saves the entries when the amount is in balance with the entry lines. Applicable for all types except cash. In the UI is called 'Exit Automatically'
Bank False Edm.Guid Reference to bank account. Only Bank journal type will have a value
BankAccountBICCode False Edm.String BIC code of the bank where the bank account is held. Only Bank journal type will have a value
BankAccountCountry False Edm.String Country of bank account. Only Bank journal type will have a value
BankAccountDescription False Edm.String Description of BankAccount. Only Bank journal type will have a value
BankAccountIBAN False Edm.String IBAN of the bank account. Only Bank journal type will have a value
BankAccountID False Edm.Guid Reference to the Bank Account linked to the Journal. Only Bank journal type will have a value
BankAccountIncludingMask False Edm.String Bank account number. Is mandatory for Journals that have Type = Bank
BankAccountUseSEPA False Edm.Boolean Obsolete. Whether or not use SEPA for the bank account
BankAccountUseSepaDirectDebit False Edm.Boolean Obsolete. Whether or not use SEPA direct debit for the bank account
BankName False Edm.String Name of bank account. Only Bank journal type will have a value
Code False Edm.String Primary key
Created False Edm.DateTime Creation date
Creator False Edm.Guid User ID of creator
CreatorFullName False Edm.String Name of creator
Currency False Edm.String Default Currency of the Journal. If AllowVariableCurrency is false this is the only currency that can be used
CurrencyDescription False Edm.String Description of Currency
Description False Edm.String Name of the Journal
Division False Edm.Int32 Division code
GLAccount False Edm.Guid Suspense general ledger account
GLAccountCode False Edm.String Code of GLAccount
GLAccountDescription False Edm.String Description of GLAccount
GLAccountType False Edm.Int32 Type of GLAccount
IsBlocked False Edm.Boolean Indicates whether the journal is blocked or not.
Modified False Edm.DateTime Last modified date
Modifier False Edm.Guid User ID of modifier
ModifierFullName False Edm.String Name of modifier
PaymentInTransitAccount False Edm.Guid General ledger account for payment in transit
PaymentServiceAccountIdentifier False Edm.String Identifier detail of the Payment service account. Ex. EmailID for Paypal type of Payment service account
PaymentServiceProvider False Edm.Int32 Type of Payment service provider. The following values are supported: 1 (Adyen), 2 (Paypal), 3 (Stripe). Is mandatory for Journals of Type 16 (Payment service)
PaymentServiceProviderName False Edm.String Name of the Payment service provider
Type False Edm.Int32 Type of Journal. The following values are supported: 10 (Cash) 12 (Bank) 16 (Payment service) 20 (Sales) 21 (Return invoice) 22 (Purchase) 23 (Received return invoice) 90 (General journal)

Returns