Invoices
Field Mappings
These are the properties synced as standard for invoices, from the ERP system to Lime CRM.
Invoices
| Lime CRM |
Exact Online |
| Invoice number |
salesInvoice.InvoiceNumber |
| Company |
customer.Name |
| Customer Number |
customer.ID |
| Customer's Reference |
salesInvoice.YourRef |
| Our reference |
salesInvoice.SalespersonFullName |
| Type |
Invoice or Credit |
| Invoice Date |
salesInvoice.InvoiceDate |
| Due Date |
salesInvoice.DueDate |
| Currency |
salesInvoice.Currency |
| Amount |
salesInvoice.AmountFCExclVat |
| VAT |
VATAmountFC |
| Total Amount |
salesInvoice.AmountFC |
| Balance |
balance |
| Paid |
True if balance is 0 |
| Payment Date |
N/A |
| Shredded |
Always false |
| Exchange Rate |
N/A |
Invoice Rows
| Lime CRM |
Exact Online |
| Row ID |
? |
| Invoice |
invoiceNumber |
| Item |
salesInvoiceLine.ItemCode |
| Description |
salesInvoiceLine.Description |
| Units |
salesInvoiceLine.Quantity |
| Amount |
salesInvoiceLine.AmountDC |
| Contribution margin |
(salesInvoiceLine.AmountFC - item.CostPriceStandard * salesInvoiceLine.Quantity |