Invoices¶
Info
If Business Central is run on-premise, the information under Microsoft Dynamics NAV applies instead.
Field Mappings¶
These are the properties synced as standard for invoices, from the ERP system to Lime CRM.
Invoices¶
| Lime CRM | Business Central |
|---|---|
| Invoice number | No. |
| Company | Customer |
| Customer Number | CustomerNumber |
| Customer's Reference | N/A |
| Our reference | Name from Salesperson Code |
| Type | "Faktura" |
| Invoice Date | Document Date / Posting Date ? |
| Due Date | Due Date |
| Currency | Currency |
| Amount | Total Excl. VAT |
| VAT | Total VAT |
| Total Amount | Total Incl. VAT |
| Balance | Remaining Amount |
| Paid | [True if "Remaining Amount" = 0] |
| Payment Date | N/A |
| Shredded | Always false |
| Exchange Rate | N/A |
Invoice Rows¶
| Lime CRM | Business Central |
|---|---|
| Row ID | InvoiceNo + "_" + a sequence number. |
| Invoice | InvoiceNo |
| Item | No. |
| Description | Description |
| Units | Quantity |
| Amount | Line Amount Excl. VAT |
| Contribution margin | Line Amount Excl. VAT - (Unit Cost x Quantity) 1 |
-
Only valid for local currency. ↩