...
Invoices are transferred to company in Xledger that is registered on the invoice in Dataloy.
Bar code, invoice number and KID
| Note |
|---|
This feature is disabled by default, contact Dataloy for enabling this. |
When assembling an invoice in Dataloy there is a fields called External Doc. No. In integration with Xledger its possible to enter 3 different texts in here that is separated by the pipe character |. The values are:
- Bar Code
- Invoice Number
- KID
Example: 1234|000123|123456789
Its possible to include only to first value or the first and second value.
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.
...
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 |
CRI, CRO
dueDate = todays date
Payment Terms: uses payment terms from Dataloy
Bank Account
...
| 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. |
When assembling an invoice in Dataloy there is a fields called External Doc. No. In integration with Xledger its possible to enter 3 different texts in here that is separated by the pipe character |. The values are:
- Bar Code
- Invoice Number
- KID
Example: 1234|000123|123456789
Its possible to include only to first value or the first and second value.
Accruals
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 possible to setup which business partner type
These data will transfer to all companies or to a group company if this is setup.
...