Xledger Plugin - Config

Steps to create Xledger integration

• Start by clicking "New Integration" in Semine.
• Then select Xledger Plugin in the dropdown.
• Fill in the areas based on the schema shown below.

Semine Connect root and client configuration

FIELD	VALUE	Description
Integration Name	Xledger Integration
API URL	https://www.xledger.net/graphql	live / test / demo
Xledger access token*	Get this from Xledger support for the live environment. See attached document SEMINE Connect Access- Xledger.docx  for necessary access. Static token for the test environment. Concatenate the token string into one line before using it. AAAI3QGevgAAAAAAARlLZeMhANY94BrPE4o1 jPGi0G1ivkOUd1oU3kFq8zunmTTNxQZtkGwf VCfj_3dcozLYPYfMKukgsSOxg16dhspBV5XD WW6Tb4nuOZry4HeeET	Required
Entity Owner Id *	This Id will be used by SemineConnect to sync the data from the relevant entity/organization. Also, the access token should belong to this Entity to run the operations properly. See the instructions below.	Required
Accounting Parameters Dimensions*	Example: Cost Center,Project, Employee, Organizational  unit See the instructions below.	Separator ,
Sync project manager as a setting of project	This enhancement provides users the option to include or exclude the project manager field during integration setup, allowing dynamic utilization of project manager information in workflows based on specific needs. See : Accounting Parameter Attributes for more information	Optional
Default Accounting Code for Supplier on Posting*	Example: 2400
Default Accounting Code for Customer on Posting*	Example: 1500
Incremental sync	Master data: Semine Connect will sync only master data modified in Xledger after each job's last successful job run date. Different success dates will apply for other master data: I.e., suppliers may have been successfully synced at a different time than VAT codes.
Asset: Sync as dimension	If yes, the assets are synced as dimension values under dimension code 35. The dimension name can be specified below If no, assets are not synced at all.
Asset: Display the name for the dimension	Required if Sync Assets as Dimensions is checked
Fixed Asset: Transaction type code(s) available	Required by Semine but not by Xledger. Example: 1, Anlegg, Asset |2, Andre, Other Format: code, no_description, en_description (Not required)	TransactionTypeSync job
Fixed Asset: Transaction type code used as required relation	One of the codes above has to be set here. Example: 1
Semine Email*	The username for the integration user with access to the Semine client data.	Required
Semine password*	The password for the integration user with access to the Semine client data.	Required

Additional field information

Entity Owner Id

In Xledger, Navigate to Administration --> Entity and copy the value under the Owner ID of the desired entity. Then, paste it into the Entity Owner Id field in the plugin setup.

To post the invoices to the correct entity, SemineConnect also needs the Owner ID set in the client to the ERP External ID field.

In Semine: Administration  --> Client Tab --> Edit desired client 

Dimensions

In Xledger, navigate to Accounting --> Setup --> Entity Dimension Setup and look at the values in the Object Field. Copy these values directly into the field called Dimensions in the Xledger plugin setup.

Example: Cost Center, Project, Employee, Organizational Unit

Default Accounting Code for Supplier on Posting

This fallback code will be used for all suppliers on posting unless a GL code is already defined for each supplier. Default: 2400

Default Accounting Code for Customer on Posting

This code will be used for all customers on posting regardless of customer parameters on the accounting line. Default: 1500

Running the jobs

There are two ways to run the jobs; organization level and client level. 

Organizational Level Sync

On this level, the data will be synced at the organizational level. I.e, accounting parameters, suppliers, currencies, and vat codes. The client name prefixed with "Org:" is used for this kind of sync operation.

Note :The invoices will be posted in connection with their clients to the ERP. This happens through the ERP External Id field in the properties of each client. See above for how to set it.

Note : Make sure that accounting parameter inheritance is turned on in Semine organization settings.

Client Level Sync

All the sync operation is carried out separately for the specified client under the integration.

Choose the client that you want to sync on.

Note: Make sure that accounting parameter inheritance is disabled in the Semine organization settings page. Otherwise, the synced parameters cannot be used for the client.

Notes for some of the jobs

AccountingCodeSync

SemineConnect syncs the accounting parameters whose ledger type is of GeneralLedger(GL) and AccountPayable(AP). The corresponding data in Xledger UI is placed on Accounting --> Chart of Accounts  --> Chart of Accounts

SemineConnect supports the following parameter relations on syncing:

• Account to Project
• Account to VAT
• Account to CostCenter

It is handled via Link Values in the ERP.

FixedAssetSync

Fixed assets are obtained from the same place as in accounting codes. The corresponding ledger type is AssetManagement(AM) in Xledger. The menu for the fixed assets: Accounting --> Chart of Accounts  --> Chart of Accounts

DimensionValuesSync

SemineConnect supports the relationship between dimension values and projects while syncing.
Relations can be found in the ERP (Project --> Project) like the following:

CurrencySync

Currencies are obtained starting today and going back seven days. And the most up-to-date currency pairs are distinct when syncing.

SupplierSync

SemineConnect supports the multiple bank accounts on suppliers when syncing from the ERP.

There are two places where bank accounts can be found:

1. Directly on the supplier details:
   
2. BankAccounts link on the left-hand side of supplier details:
   

InvoiceSync

Note : Settings --> Client --> SEMINE General
Make sure this setting is Active. If it is inactive, you will get one accounting line for each period which is not compatible with Xledger.