Skip to main content

Troubleshoot MYOB error messages

Steps you can take to identify and fix errors when exporting bills from Lightyear to MYOB.

J
Written by Jessica Callaly

๐Ÿค“ Tip: If you have worked through all of these checks and the export is still failing, contact the support team.

Locked period error

You'll see this error "[[BusinessEvent_DateOccurred_InLockPeriod; DateOccurred:(PurchaseEvent); InventoryDateOccurred:(PurchaseEvent)]]" when you try to export a bill dated within a locked period in MYOB.

Check your MYOB file and ensure the bill date does not fall within a locked period. If it does, update the bill date before retrying the export.


Supplier card error

You'll see this error "[[UID/DisplayID not found; Supplier.UID/DisplayID]]" when there is an issue with the supplier card in MYOB. This can happen if a supplier card has been changed from a Company to an Individual, made inactive, or duplicated.

Important: Lightyear only imports and exports to supplier cards set up as a Company in MYOB.

To resolve this, follow the steps below.

  1. Click Accountancy Software Settings, then click Supplier Cards.

  2. Click Import from MYOB to refresh the supplier list.

  3. Check the list for duplicate supplier cards.

  4. If duplicates exist, delete both entries. This does not delete anything in MYOB.

  5. Click Import from MYOB again to bring through the latest records.

  6. Click the truck icon to open Suppliers, then find and select the affected supplier.

  7. Click Edit, reselect the correct accounting supplier card, then click Update.

  8. Retry the export.


GL code error

You'll see this error "[[The Account with UID of 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' cannot be found.; UID]]" when there is an issue with a GL code assigned to the bill. MYOB refers to GL codes as Accounts. The code may have been deleted, duplicated, or made inactive.

To resolve this, follow the steps below.

  1. Click Accountancy Software Settings, then click GL Codes.

  2. Click Import from MYOB to refresh the GL code list.

  3. Check the list for duplicate GL codes.

  4. If duplicates exist, mark one as In Use and the other as Not In Use.

  5. Go to Signed Off, then move the bill back to Review or Approvals.

  6. Amend the GL code on the bill, then retry the export.

If the error continues, return to the GL Codes list and mark the Not In Use code as In Use, then retry.


Due date error

You'll see this "[[Term_Out_Of_Range; NumberOfDaysForBalanceDue:(PurchaseEvent)]]" error when the due date on the bill is set before the bill date.

  1. Move the bill back to Review or Approvals.

  2. Update the due date so it falls after the bill date.

  3. Sign off the bill and retry the export.


Connection timeout error

You'll see this error "[[Connection to the API has timed out; Maximum call time is :120 Seconds]]" when Lightyear does not receive a response from MYOB within the two-minute connection window. This does not confirm whether the bill was exported successfully.

  1. Open your MYOB file and check whether the bills have arrived.

  2. If the bills are in MYOB, archive the documents in Lightyear instead of exporting again.

  3. If the bills are not in MYOB, refresh your browser page, then retry the export.

๐Ÿ“ŒNote: Refreshing your browser before retrying helps prevent duplicate entries.


Internal application error

You'll see this error "[Internal Application error: Please contact Technical Support]" when MYOB returns an unspecified failure during the export. Work through the checks below in order to identify the cause.

Check the MYOB connection

If the connection between Lightyear and MYOB is inactive, exports will fail. Only an Admin User can reconnect.

  1. Ask your Admin User to reconnect Lightyear to MYOB.

  2. Retry the export.

Check for special characters

The % symbol and other unsupported characters can cause export failures.

  1. Move the affected bills back to Review.

  2. Edit the description fields to remove any special characters.

  3. Retry the export. If the issue continues, try exporting using grouped line items instead of individual line items.

Check the bill data

Invalid data formats can prevent a successful export. Check the following on each affected bill.

  • The bill date is in a valid format.

  • The bill number is not an unusually long string of characters.

Amend any invalid data, then retry the export.

Check for duplicate bills

If MYOB is set to block duplicate bills, Lightyear cannot send a bill that already exists in MYOB.

  1. Check whether the bill has already been entered manually in MYOB.

  2. If the bill exists and you still need to export it, turn off the duplicate-bill setting in MYOB, then retry.

Check the GL code type

MYOB does not allow exports to Header Accounts via the API, even though Lightyear can display them.

  1. Check that the GL code selected on the bill is not a Header Account in MYOB.

  2. If it is, select a non-header GL code on the bill, then retry the export.

Check category assignments

You can only assign one Category per bill in MYOB. Assigning multiple categories across line items on the same bill will cause this error.

  1. Review the categories assigned across all line items on the bill.

  2. Set all line items to the same category.

  3. Retry the export.

Did this answer your question?