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 14 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.

Company

Invoices are transferred to company in Xledger that is registered on the invoice in Dataloy. Company code in Dataloy master data needs to match an Xledger company code for data to be transferred.

Ledger

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

VAT

VAT invoice lines (gl_account 2700 or 2710) in Dataloy are ignored from the invoice lines transfered to Xledger, but is included in the total amount.

GL Account

If GL account is not setup for the accounts in use on invoice, the invoice will not transfer to Xledger.

Field mapping

Xledger fieldValue from Dataloy
currencydocument currency
currency amountdocument Amount
amountcompany currency amount
voucher datedocument date
ledger fiscal yearyear when invoice was transferred
period nomonth when invoice was transferred
due date

Credit Note: todays date

Otherwise: due date from Dataloy payment terms

subledger bank accountbank account from invoice
voucher type

Invoice In and Credit In: AP

Invoice Out and Credit Out: AR

Otherwise: GL

voucher noinvoice number
currencycurrency from invoice
invoice dateinvoice date
voucher dateinvoice date
fiscal yearyear when invoice was transferred to Xledger
period nomonth when invoice was transferred to Xledger
account

Invoice lines: GL Account

Ledger invoice in, credit in: 2400

Ledger invoice out, credit out: 1500

posting1, Cost centerCustomer specific
posting2, ProjectCustomer specific
XGL

Pool Code

subledger nobusiness partner code
tax ruleVAT Code

Bar code, invoice number and KID
 

This feature is disabled by default, contact Dataloy for enabling this.

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 |. The values are:

  1. Bar Code
  2. Invoice Number
  3. KID

Example: 1234|000123|123456789

Its possible to include only to first value or the first and second value.

 

 

Project and Cost Center

Project and cost center is setup by customers requirements on request from Viewledger. This can be for example Voyage, VesselCode, Pool, BusinessUnit etc. Integration is checking for new data that are ready for posting every 10 seconds and then posts the data immediately. These data will transfer to all companies or to a group company if this is setup.

 

Business Partner

Integration is checking for new data that are ready for posting every 10 seconds and then posts the data immediately. Its possible to setup which Dataloy business partner types are to be transferred as customers and suppliers. These data will transfer to all companies or to a group company if this is setup.

 

Exchange Rate

Exchange rates are transferred from Xledger to Dataloy once a day, Monday to Friday.

 

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