Short Description
...
It is only possible to include the first value or the first and second value.
Project and Cost Center
A project and cost center is setup according to customers requirements on request from Viewledger, for example Voyage, VesselCode, Pool, BusinessUnit etc. Integration checks for new data that is ready for posting every 10 seconds and then posts it immediately. The data will transfer to all companies or to a group company if this is setup.
Business Partner
Integration checks for new data that is ready for posting every 10 seconds and then posts the data immediately. It is possible to setup which Dataloy Business Partner Type/s are to be transferred as customers and suppliers. 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 VMS once daily, Monday to Friday.
...
- Setup Xledger Test Client.
- Open the Xledger Test Client and enter:
- 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, (when uncertain do two requests to get all payments).
- Free Text: leave blank.
- Filter: Set a date filter to avoid too much data.
Example:
[Created] > "2016-03-01 00:00:00". - DataOption: All
- Copy the data from Step 2 above to a text editor and search for <MatchID>insert a match id</MatchID>.
- Locate the transaction with <TrSource> = AP or AR. This is the invoice and should have a <InvoiceNo> matching a tbl_document.document_no in Dataloy VMS.
- Locate the transaction with one of the <TrSource> values: DR, AB, OCR, BA, GL, CHD.
- If 4 or 5 is missing, then this is the reason why no payment has been transferred to Dataloy VMS.
- If both 4 and 5 is there, there is a problem with the integration. Register a support case at Dataloy Support.
Actuals
Actuals are collected from Xledger to Dataloy VMS every hour (on the hour). Actuals created within the last hour will then be collected. The process is listed below:
- Collect all projects from Xledger for companies listed in integration.properties
- For all companies in integration.properties and all gl accounts in Dataloy except for the following accounts: FOC, DOC, FLC, DLC, APX and ARX
- Collect data from GeneralLedger service in Xledger that has been created within last hour (since last actuals run)
- Voyage is collected from GLObjectValue2Code
- If GLObjectValue2Code is not a Dataloy voyage, then skip this transaction
- Special case
- If account = freight and related voyage is tc
- use account charter hire instead
- if account = charter hire and related voyage is vc
- use account freight instead
- If account = freight and related voyage is tc
- Voyage is collected from GLObjectValue2Code
- Collect data from GeneralLedger service in Xledger that has been created within last hour (since last actuals run)
- If project related to GeneralLedger record is open for posting (field is called allowPosting in Xledger service) and XGL code = VMS
- If actual is already inserted to Dataloy
- Update actual in Dataloy
- If actual is not existing in Dataloy
- Insert actual in Dataloy
- If actual is already inserted to Dataloy
Anchor setupXledgerTestClient setupXledgerTestClient
Setup Xledger Test Client
| setupXledgerTestClient | |
| setupXledgerTestClient |
...