Chapter Contents:
| Table of 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.
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
Company
...
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 field | Value from Dataloy |
|---|---|
| currency | document currency |
| currency amount | document Amount |
| amount | company currency amount |
| voucher date | document date |
| ledger fiscal year | year when invoice was transferred |
| period no | month when invoice was transferred |
| due date | Credit Note: todays date Otherwise: due date from Dataloy payment terms |
| subledger bank account | bank account from invoice |
| voucher type | Invoice In and Credit In: AP Invoice Out and Credit Out: AR Otherwise: GL |
| voucher no | invoice number |
| currency | currency from invoice |
| invoice date | invoice date |
| voucher date | invoice date |
| fiscal year | year when invoice was transferred to Xledger |
| period no | month 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 center | Customer specific |
| posting2, Project | Customer specific |
| XGL | Pool Code |
| subledger no | business partner code |
| tax rule | VAT Code |
Bar code, invoice number and KID
| Note |
|---|
This feature is disabled by default, contact Dataloy for enabling this. |
...
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
Its 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 type These 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:
- Setup Xledger Test Client
- Open the Xledger Test Client and enter the following values
- User Name: username
- Password: password
- EntityCode: Company code for the company that the invoice belongs to
- 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
- Free Text: leave empty
- Filter: Set a date filter so that you don't get too much data: [Created] > "2016-03-01 00:00:00"
- DataOption: All
- Copy the data from previous step to a text editor and search for <MatchID>insert a match id</MatchID>
- 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
- You should also find a transaction that has one of the following <TrSource> values: DR, AB, OCR, BA, GL, CHD
- If one of a or b is missing, this is the reason why no payment has been transferred to Dataloy
- 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 ClientAnchor setupXledgerTestClient setupXledgerTestClient
| setupXledgerTestClient | |
| setupXledgerTestClient |
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:
...