Skip to main content

24SevenOffice - Config

Jarl Frode Arntzen
  • Updated

Configuration

Start by clicking "New Integration" in Semine.
Note: The instructions below assumes use of English language in 24SO and Semine.

Semine Connect root and client configuration
FIELD VALUE
Integration Name* Any name 
Application Key* Prefilled
Identity*

Found in 24SO --> Accounting --> Retrieval

This is the prefix for incoming voucher email: [prefix]@voucher.24sevenoffice.com
Username* ERP Username: The user with access to the clients in 24SO.
Example: integraton.user@example.com
Password* ERP Password: The password belonging to the above user.
Dimensions One or more possible values may be used: Department,Project,Employee
Ledger supplier account*

During export of GL Entries (Accounting Lines) from Semine to 24SO, the supplier account is set as follows:

  1. If the supplier has account set, it is used.
  2. If not, the specified fallback account here is used.
  3. If fallback account is blank, 2400 is used as default.

Voucher variant*

24SO: Entry type
"Inngående fakturaer*"

 

 

Default  voucher type / bilagsart 1

(Semine: "Cost invoice")

Credit note variant*

24SO: Entry type
"Inngående kreditnotaer*"

Default  vouchertype/bilagsart 3

(Semine: "Credit note")

Manual Voucher variant*

24SO: Entry type:
"Diverse*"

Default vouchertype/bilagsart 10

(Semine: "Manual Voucher")

 Do not pay variant*

 

Specific Voucher type needs to be created in 24SO, should not be marked as "omsetning"

(Semine: Invoice marked as do not pay)

Process manually

 Default 81,82,83,84,85,86,87,88,89,91,92

Invoices booked on the VAT codes mentioned above needs to be processed manually in 24SO via "bunt"

Include customers as suppliers

Default: only suppliers are synced to SEMINE. 

Setting need to be active to also include customers in the sync

Use stamp no series

Default: not activated

Setting needs to be activated if specific stampno. series  should be used for SEMINE. Stampno serie needs to be named "SEMINE" in 24SO
Semine Email*

The username for the integration user with access to the Semine client data.
Semine Password*

The password for the integration user with access to the Semine client data.

 

Limitations

Warning: It is currently not possible to accrue an invoice for next year due to limitations in 24SevenOffice.
See troubleshooting below.

Synced

  • Relations GL accounts --> VAT accounts
  • Custom dimensions

 

Not synced

  • Project Relations - No relations to department or GL accounts available in API
  • Some accounts have a requirement for department or project but this is not available in the API and has the requirement has to be set manually in Semine.  Invoice will fail in posting to ERP if department or project is missing on an account which  has the requirement. 
  • Closing date -  this is not available in the API and needs to be set manually in SEMINE

SEMINE Settings

  •  Number of decimals used when generating accounting lines needs to be set to 4

  • Vouchernumber is set by ERP on posting needs to be activated

Troubleshooting

Inconsistent language

In general, Semine displays all information in the users's selected language. However, messages from external accounting or ERP systems, such as 24SO, are displayed in that system's selected language.

 

Accrual for next year

It is currently not possible to accrue an invoice for next year due to limitations in 24SevenOffice.

Issue: 24SevenOffice has a limitation that prevents Semine from posting the accrued invoice if any of the accrual periods are set to next year.
In Semine, the invoice will show the status Posting Error and there will be an error message in the invoice comments from 24SevenOffice similar to the one shown below:

Failed to send invoice to ERP:
Error: Voucher failed to be posted 
Error Details: Failed to post invoice to ERP Could not Finish Last Bundle! 
iError: 1 | AccountService - Date 01.01.2022 00.00.00 is not valid! # 01.01.2021 - 31.12.202

Soution: Post the invoice to 24SevenOffice and then set the periodization there manually.

 

Suppliers

  1. Suppliers are synced but are not matching on invoices
    1. Missing or invalid bank account
      1. Check that the supplier in TFSO has a bank account
      2. Verify that the "primary" account, (if multiple accounts), is of type BBAN
      3. Eventually, for old suppliers, most likely from before 2019
        1. Delete bank card
        2. Re-enter bank card

24SO API returns  “default” bank account if suppliers has more than one number  added in 24SO. If no default number is set in 24SO, no bank account will be transferred 

    1.  
  2. Suppliers are not synced
    Possible reasons for missing suppliers are:
    1. Missing/invalid country -information
      Semine requires country to be filled in the supplier's addresses 

    2. Organization number missing
      Semine will only accept suppliers where the organization number field is filled in 24SO                            
    3. Supplier not marked as supplier in ERP
      By default SEMINE only syncs  suppliers marked as suppliers in ERP.  To sync customers as suppliers it needs to be set as an setting in the integration 

 

Known error messages when voucher failed to be posted: 

  1. Message:
    Error Code 99 : No error message found
    Solution: Try reposting invoice


  2. Message: 
    Office24Seven.Library.Economy.Accounting.VatIsNotInBalanceException
- Voucher has a vat code that does not have a corresponding vat amount
    Solution: Number of decimals used when generating accounting lines needs to be set to 4  in SEMINE settings.


  3. Message:
    Office24Seven.Library.Economy.Accounting.CustomerMismatchBankAccountException 
- Entry has a bank account that is different from the default bank account for the customer.
    Solution: Update bank account on the supplier in 24SevenOffice. When bank details are updated and synced to SEMINE, the supplier needs to be assigned again on the specific invoice.


  4. Message:
    Office24Seven.Library.Economy.Accounting.FiscalPeriodIsLockedException 
- The period of the fiscal year is locked.
    Solution: There is two ways of solving these errors.
      1. Unlock accounting period in 24SO.
      2. Update closing date in SEMINE and regenerate accounting lines before posting again


  5. Message: 
    Failed to send invoice to ERP:
    Error: Voucher failed to be posted 
    Error Details: Failed to post invoice to ERP Could not Finish Last Bundle! 
    iError: 1 | AccountService - Date 01.01.2022 00.00.00 is not valid!
    # 01.01.2021 - 31.12.202

    Soution: Post the invoice to 24SevenOffice and then set the periodization/accrual there manually.

Related articles

Comments

0 comments

Article is closed for comments.