Chapter Contents:
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
...
An invoice will not transfer to Xledger unless a GL Account is setup for the account in use on invoice.
Field Mapping
...
| Note |
|---|
The feature is by default disabled - contact Dataloy to enable. |
In dataloy VMS there is a field called External Doc. No. when assembling an invoice. When there is an integration with Xledger it is possible to enter 3 different texts in the External Doc. No. field. The texts are separated by the pipe character (|). The values are:
- Bar Code
- Invoice Number
- KID
...
It is only possible to include the first value or the first and second value.
...
| 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 | ||
| Xledger Field | Dataloy | |||
| posting1, Cost center | Vessel code | |||
| posting2, Project | Voyage reference If external document number in Dataloy is empty InvoiceNo = Dataloy document number | |||
| XIdentifier | ||||
| 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 | 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 | voucher no | document id (database id), for payment referenceVoucherNo | VoucherNo | |
| currencyGLAccount | 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 | Account | Account | Invoice Lines: GL Account Ledger Invoice In, Credit In: 2400APX account in Dataloy 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 |
...
ARX account in Dataloy |
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.
...