Review the standard errors that are shown in Connect before running a sync to MYOB in the Preview screen. This topic outlines the common errors and how to resolve them, by updating either data held in Synergy or MYOB.
Setup required before use | Who can use it? | Where is it? |
N / A | Assistant system administrator System administrator
| Connect to accounting > MYOB ARL Connect > Preview Connect to accounting > MYOB ARL Connect > History
|
What are MYOB ARL Connect errors (FAQ)?
MYOB Connect preview window completes a real time check between the data in Synergy and what exists in MYOB. If any of the data will have an issue being sent to MYOB then an error messages will to be shown in the preview tab. The error messages are shown to prompt the user to correct the data before the sync. If the user is not clear on how to fix the error they can skip the items, and send them in a future sync.
This topic reviews the common errors shown in MYOB Connect for invoices, credits, and payments. Each error message listed also has a solution listed of where to correct the data in either Synergy or MYOB.
Why use MYOB ARL Connect Errors (FAQ)?
Learn how to resolve a commonly displayed error in the MYOB Connect Sync.
Common MYOB ARL Connect errors (FAQ)
Below is a list of error messages shown in MYOB Connect for:
Synergy invoices
Credit notes
Invoice contacts being exported with an invoice / credit note
MYOB jobs exported for each invoice stage line
Area | Error message | Edit what | How to resolve |
Contacts | Unique ID is mandatory. | Contact | Select the '...' button > Contacts. Edit the contact record to include a 'Unique ID' and save. The unique ID on the contact record is the key item used to match contact records between Synergy and MYOB. This means you can have the flexibility of having Synergy and MYOB have the contact with different names, and the interface matches the contacts using the Unique ID number. |
Contacts | Email will be ignored as it is not in a valid format. | Contact | Select the '...' button > Contacts. Click the Edit button and change the contact email address to be a valid format. i.e. robert@paradise.com is a valid email address, and @paradise.com is an invalid email address format. MYOB does not allow contacts to have an email address that starts with an @ symbol, but Synergy allows this. If this error is ignored, then the email address is skipped and not sent to MYOB but the rest of the contact is sent. |
Invoices or credits | The account code XXX does not exist in MYOB. Please check the account code entered against the discipline / cost center XXX. | Cost center or discipline | Account codes can be entered on cost centers and disciplines in Synergy to map where the invoice / credit details should be sent to in MYOB. If the account code number you entered in Synergy was typed incorrectly and doesn't match to any of the accounts in MYOB then this error is shown. Each account code entered should be a number that matches and existing account in the MYOB account list, and it must be a detail type account. Data cannot be transferred to a header type account. Update an account code on a discipline / cost center by:
|
Invoices or credits | Discipline XXX does not have an account code set. | Discipline | If you are using the account code mapping option of 'discipline' then each of the disciplines in Synergy need to have a MYOB account code entered. Each account code entered is a number that should match and existing account in the MYOB account list. The account in MYOB must be a 'detail' type account (header type accounts cannot be used). Add the account code to a discipline by:
|
Invoices or credits | Cost center XXX does not have an account code set. | Cost center | If you are using the account code mapping option of 'cost center' then each of the cost centers in Synergy need to have a MYOB account code entered. Each account code entered is a number that should match and existing account in the MYOB account list. The account in MYOB must be a 'detail' type account (header type accounts cannot be used). Add the account code to a cost center by:
|
Invoices or credits | Tax rule 'GST' is not mapped. | Settings | This error is shown if the MYOB Connect > Settings tab does not have the required mappings entered for each of the tax codes. Each tax code in Synergy must be mapped to a MYOB tax code, as each invoice or stage line in MYOB requires to have a tax code entered to ensure that the invoice / credit note total is calculated with the same tax values as in Synergy. If the tax code is blank for any of these mapping options in the Settings tab, then this error is shown to let you know to go and correct the settings. Select the matching MYOB tax code and save the settings tab. When you open the preview screen again this error will disappear. |
Invoices or credits | Invoice date 27/02/2017 cannot be earlier than the MYOB lock date of 30/04/2017. | MYOB lock date | In MYOB a financial period can be locked to stop the import or addition of any data in that date range. The lock date is set in MYOB > Setup > Preferences > Security > Lock period option. The lock date entered in MYOB is checked by Synergy Connect. Synergy can only import data to MYOB on or after date entered as the lock date. To resolve this error you will need to either:
|
Credit note | Credit note cannot be processed because Synergy invoice #XXX has been skipped. | Skipped records | If the invoice does not exist in MYOB the linked credit note cannot be sent. If the invoice has already have been sent to MYOB or is in the current list in the preview screen, then this error is not shown. This error is shown when a user has skipped an invoice, and then the preview is refreshed. On refresh the linked credit note (or invoice payment) shows and error and cannot be sent until the invoice is not skipped anymore. Resolve this error by either:
|
Below is a list of error messages that are shown when:
Invoice payments are exported from Synergy to MYOB
Payment are imported from MYOB to Synergy
Area | Error message | Edit what | How to resolve |
Export payments | Payment cannot be processed because Synergy invoice #XXX has been skipped. | Skipped records | If the invoice does not exist in MYOB the linked invoice payment cannot be sent. If the invoice has already have been sent to MYOB or is in the current list in the preview screen, then this error is not shown. This error is shown when a user has skipped an invoice, and then the preview is refreshed. The linked invoice payment (or credit note) cannot be sent until the invoice is not skipped anymore. Resolve this error by either:
|
Export payments or Import payments | MYOB payment amount of $XX.xx is greater than the Synergy invoice owing amount of $XX.xx | Invoice payments | This error can occur because either the:
Resolve this error by either:
|
Export payments | Payment date 7/03/2017 cannot be earlier than the MYOB lock date of 30/04/2017. | MYOB lock date | In MYOB a financial period can be locked to stop the import or addition of any data in that date range. The lock date is set in MYOB > Setup > Preferences > Security > Lock period option. The lock date entered in MYOB is checked by Synergy connect. Synergy can only import data to MYOB on this date or after the date entered. To resolve this error you will need to either:
|
Below is a list of error messages that are shown when exporting:
Expense contacts (supplier contacts) exported with a supplier or subcontractor bill
Expense contact (Synergy staff exported as supplier contacts) exported with a staff expense
Staff cash and travel expenses
Bills (supplier and subcontractor expenses)
Area | Error message | Edit what | How to resolve |
Bills and staff expenses | Tax rule 'GST' is not mapped. | Settings | This error is shown if the MYOB Connect > Settings tab does not have the required mappings entered for each of the tax codes. Each tax code in Synergy must be mapped to a MYOB tax code, as each invoice or stage line in MYOB requires to have a tax code entered to ensure that the expense total is calculated with the same tax values as in Synergy. If the tax code is blank for any of these mapping options in the Settings tab, then this error is shown to let you know to go and correct the settings. Select the matching MYOB tax code and save the settings tab. When you open the preview screen again this error will disappear. |
Bills and staff expenses | Expense type "XXX" does not have an account code set. | Account codes | If you are using the account code mapping option of 'expense type' then each of the expense types in Synergy need to have a MYOB account code entered. Each account code entered is a number that should match and existing account in the MYOB accounts. Add the account code to an expense type by:
|
Contacts | Unique ID is mandatory. | Contact | Select the '...' button > Contacts. Edit the contact record to include a 'Unique ID' and save. The unique ID on the contact record is the key item used to match contact records between Synergy and MYOB. This means you can have the flexibility of having Synergy and MYOB have the contact with different names, and the interface matches the contacts using the Unique ID number. If this error is for a staff expense, please repeat the same steps above but edit the staff record and add a unique Id number that is not the same as an existing contact records. |
Contacts | Email will be ignored as it is not in a valid format. | Contact | Select the '...' button > Contacts. Click the Edit button and change the contact email address to be a valid format. i.e. robert@paradise.com is a valid email address, and @paradise.com is an invalid email address format. MYOB does not allow contacts to have an email address that starts with an @ symbol, but Synergy allows this. If this error is ignored, then the email address is skipped and not sent to MYOB but the rest of the contact is sent. If this error is for a staff expense, then please repeat the above steps when editing a staff record. Check that the staff record has a valid email address entered. |
Staff expenses | Project number 'XXXXXXX' needs to be 15 characters or less. | Project number | In MYOB the job needs to be 15 characters or less. If the 'project number' option is selected in the MYOB Connect settings for the 'Job source' option, then this error will be shown when your project prefix + number + suffix combination is greater than 15 characters. Resolve this by either:
Tip: Skip the staff expense with the unusual project number length whilst you determine how to resolve it with the above options. |
Bills | Discipline name 'XXXXX' needs to be 15 characters or less. | Discipline | In MYOB the job needs to be 15 characters or less. If the 'discipline' option is selected in the MYOB Connect settings for the 'job' option, then this error will be shown when your discipline name is greater than 15 characters. Resolve this by either:
Tip: Skip the bill with the unusual discipline name length whilst you determine how to resolve it with the above options. |
Bills | Cost center 'XXXX' needs to be 15 characters or less. | Cost center | In MYOB the job needs to be 15 characters or less. If the 'cost center' option is selected in the MYOB Connect settings for the 'Job' option, then this error will be shown when your cost center name is greater than 15 characters. Resolve this by either:
Tip: Skip the bill with the unusual cost center name length whilst you determine how to resolve it with the above options. |
Bills and staff expenses | Expense type 'XXXX' needs to be 15 characters or less. | Expense type | In MYOB the job needs to be 15 characters or less. If the 'expense type' option is selected in the MYOB Connect settings for the 'job' option, then this error will be shown when your expense type name is greater than 15 characters. Resolve this by either:
Tip: Skip the bill / staff expense with the unusual expense type name length whilst you determine how to resolve it with the above options. |
Bills and staff expenses | Invoice date 27/02/2017 cannot be earlier than the MYOB lock date of 30/04/2017. | MYOB lock date | In MYOB a financial period can be locked to stop the import or addition of any data in that date range. The lock date is set in MYOB > Setup > Preferences > Security tab > Lock period. Synergy can only import data to MYOB for the day after the lock date entered. To resolve this error you will need to either:
|