Power Office Go

Migration To Lime CRM

Addresses

Lime CRM	Power Office Go Address
Postal Address	?
Visiting Address	?
Invoice Address	?

Field Mappings

A screenshot will be added later.

General Data

Lime CRM	Power Office Go
Company Name	Name
RegistrationNo	VatNumber
Coworker	Name from OurReferenceEmployeeCode
Phone Number	PhoneNumber

Postal Address

Lime CRM	Power Office Go
Postal Address 1	MailAddress.Address1
Postal Address 2	MailAddress.Address2
Postal Zip Code	MailAddress.ZipCode
Postal City	MailAddress.City
Country	MailAddress.CountryCode

Visiting Address

Lime CRM	Power Office Go
Visiting Address 1	StreetAddress.Address1
Visiting Address 2	StreetAddress.Address2
Visiting Zip Code	StreetAddress.ZipCode
Visiting City	StreetAddress.City

Invoice Address

Lime CRM	Power Office Go
Invoice Address 1	N/A
Invoice Address 2	N/A
Invoice Zip Code	N/A
Invoice City	N/A
Invoice Email	EmailAddress

Sending a Company

Addresses

Lime CRM	Power Office Go
Postal Address	?
Visiting Address	?
Invoice Address	?

Field Mappings

General Data

Lime CRM	Power Office Go
Company name	Name
Registration no	VatNumber
Coworker	Name from OurReferenceEmployeeCode
Phone	PhoneNumber
Country	MailAddress.CountryCode

Visiting Address

Lime CRM	Power Office Go
Visiting address 1	StreetAddress.Address1
Visiting address 2	StreetAddress.Address2
Visiting zipcode	StreetAddress.ZipCode
Visiting city	StreetAddress.City

Invoice Address

Lime CRM	Power Office Go
Invoice address 1	MailAddress.Address1
Invoice address 2	MailAddress.Address2
Invoice zipcode	MailAddress.ZipCode
Invoice city	MailAddress.City
Invoice email	EmailAddress

Customer ID

Lime CRM	Power Office Go
Customer ID ERP	?

Invoices

Field Mappings

A screenshot will be added later.

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