In managing invoices across Avaza-Xero, it's not uncommon to encounter situations where the invoice numbers in one system do not match those in another. This discrepancy can arise due to various reasons, such as differences in prefix usage or variations in number series.
Here are a few things to check.
Make sure the "Automatic Invoice Number" checkbox is not checked on the Xero integration settings page. If this option is checked then the integration will not copy the Avaza invoice number to Xero but instead request Xero to create its own invoice number based on the Xero sequential rules.
When creating an Avaza invoice number don't enter any text in the invoice number field. Let Avaza use its sequential rules to create the next invoice number.
If you receive an exception that an invoice number already exists in Xero then it is possibly due to the fact that there are other methods used to create invoices in Xero. For example, another system is also generating invoices in Xero or invoices are manually created in Xero hence the sequential numbers get out of sync. To address this issue update the invoice number to a larger number than the largest invoice number in Xero so that the invoice number can be copied across without conflict. Please note that if you create invoices in Xero via other methods then it will not be possible to copy Avaza invoice numbers as they may conflict. In this instance enabling the "Automatic Invoice Number" option on the Xero integration settings will ensure Xero creates the invoice number rather than copying the Avaza invoice number.
Please note that you can quickly jump to the relevant Avaza invoice from Xero by opening the Xero Invoice details and clicking the "Go to Avaza Integration" button
