Dataloy - Xledger Integration Documentation for Viewledger

Chapter Contents: 

General

• A transaction is done per company

Invoices

Integration is checking for invoices that are ready for posting every 10 seconds and then posts the invoice right after it has been identified. The invoice will be sent to Xledger which has a scheduled job that is picking up new invoices at a certain interval, this job can also be triggered manually by user.

Ledger

• Invoice in and credit In is using ledger 2400
• Invoice out and credit out is using ledger 1500

Company

Invoices are transferred to company in Xledger that is registered on the invoice in Dataloy.

Bar code, invoice number and KID 
 

When assembling an invoice in Dataloy there is a fields called External Doc. No. In integration with Xledger its possible to enter 3 different texts in here that is separated by the pipe character |.

barcodeInExternalDocumentNo, for invoice in, delt med pipe |, 

1. -> strekkode
2. -> invoiceNo, documentNo dersom ingenting etter pipe
3. -> KID 

Dersom barcodeInExternalDocumentNo = false

text = externalDocumentNo
invoiceNo = documentNo 

VAT invoice lines (gl_account 2700 or 2710) in Dataloy are ignored in transfer to Xledger, men blir med i total sum

voucherNo = document id

if gl account is not setup for the accounts in use, then invoice will not transfer to Xledger

Amount field mapping:

Xledger currency = Dataloy documentCurrency

Xledger currency amount = Dataloy documentAmount

Xledger amount = Dataloy companyCurrencyAmount

Xledger voucher date = dataloy document date

Xledger fiscal year = year when document was transferred to Xledger

Xledger period no = month when document was transferred to Xledger

CRI, CRO
dueDate = todays date

Payment Terms: uses payment terms from Dataloy

Bank Account

for norwegian bank accounts IBAN is skipped 

Accruals

Payments

Payments are collected from Xledger to Dataloy every hour (on the hour). All payments one month back in time is collected. The following Xledger transaction types are transferred: DR, AB, OCR, BA, GL, CHD. For a payment to be transferred to Dataloy there must be one payment and one invoice having the same match id and the invoice must have a reference to a Dataloy invoice. If a payment is missing in Dataloy, check the following:

1. Setup Xledger Test Client
2. Open the Xledger Test Client and enter the following values
   1. User Name: username
   2. Password: password
   3. EntityCode: Company code for the company that the invoice belongs to
   4. Web Service Method: "Export - GetSupplierTransactions" or "Export - GetCustomerTransactions" depending on if its customer og supplier transaction. If you are uncertain just do two requests to get all payments
   5. Free Text: leave empty
   6. Filter: Set a date filter so that you don't get too much data: [Created] > "2016-03-01 00:00:00"
   7. DataOption: All
3. Copy the data from previous step to a text editor and search for <MatchID>insert a match id</MatchID>
   1. You should find a transaction that has <TrSource> = AP or AR, this is the invoice and should have a <InvoiceNo> matching a tbl_document.document_no in Dataloy
   2. You should also find a transaction that has one of the following <TrSource> values: DR, AB, OCR, BA, GL, CHD
   3. If one of a or b is missing, this is the reason why no payment has been transferred to Dataloy
   4. If you find both a and b then there is a problem with the integration. Register a support case at http://support.dataloy.com
      
      

Setup Xledger Test Client

Xledger Test Client can be used for getting data from Xledger that can be used for checking a problem, for instance missing payments from Xledger to Dataloy. To setup the client follow these steps:

1. Install a certificate for your Xledger user account in Windows.
   1. Download from http://apps.xledger.net/CertificateManager/XCertificateManagerSetup.zip
   2. Unzip, install and run
   3. Select Get New Certificate
   4. Type the Xledger Web Service User Name and Password
   5. Select Get Security Code (E-mail)
   6. Type the Security Code
   7. Select Get Certificate and the Certificate should be installed automatically
2. Download and install Xledger Test Client: http://apps.xledger.net/WebServices/XWSTestClient.zip
3. Start client and check that certificate is listed in the first drop down selector
4. Enter username and password
5. Choose the Web Service Method you want
6. Filter the data you need
7. Always use DataOption: All
8. Click Get DataSet to call Xledger Web Service