Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Chapter Contents: 

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.

 

 

Cost Center and Project


 

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
     
  • No labels