MYOB - Known Issues and Error Messages

Current known issues for MYOB Integration

  • For example, if a payment is taken for $600 but only $400 is allocated against Invoices then the credit for $200 is not exported because .
  • You will only get an error or exception when a Client has a duplicate ID number for an Invoice, Payment or Refund.

Error

Description

Action Required

Clients and Products

The first time Clients and Products are exported, the system does not refresh. Sales won't import because MYOB assumes that the Clients and Products aren't in MYOB.

Close the report and reopen to get the updated data.

Multiple Addresses

For clients with multiple addresses of one type, the first of these addresses will be selected.

If all the addresses are required, change the type of one of the addresses. Bp Allied allows for three different addresses for a Client.

Multiple Primary Email Addresses

Clients with multiple primary Email Addresses are shown multiple times.

These "Duplicate" rows must be selected and deleted from the output before export. Alternatively, untick Primary on one of the email addresses. Having two primary email addresses will cause issues with email reminders as the reminder will not send if there are two primary addresses.

Unallocated Credit Balances

Unallocated credit balances are not exported.

At this stage Bp Allied does not include the concept of Credit Notes. These balances cannot be exported to MYOB.

Duplicate Invoice, Payment or Refund Numbers

MYOB will allow duplicate numbers of invoice, payment or refunds, as long as the client the invoice is attached to is different.

You will only get an error or exception when a Client has a duplicate ID number for an Invoice, Payment or Refund. See MYOB - Changes to exported data and effect of MYOB settings

Index was out of range

If an individual item is deleted from an invoice that was previously exported to MYOB, and then the invoice is re-exported to MYOB, during export, BPA throws an error - Index was out of range.

Please update the Invoice manually in MYOB and report this issue to Bp Allied Support if the issue is a regular occurrence so we can review our API implementation.

Error Messages

IMPORTANT  All items must have a Unique Item Code in Bp Allied.  This is set in Data Maintenance > Product and Services.

Missing/Invalid Info

When running exports from Reports > Exports > MYOB Exports, the error Missing or Invalid Info may occur requesting additional information.

All Items must have a Unique Item Number

This is resolved by updating the Accounting Item Code field for the product highlighted in red on the report from Data Maintenance > Product and Services. The value must be unique.

The GST code(s) do not exist in MYOB, update GST Code(s)

This is resolved by updating the GST Code field for the product highlighted in red on the report, from Data Maintenance > Product and Services.

Duplicate Invoice Numbers

This error will occur if there are multiple invoices for the same client, with the same Invoice number, on the same date. One of the invoices will not transfer to MYOB as there is no unique identifier. Ensure all invoice numbers are unique for the client in Bp Allied.