Skip to main content

Common MYOB Errors and How to Fix Them

Learn how to identify and resolve common MYOB sync errors when syncing orders or invoices from Ordermentum. Fix issues quickly and know when manual action in MYOB is required.

Updated over 3 weeks ago

Overview

When syncing orders or invoices from Ordermentum to MYOB, error messages may appear. Each error highlights an issue that must be resolved before the order or invoice can successfully sync.

This guide explains:

  • Why each MYOB sync error occurs

  • How to fix the issue in Ordermentum or MYOB

  • When a manual fix in MYOB is required


Before You Begin

Make sure you have:

  • Access to the Supplier Dashboard in Ordermentum

  • Permission to edit orders or venue details

  • Access to MYOB product settings, account codes, or Business Settings, depending on the error


MYOB Error Guide

Below are the most common MYOB sync errors and how to fix them.


1. Term_Out_Of_Range

Reason: The order due date in Ordermentum is earlier than the invoice date sent to MYOB. MYOB requires the due date to be after the invoice date.

How to fix:

  1. Open the order in Ordermentum.

  2. Click Edit Order.

  3. Update the Due Date so it is after the invoice date.

  4. Save and re-sync the invoice.

If the order has already been paid, manually update the invoice in MYOB instead.


2. Unable to find product in MYOB with SKU <x> (SKU mismatch)

Reason: The product SKU in Ordermentum does not match the SKU in MYOB.

How to fix:

  1. Check the product SKU in MYOB.

  2. Update the SKU in Ordermentum or MYOB to match exactly.

  3. Edit and save the order to trigger a re-sync.


3. MYOB - BusinessEvent_DateOccurred_InLockPeriod

Reason: The invoice date is inside a locked accounting period in MYOB.

How to fix:
Option 1: Update the invoice date in Ordermentum

  • Adjust the Invoice Date outside the locked period.

  • Save and re-sync.

Option 2: Adjust locked period in MYOB

  • Go to Settings > Business Settings > Locked Date

  • Unlock or adjust the date range

  • Re-sync from Ordermentum

Option 3: Manually create the invoice in MYOB if date changes are not possible.


4. Customer is required or Cannot read properties of null (reading 'UID')

Reason: Customer Trading names in Ordermentum contain special characters that MYOB does not accept (e.g., Café, John’s).

How to fix:

  1. Open the venue profile in Ordermentum.

  2. Remove special characters (e.g., Café → Cafe).

  3. Re-sync affected orders.


5. The Customer cannot be changed for an existing invoice

Reason:

  • An invoice exists under a different customer, or

  • Customer record was changed/merged in MYOB.

How to fix:

  1. Check MYOB for duplicate invoices with the same reference.

  2. Delete or fix duplicates.

  3. Update customer details in MYOB if needed.

  4. Re-sync the invoice.


6. Income Account XXXX not found

Reason: Ordermentum tries to sync a product, but the sales (income) account code does not match MYOB.

How to fix:

  1. Confirm the correct income/sales account in MYOB.

  2. Update the sales code in Ordermentum or MYOB to match exactly.

  3. Re-sync the invoice.


7. Cannot convert ‘Closed’ to a valid value

Reason: The invoice in MYOB has a status Ordermentum cannot update (e.g., Closed, Converted, Deleted).

How to fix:

  1. Open the invoice in MYOB.

  2. Edit the invoice status.

  3. Re-sync from Ordermentum if needed.


8. Company file is read-only

Reason: Ordermentum cannot access the MYOB company file due to changed user access or file location (MYOB Desktop).

How to fix:

  1. Confirm MYOB user credentials.

  2. Ensure the company file location is correct.

  3. Reconnect the integration in Ordermentum if required.


9. Insufficient item quantity to complete transaction

Reason: Not enough stock exists to sync Sales Orders.

How to fix:
Option 1: Add inventory in MYOB

  • Update stock for affected products.

  • Edit and save the order in Ordermentum to re-sync.

Option 2: Sync as invoices instead of orders

  • Go to Integration Settings in Ordermentum.

  • Change MYOB sync type to Invoices.


10. IncomeAccountFreight Linked Account is required if charging freight

Reason: MYOB requires a Freight item and linked income account for invoices with freight charges.

How to fix:
Step 1: Create a Freight Item in MYOB

  • Products & Services > Create Item

  • Name: Freight

  • Item ID: FREIGHT or DELIVERY

  • Description: Delivery charge

  • Tax Code: GST or FRE

Step 2: Assign a Freight Income Account

  • Go to Accounting > Managed Link Categories

  • Review or create a suitable Income account

  • Assign the account to the Freight item

  • Save changes

• Consult your accountant for correct tax codes.

For additional guidance, please refer to this video.


Unable to Create Invoice – MYOB Account

Reason

This error occurs when MYOB cannot create an invoice due to line item validation issues.


While a Sales Code mismatch is the most common cause, this error can also occur due to inventory or stock configuration issues in MYOB.

MYOB requires every invoice line item to reference a valid sales code and meet all product validation rules.

How to Fix

Step 1: Check for Sales Code mismatches

  • Compare the Sales Code for each line item in Ordermentum and MYOB.

  • Ensure the codes match exactly, including spelling and formatting.

Step 2: Correct any differences

  • Identify mismatched Sales Codes (most commonly found in Ordermentum product settings).

  • Update the line items so the Sales Codes match MYOB.

  • Save your changes.

Step 3: Re-sync the invoice

  • Click Resync in Ordermentum to push the invoice to MYOB again.

Other Possible Causes

This error may also occur if:

  • Products are set as Inventoried items in MYOB

  • There is insufficient item quantity available

  • MYOB product or account settings prevent invoice creation

Because the root cause can vary, this error sometimes requires further investigation.


12. Unable to Find Account in MYOB Business

Reason

This error occurs when invoices with surcharge fees cannot be created because the corresponding surcharge item does not exist in MYOB.

How to fix

Step 1: Create a Surcharge Item in MYOB

  1. In MYOB, navigate to Items or Products & Services (or Inventory > Items in some versions).

  2. Click Create Item or New Item.

  3. Fill out the item details:

    • Item Number: e.g., SUR001

    • Item Name: e.g., Surcharge Fee

    • Description: e.g., Ordermentum Surcharge

    • Income Account: Assign to the correct income account (e.g., 4-1010)

    • Tax Code: e.g., GST or FRE, depending on your setup

    • Ensure I Sell This Item is enabled.

  4. Click Save.

Step 2: Re-sync invoices

  • Once the surcharge item is created, invoices with surcharge fees can be successfully synced to MYOB.


FAQs

Q: Can I manually trigger a sync?
A: Yes, click the Resync button in Ordermentum. See: Using Resync & Mark as Resolved.

Q: The SKU matches in both MYOB and Ordermentum, but the invoice still won’t sync. Why?
A: Paid invoices cannot be re-synced. Manual entry in MYOB is required.

Q: How do I update the invoice date on a paid invoice?
A: Refer to: How to Change the Delivery Date, Due Date, and Invoice Date of an Order.


Need More Help?

  • Use the Help chat in the bottom-right corner of Ordermentum

  • Support hours: Monday–Friday, 9am–5pm AEST

Did this answer your question?