Invoices¶
Field Mappings¶
These are the properties synced as standard for invoices, from the ERP system to Lime CRM.
Invoices¶
| Lime CRM | Tripletex |
|---|---|
| Invoice number | InvoiceNumber |
| Company | Customer.Name |
| Customer Number | Customer.CustomerNumber |
| Customer's Reference | contact first and lastname (from order) |
| Our reference | employee first and lastname (from order) |
| Type | Invoice / Credit Memo |
| Invoice Date | InvoiceDate |
| Due Date | InvoiceDueDate |
| Currency | Currency.Code |
| Amount | AmountExcludingVatCurrency |
| VAT | AmountCurrency - AmountExcludingVatCurrency |
| Total Amount | AmountCurrency |
| Balance | AmountCurrencyOutstandingTotal |
| Paid | True if balance is 0 else false |
| Payment Date | Postings.Date |
| Shredded | Always false |
| Exchange Rate | Amount/AmountCurrency |
Invoice Rows¶
| Lime CRM | Tripletex |
|---|---|
| Row ID | ? |
| Invoice | invoice.InvoiceNumber |
| Item | Product.Number |
| Description | Description 1 |
| Units | Count |
| Amount | UnitPriceExcludingVatCurrency |
| Contribution margin | AmountExcludingVatCurrency - (invoiceRow.UnitCostCurrency * invoiceRow.Count) |
-
Use Product.Name if description is empty ↩