Document could not be found | The invoice related to the payment is not yet exported to Xero | Run the export invoices task to export invoices to Xero. Provided the invoices are in Xero the payments will automatically be exported on next payment export run. |
Invoice not of valid status for modification This document cannot be edited as it has a payment or credit note allocated to it | This error appears when you attempt to modify an invoice that has been paid for. | The only way to solve this is to void/delete the invoices in Xero and retry. Xero does not allow you to edit paid invoices. You can turn on to only export dispatched orders to Xero, this will reduce the number of times this issue happens as orders are not typically edited after dispatch. |
The Total for this document must be greater than or equal to zero. | It’s either the price/quantity in one of the line item is less than 0. | Change value to greater than 0. |
Due date cannot be empty. | Xero require the due date on an order / invoice to the populated. Due date is auto populated by Maropost Commerce however if you remove the due date this error will occur | Due date cannot be empty. Add a due date (payment section on order / invoice in Maropost Commerce) |
Account code must be specified The description field is mandatory for each line item. | An income account does not exist for one or more invoice lines. | Select a default income account to use when one cannot be found on a product level. Go to Xero > Settings & Tools to select this, or make sure that you have specified a valid income account for each product in your Maropost Commerce data base. You can specify an income account under the accounting section of a product’s edit screen. Note: If you used a previous accounting integration with Maropost Commerce (Saasu or MYOB) and you have old income account codes specified on products you will also receive this error. |
Account type is invalid for making a payment to/from. | The Xero account mapped to the payment method in Maropost Commerce is not enabled for payments. | Log into your Xero chart of accounts and tick the Enable Payments To This Account on each account that you have mapped to a payment method in Maropost Commerce. |
An existing contact could not be found using the specified contact details. The contact name field is required to create a new contact. | Most likely that a customer with that username is archived in Xero. Check that the customer in Maropost Commerce has a valid first and last name. | Change the username in Maropost Commerce to something else and re-export that invoice or make the archived contact active and re-export that customer. |
Item code ‘####’ is not valid. | The product has not yet exported to Xero or the product is marked as inactive in Xero. | The product has not yet exported to Xero or the product is marked as inactive in Xero. Re-export the product to Xero by going to the Products tab in the Unsuccessful and Successful Export Logs, searching the SKU then exporting that individual item. Also make sure the product as 'Active' in Xero. |
Invoice not of valid status for modification (Status is Paid). | Invoice has been marked as paid in Xero which closes the invoice for editing. | Mark this invoice as successful if you are comfortable with the state of the invoice in Xero. |
Account could not be found. | The sales account for a product in this order does not have a code or does not exist in Xero. | Add an account code for the sales account in Xero and refresh the CoA in Maropost Commerce or update the sales account code on the product. |
You have reached the limit of invoices you can approve. | Your Xero account is on a trial or is on the started plan. | You will need an active plan in Xero to use the integration. If you’re on the ‘starter’ plan, consult the limits on Xero’s pricing page here. |
Payments can only be made against Authorised documents Payment amount exceeds the amount outstanding on this document. | Most likely a payment was made against that invoice manually in Xero or an exported fully paid invoice was triggered for re-export. | Mark this payment as successful in Maropost Commerce if the invoice is fully paid, closed and completed in Xero. |
You can only record payments against AR or AP documents. | The invoice has previously had a payment but then reversed | Manually apply payment to invoice in Xero, and mark the payment in Maropost Commerce as Successfully Exported. |
The contact number ‘####’ is already assigned to another contact. The contact number must be unique across all contacts. | There is an existing contact card in Xero with a contact ID that matches this customer’s/supplier’s username or ID. | Change this customer’s/supplier’s username or ID. Mark this customer as successful if you will be using the existing contact in Xero. |
The contact name ‘####’ is already assigned to another contact. The contact name must be unique across all contacts. | A contact in Xero exists with this business name, with a different contact ID. | Change the business name of the supplier or customer in Maropost Commerce to something other than what’s already in Xero. |
The specified contact details matched an archived contact. Archived contacts cannot currently be edited via the API. | The contact has been archived or matches an archived contact in Xero. | Unarchive the contact in Xero. If you don’t want to continue to use or update the archived contact, change the ID/contact code in Xero once it’s no longer archived. |
OAuth Error: token_rejected. The access token has not been authorized, or has been revoked by the user | The most likely cause for this error is that the Xero integration is inactive. | Go to Xero > Setup & tools and make the integration active. |
The document date cannot be before the period lock date, currently set at 30-Jun-2020 | This is a lock set on Xero's side, usually used to stop any changes to previous financial periods as they have been finalised or they are being prepared for finalisation. | Xero has instructions here. We recommend consulting your accountant or bookkeeper before making any changes. |
Contact name cannot be empty | This is caused when the first/last name or company is missing on a sales order. | Open the order and add the customer's name or company so that can be associated to an equivalent in Xero. |
No items available to sell | This error is due to the items on the invoice being marked as Tracking Inventory in Xero. | When an item has been marked as Tracking Inventory in Xero, the Unit Price and the Stock must be positive in order for the invoice to be accepted by Xero. Adjust the price and/or stock to export the invoice. |
Unsuccessful export Debug error: ValidationException: A validation exception occurred | This is a generic error showing the API connection has been unsuccessful. | Refer to the error noted next to the record failing to export, as that will provide more accurate details as to why it is failing to send to Xero. |