Invoices

Field Mappings

These are the properties synced as standard for invoices, from the ERP system to Lime CRM.

Invoices

Lime CRM	Power Office Go
Invoice number	DocumentNo
Company	Name
Customer Number	CustomerCode
Customer's Reference	CustomerReference
Our reference	OurReferenceEmployeeCode to name
Type	Invoice or Credit
Invoice Date	VoucherDate
Due Date	DueDate
Currency	CurrencyCode
Amount	NetAmount * CurrencyExchangeRate
VAT	InvoiceTotalSum - InvoiceSum
Total Amount	TotalAmount * CurrencyExchangeRate
Balance	?
Paid	OutgoingInvoiceStatus.Paid
Payment Date	?
Shredded	Always false
Exchange Rate	CurrencyExchangeRate

Invoice Rows

Lime CRM	Power Office Go
Row ID	?
Invoice	invoice.DocumentNo
Item	ProductCode
Description	Description
Units	Quantity
Amount	TotalAmount * CurrencyExchangeRate
Contribution margin	UnitPrice - UnitCost