Accounting Integrations - Common Errors
Xero
API Error - Enabled
Error:
Anything starting with:
- Xero API error calling xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Examples:
- Xero API error calling GetAccounts: An error has occurred during the authentication process
Or
- Xero API error calling GetContactByContactNumber: An error has occurred during the authentication process
Solution:
- Go to Settings > Integrations > Xero
- Click blue pencil icon
- Select Enabled under Status
- Click Save All
Macro to use: Support > Accounting > Xero > Enabled
Archived Contact
Error:
- PO: 1234 / Inv: 12345689
- The contact with the specified contact details has been archived. The contact must be un-archived before creating new invoices or credit notes.
- The status 'ARCHIVED' is not valid for contacts.
Solution:
Client to fix the contacts that have been archived in Xero, then Enable the Integration again
Macro to use: Support > Accounting > Xero > Archived Contact
Locked Period
Error:
- ValidationException: A validation exception occurred
The document date cannot be before the end of year lock date, currently set at 30-Sep-2021
Solution:
How to identify the transaction that has caused the issue in the Income Report:
- Reports > Accounting Reports > Income Report
- Set Payment Date From to 2001
- Set Payment Date to the Data Date that failed (Above example: Data Date 27/10/2021)
- Entered Date From as Data Date that failed (Above example: Data Date 27/10/2021 12.00am)
- Entered Date To as Date that failed (Above example: Date 28/10/2021 12.00am)
- Untick Ignore Entered Date Filters
- Under Order Status select All
- Click Search
- Expand results, screenshot all, highlight the Payment Dates for the client
Client will then need to:
- Unlock their Xero Lock Period
- Enable the Integration
- Once the data has flowed through to Xero they can re-lock the Integration
Macro to use: Support > Accounting > Xero > Locked Period
Reconnect
Error:
- Xero API error calling GetContactByContactNumber: {"Type":null,"Title":"Forbidden","Status":403,"Detail":"AuthenticationUnsuccessful","Instance":"748dba20-3210-4020-9d04-247344562d79","Extensions":{}}
Solution:
Client will need to follow instructions to reconnect to their Xero account
Macro to use: Support > Accounting > Xero > Reconnect
Payments
Error:
- EFTPOS Payments 11/11/2021 #COMPANY NAME# [eftpos#172961] on invoice INV-#
- An error occurred in Xero. Check the API Status page http://status.developer.xero.com for current
Solution:
Client will need to follow the instructions to remove the Payments from the Invoice in Xero, then Enable the Integration.
The Payment type may be any Payment Type being sent from REX ( EFTPOS, Cash, Mastercard, etc.)
There may be one or multiple lines stating different Payment Types.
Each Payment will need to be removed manually from the invoice.
Macro to use: Support > Accounting > Xero > Payments
Tax Code
Error:
- ValidationException: A validation exception occurred
The TaxType code 'EXEMPTOUTPUT' cannot be used with account code '51305'.
Solution:
Client will need to follow the instructions to change the incorrect Tax Code.
Tax Codes differ depending on whether the Customer is in Australia or New Zealand.
Macro to use: Support > Accounting > Xero > Tax Code
Australia
New Zealand
Reached Invoice Limit
Error:
- ValidationException: A validation exception occurred
You have reached the limit of invoices you can approve.
Solution:
This is usually caused by the client being on the Starter plan of Xero, which only allows 20 total approved invoices to be created per month.
Client will need to clarify which Xero plan they are on and upgrade if they are on the lowest plan.
They can check against https://www.xero.com/au/pricing-plans/.
The other cause may be if they have Integrations from other sources outside of Retail Express as this may cause the limit to be reached even on the Standard plan.
Macro to use: No macro as rare and normally requires a further discussion with the client.
Website Address
Error:
- ValidationException: A validation exception occurred
Website must be valid.
Solution:
Client will need to remove the Website address saved against the Supplier Contact in Xero.
Reports > Accounting Reports > Purchase Order Report
Run for the date that is attempting to upload.
Every Supplier Contact in Xero that is attempting to Upload for that day will need the Website address removed.
Macro to use: No macro as rare occurrence
MYOB
Linked Accounts
Error:
- Validation Errors
- Refund Validation Errors: Cash Rounding Payments 05/11/2021 MVI [cashrounding#16904] on Invoice 00032600
- ValidationError: JournalLine_InvalidAccount
- ValidationError: JournalLine_AccountNotPostable
Solution:
Client will need to follow the instructions to change the settings in MYOB
Macro to use: Support > Accounting > MYOB > Linked Accounts
Locked Period
Error:
- Encountered a validation error (https://ar2.api.myob.com/accountright/f554deb1-3a0b-4856-a7e8-b2220966ff69/Sale/Invoice/Service/)
- ValidationError: BusinessEvent_DateOccurred_InLockPeriod
- ValidationError: BusinessEvent_DateOccurred_InLockPeriod
- Warning: ValidationWarning: SaleEventLine_NotIncomeAccount
OR
- Encountered a communication error (https://arl1.api.myob.com/accountright/0bdad8f8-23e4-4fd1-af1f-940edb5f19ae/Sale/Invoice/Service/)
Solution:
How to identify the transaction that has caused the issue in the Income Report:
- Reports > Accounting Reports > Income Report
- Set Payment Date From to 2001
- Set Payment Date to the Data Date that failed (Above example: Data Date 27/10/2021)
- Entered Date From as Data Date that failed (Above example: Data Date 27/10/2021 12.00am)
- Entered Date To as Date that failed (Above example: Date 28/10/2021 12.00am)
- Untick Ignore Entered Date Filters
- Under Order Status select All
- Click Search
- Expand results, screenshot all, highlight the Payment Dates for the client
Client will then need to:
- Unlock their MYOB Lock Period
- Enable the Integration
- Once the data has flowed through to MYOB they can re-lock the Integration
Macro to use: Support > Accounting > MYOB > Locked Period
Reconnect
Error:
- Unauthorised: Your user doesn't have access to MYOB file TEST RUN BETA RRSS. Please re-connect.
Solution:
Client will need to follow instructions to reconnect to their MYOB account.
Macro to use: Support > Accounting > MYOB > Reconnect
Negative Value
Error:
- Encountered a validation error (https://arl2.api.myob.com/accountright/dc78ed1a-b154-47a7-a459-b0205fa36748/Purchase/Bill/Service/)
- UnitPriceNotValid: UnitPrice must be a positive number
How to identify the Stock Receipt that has caused the issue in the Purchase Order Report:
- Reports > Accounting Reports > Purchase Order Report
- Set Received Date From & To as the Date failing to upload (Above example: Data Date 07/10/2022)
- Click Search
- In the Results tab sort the Amount Ex column in ascending order, there will be a Purchase Order with a negative value
- Expand results, screenshot the Purchase Orders with negative values
Solution:
Apply the below macro and submit as On Hold
Macro to use: Support > Accounting > MYOB > Negative Value
Open a new ticket in ZD, apply the below macro and submit as Open
Macro to use: Support > Accounting > MYOB > Negative Value Dev Script
Once this script is completed, Enable the Integration from Back Office.
Merge the script ticket into the customer-facing ticket.
Email the Customer to advise the script has been completed.
Inactive Supplier
Error:
- Supplier #SUPPLIER NAME# with reference RexMyob38 is inactive in MYOB
Solution:
Client will need to follow instructions to make the matching Supplier Card ACTIVE in MYOB.
Reenable the Integration in Retail Express.
Macro to use: Support > Accounting > MYOB > Inactive Supplier
Tax Codes
Error:
- ValidationError: TaxTransactionComponent_PostableAccountRequired
Solution:
- Client will need to check settings in their MYOB Company File
- Go to Lists > Tax Codes
- Check that GL accounts are configured correctly for each Tax type used by the Integration
Macro to use: Support > Accounting > MYOB > Tax Code
Australia
New Zealand
