MYOB not rejecting duplicate files when importing

Mathilda

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 issues from a few years back but it didn't really solve my problem.  I am on AccountRight 2020.2  Thanks in advance

Emily_B

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.