Orders
Field Mappings
These are the properties sent as standard for Power Office Go. Orders are sent from Lime CRM to Power Office Go.
Order
| Lime CRM |
Power Office Go |
Comment |
| Order number |
OrderNo |
Written back to Lime CRM based on the generated order number in Power Office Go. |
| Invoice number |
? |
Written back to Lime CRM based on the generated invoice number if Create invoice from order was true. |
| Invoice |
- |
Relation will be set when the resulting invoice is booked and thereby created in Lime CRM. |
| ERP db |
- |
An internal integration key that can be used when integrating towards several ERP databases. Is otherwise always set 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, the sync will automatically convert the order to an invoice in Power Office Go. |
| Order status |
- |
Shows the current sync status for each Order. |
| Customer reference |
CustomerReference |
|
| Coworker |
OurReferenceEmployeeCode |
|
| Order date |
OrderDate |
|
| Currency |
CurrencyCode |
|
| Order sum (excl VAT) |
- |
Used by Lime CRM to store a calculated summation of the Order Rows. |
| VAT |
- |
Used by Lime CRM to store a calculated summation of the Order Rows. |
| Order sum (incl VAT) |
- |
Used by Lime CRM to store a calculated summation of the Order Rows. |
| Error message |
- |
Populated by the sync if any error occurs. |
Order Rows
| 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 |
|