Invoices¶
Field Mappings¶
These are the properties synced as standard for invoices, from the ERP system to Lime CRM.
Invoices¶
| Lime CRM | Monitor G5 |
|---|---|
| Invoice number | AccountsReceivable.InvoiceNumber |
| Company | Order.Customer.Name |
| Customer Number | Order.Customer.Code |
| Customer's Reference | BusinessContactReferenceName |
| Our reference | OurReferenceName |
| Type | AccountsReceivable.IsCredit |
| Invoice Date | AccountsReceivable.InvoiceDate |
| Due Date | AccountsReceivable.DueDate |
| Currency | AccountsReceivable.Currency |
| Amount | AccountsReceivable.InvoiceAmount |
| VAT | AccountsReceivable.VatAmount |
| Total Amount | AccountsReceivables.InvoiceAmount |
| Balance | AccountsReceivables.RestAmount |
| Paid | True if AccountsReceivables.PaidInfullDate or AccountsReceivables.RestAmount == 0 |
| Payment Date | AccountsReceivables.PaidInFullDate |
| Shredded | Always false |
| Exchange Rate | AccountsReceivable.ExchangeRate |
Invoice Rows¶
| Lime CRM | Monitor G5 |
|---|---|
| Row ID | ? |
| Invoice | AccountsReceivables.InvoiceNumber |
| Item | Part |
| Description | Part.Description |
| Units | Units |
| Amount | Price * Units * (1 - Discount/100) |
| Contribution margin | Price (total) - StandardPrice (total) |