Invoices
Full details of what is synchronised from Dynamics 365 to Xero are given below.
Invoices
The following Dynamics 365 Invoice fields are synced from Dynamics 365 to Xero
Branding Theme | Branding Theme |
Customer | Contact (see Contacts paragraph) |
Date Delivered | Invoice Date |
Description |
The first 30 character will be set as Reference in Xero. |
Due Date |
Invoice due date If this is not Xero calculates it based on its rules and it is synced back to Dynamics 365. |
Invoice Currency | Invoice Currency |
Invoice ID | Invoice number (if Use Xero invoice number is set to No and Use invoice name set to No on the Stellarise Connector Settings page) |
Invoice Name | Invoice number (if Use Xero invoice number is set to No and Use invoice name set to Yes on the Stellarise Connector Settings page) |
Invoice Type
|
Entity:
|
Line Amount Types
|
"Amounts Are"
|
Write-In Invoice Product records | Invoice Lines with
|
Write-In Invoice Product records |
Invoice Lines with
will be created in Xero as "just description" line. |
Built-In Invoice Product records | Invoice Lines with
|
Logic:
- Invoices are unidirectional, meaning they are transferred one-way: from Dynamics 365 to Xero. Anyway, some information is sync'd back from Xero to Dynamics. See Xero to Dynamics: What is synchronized?
Contacts
Contacts are only synced if you have Create new contacts in Xero set to Yes in Stellarise Connector Settings.
The following fields are synced from Dynamics 365 Accounts or Contacts to Xero Contacts
Dynamics
|
Xero
|
---|---|
Account Full Name | Contact Name |
Phone | Phone |
Address1 and Address2 |
Address |
City |
City/Town |
State/Province | State/Region |
Country/Region | Country |
Zip/PostalCode | Postal / Zip Code |
Logic:
- Customers are unidirectional, meaning they are transferred one-way: from Dynamics 365 Customers to Xero Contacts.
- If a Dynamics 365 Customer has not an equivalent Xero Contact, it will then be created in Xero.
- If a Dynamics 365 Customer has an equivalent Xero Contact it will then be used as it is.
- In Xero, the Contact full name is a Unique Key by itself, meaning no two "John Smith" are allowed to exist. In case of homonyms, the existing Xero Contact will be used! So, pay attention to correctly set Dynamics 365.
- If a Dynamics 365 Customer is updated, the changes won't be automatically applied to Xero. You need to manually amend in Xero.
- Xero calculates for us various amounts on Contacts. e.g. the Due Amount. These will be sync'd back to Dynamics 365 See 3.5.0 Xero to Dynamics: What is synchronized?
Products
Products are only synced if Create new Products in Xero is set to Yes in your Stellarise Connector Settings.
Following fields are sync'd from Dynamics 365 Invoice Existing Products to Xero Items
Dynamics
|
Xero
|
---|---|
Invoice Product Code | Item Code |
Invoice Product Name | Item Name |
Invoice Product Price Per Unit | Item Unit Price |
Invoice Product Account Code | Item Sales Account Code |
Invoice Product Tax Type | Item Sales Tax Rates |
Logic:
- Products are unidirectional, meaning they are transferred one-way: from Dynamics 365 Products to Xero Items.
- If a Dynamics 365 Product has not an equivalent Xero Item it will then be created in Xero.
- If a Dynamics 365 Product has an equivalent Xero Item it will then be used as it is.
- If a Dynamics 365 Product is updated, the changes won't be automatically applied to Xero. You need to manually amend in Xero.
- Write-in products on Dynamics 365 invoices will not be created in Xero as Xero Items, but will be applied on the invoice.