Short Description
Xledger Integration is an integration between Dataly VMS and Xledger.
Chapter Contents:
| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Long Description
Invoices
Integration is checking for invoices that are ready checks for invoices ready for posting every 10 seconds and then posts the invoice right after it has invoices immediately after they have been identified. The invoice invoices will be sent to Xledger which has a scheduled job that is picking up new invoices at a certain interval, this job . This can also be triggered manually by usera User.
Company
Invoices are transferred to the company in Xledger that is registered on the invoice in Dataloy VMS. Company The company code in Dataloy master data needs to VMS Master Data must match an Xledger company code for data to be transferred.
Ledger
- Invoice in In and credit Credit In is using uses ledger 2400.
- Invoice out and credit out is using Out and Credit Out uses ledger 1500.
VAT
VAT invoice lines (gl_account 2700 or 2710) in Dataloy VMS are ignored from the invoice lines transfered to Xledger, but is included in the total amount.
GL Account
If GL account is not An invoice will not transfer to Xledger unless a GL Account is setup for the accounts account in use on invoice, the invoice will not transfer to Xledger.
Field
...
Mapping
| Xledger fieldField | Value from Dataloy VMS |
|---|---|
| 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 VMS 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 linesLines: GL Account Ledger invoice in, credit inInvoice In, Credit In: 2400 Ledger invoice out, credit outInvoice Out, Credit Out: 1500 |
| posting1, Cost center | Customer customer specific |
| posting2, Project | Customer customer specific |
| XGL | Pool Codepool code |
| subledger no | business partner code |
| tax rule | VAT Code |
Bar
...
Code,
...
Invoice Number and KID
...
| Note |
|---|
This feature is disabled The feature is by default , disabled - contact Dataloy for enabling this. |
...
to enable. |
In dataloy VMS there is a fields field called External Doc. No. In when assembling an invoice. When there is an integration with Xledger its it is possible to enter 3 different texts in here that is the External Doc. No. field. The texts are separated by the pipe character (|). The values are:
- Bar Code
- Invoice Number
- KID
Example:
1234|000123|123456789
Its It is only possible to include only to the first value or the first and second value.
Project and Cost Center
Project A project and cost center is setup by according to customers requirements on request from Viewledger. This can be , for example Voyage, VesselCode, Pool, BusinessUnit etc. Integration is checking checks for new data that are is ready for posting every 10 seconds and then posts the data it immediately. These The data will transfer to all companies or to a group company if this is setup.
Business Partner
Integration is checking checks for new data that are is ready for posting every 10 seconds and then posts the data immediately. Its possible It is possible to setup which Dataloy business partner types Business Partner Type/s are to be transferred as customers and suppliers. These The 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 dayVMS once daily, Monday to Friday.
Payments
Payments are collected from Xledger to Dataloy every VMS every hour (on the hour). All payments for one month back in time is collected. The following Xledger transaction types transferred are transferred: DR, AB, OCR, BA, GL, CHD. For a payment to be transferred to Dataloy there must be one VMS a payment and one an invoice having the same match id must have the the matching ID and the invoice must have a reference to a Dataloy invoiceVMS invoice. If a payment is missing in Dataloy VMS, 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
...