Chapter Contents:
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
...
Xledger companies needs to be setup in Dataloy master data. The company codes must equal the Xledger company codes (5 digit code)
- First create a company that has the same code as the company group in Xledger. All customers and suppliers will be transferred to the company group in Xledger and will then be available for all companies in Xledger.
- Setup the companies that should be used when posting invoices to Xledger. Link these companies to the company group created in step 1 by using "Company Link" in Companies Master Data.
- If you need multiple companies in Dataloy to be posted to one company in Xledger, link these to a company created in step 2 by using "Company Link" in Companies Master Data.
...
| Dataloy | Xledger Header | Xledger Lines | Example |
|---|---|---|---|
| Vessel code | Posting1, cost center | Posting1, cost center | |
| Voyage reference number | Posting2, project | Posting2, project | |
| XGL | If xgl property in integration properties = poolCode, then poolCode is inserted in XGL If xgl property in integration properties = isTc, then XGL = TC for TC voyages and VC for VC voyages If property is not set then XGL = DLVMS | ||
| Posting3 | If company country = Singapore and business partner country = Singapore then Posting3 = LS else Posting3 = FS | ||
| Business partner code from Dataloy document header | SubledgerNo | ||
| Business partner code from Dataloy document line | SubledgerNo | If there is a co broker or broker commission on hire payable, then SubledgerNo = business partner code from Dataloy document line | |
| Due date from payment term | DueDate | If there is a co broker or broker commission on hire payable, DueDate is set on Xledger line | |
| Due date from payment term | DueDate | Credit Note: todays date Otherwise: due date from Dataloy VMS payment terms | |
| VAT code | TaxRule | ||
| Document currency | Currency | Currency | |
| Document amount | CurrencyAmount | CurrencyAmount | |
| Company currency amount | Amount | Amount | |
| Document date | VoucherDate | VoucherDate | |
| Document date | InvoiceDate | ||
| Document date year | FiscalYear | FiscalYear | |
| Document date month | PeriodNo | PeriodNo | |
| Document line text | Text | ||
| External document number | InvoiceNo | InvoiceNo | If external document number in Dataloy is empty InvoiceNo = Dataloy document number If reverse an invoice or credit note InvoiceNo = Dataloy document number |
| XIdentifier | XIdentifier | In Dataloy external document number users can append a pipe | and enter KID after external document number. For example: 1234|000123. This field is optional. | |
| Business partner bank account | SubledgerBankAccount | ||
| VoucherType | VoucherType | Invoice In and Credit In: AP Invoice Out and Credit Out: AR Otherwise: GL | |
| Document ID | VoucherNo | VoucherNo | |
| GLAccount | Account | Account | Invoice Lines: GL Account Invoice In, Credit In: APX account in Dataloy Invoice Out, Credit Out: ARX account in Dataloy |
Project and Cost Center integration
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
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 integration
Exchange rates are transferred from Xledger to Dataloy VMS once daily, Monday to Friday.
...