Power Office Go

Field Mappings

Order

Lime CRM Power Office Go Comment
Order number OrderNo Set in Lime CRM based on Order number in ERP system
Invoice number ? Set in Lime CRM based on the Invoice number if Create invoice from order is true
Invoice - Relation will be set when the resulting invoice is booked and created in Lime CRM.
ERP db - An internal integration key that can be used when integrating towards several ERP systems, otherwise, always to the same value.
Company - Relation to the customer in Lime CRM.
Customer number CustomerCode Integration key to find the right customer in the ERP system.
Create invoice from order N/A If true, an invoice will automatically be created by the integration based on the Order
Order status - Shows the current integration status for each Order.
Customer reference CustomerReference
Coworker OurReferenceEmployeeCode
Order date OrderDate
Currency CurrencyCode
Order sum (excl VAT) - Can be used to store a calculation summation of the Order Rows
VAT - Can be used to store a calculation summation of the Order Rows
Order sum (incl VAT) - Can be used to store a calculation summation of the Order Rows
Error message - Populated by the integration if any error occurs.

Order Row

Lime CRM Power Office Go Comment
Order - Relation to the order based on the order number.
Row ID Calculated in Service
Description Description
Article ProductCode
Quantity Quantity
Unit UnitOfMeasure
Price per unit UnitPrice
VAT (%) N/A
Discount (amount) DiscountPercent (Calculated in service)
VAT account N/A
Income account N/A