Forum Discussion

Mathilda's avatar
Mathilda
Trusted User
5 years ago

MYOB not rejecting duplicate files when importing

Hi all, just wondering if there is a reason for my service Invoices getting duplicated when I import a batch, even though I selected "reject existing data".  I found one or two threads with the same ...
  • Emily_B's avatar
    Emily_B
    5 years ago

    Hello Mathilda 

     

    I'm sorry to hear this has been an issue for you. It has been reported occasionally that the 'Reject Duplicates' function is failing to identify said duplicates when importing. This is because that feature works by comparing transaction numbers which may already be in the system, and can fail on imports with ID numbers less than 8 digits (i.e., without leading zeros). 

     

    For example, if an invoice number is entered manually as 12345, AccountRight will prepend the number with zeros to make an 8 digit number ie: 00012345. However, if you are importing sales via the import function, those leading zeros to make an 8 digit number do not get added to invoices or transactions being imported which may have that 12345 ID.

     

    The workaround is to either ensure that invoices in AccountRight and those being imported contain 8 digits without leading zeros, to avoid the add/don't add leading zeros confusion in the import function. Alternatively, you could edit the ID numbers before importing, or edit the imported transactions. 

Emily_B's avatar
Emily_B
Former Staff
5 years ago

Hello Mathilda 

 

I'm sorry to hear this has been an issue for you. It has been reported occasionally that the 'Reject Duplicates' function is failing to identify said duplicates when importing. This is because that feature works by comparing transaction numbers which may already be in the system, and can fail on imports with ID numbers less than 8 digits (i.e., without leading zeros). 

 

For example, if an invoice number is entered manually as 12345, AccountRight will prepend the number with zeros to make an 8 digit number ie: 00012345. However, if you are importing sales via the import function, those leading zeros to make an 8 digit number do not get added to invoices or transactions being imported which may have that 12345 ID.

 

The workaround is to either ensure that invoices in AccountRight and those being imported contain 8 digits without leading zeros, to avoid the add/don't add leading zeros confusion in the import function. Alternatively, you could edit the ID numbers before importing, or edit the imported transactions. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.