Spend Money Import Error - "sequence contains no matching element"

Question

Hello,&nbsp;I've succesfully been able to import Receive Money documents using CSV text file.On import I enabled "Reject the import data" for duplicate handling option.I followed a similar approach for Spend Money but it always gives me this:&nbsp;Summary of errorsError 0: Unexpected import error - Sequence contains no matching element&nbsp;To prove that this doesn't work, i did an export first, which picked up an entry that was manually entered.I editted the result and changed the date to today.Next I tried to import the data file with all fields matched except the following:Cheque No., Currency Code, Exchange Rate&nbsp;The import fails with the sequence error.&nbsp;&nbsp;I found that not changing the duplicate handling option to "Reject the import data" but leaving the default "Add the import data" results in the import being successful. So the issue has to do with this feature. I would like duplicates to be rejected but it looks like there's some issue with that feature for importing Spend Money.&nbsp;I am using AccountRight Premier AU 2023.9.0, build 2023.9.1.7

earl_hd · Answer

Hi RoyceLithgo,Thank you so much for your post and welcome to the Community Forum!I'm sorry for the delay in response. Other users have managed to resolve this issue. It seems that the presence of " " in the memo is causing the import to fail. Removing these symbols should help the import process run smoothly. Please remember to select "Add the import data" in the import export assistant and back up your file to prevent any chance of importing duplicates. If you opt for "Reject the import data," it might result in an "Error 0: Unexpected import error - Sequence contains no matching element."
&nbsp;

&nbsp;
I've included a sample import file for your reference. Please let me know how it works for you.Regards,Earl

roycelithgo · Answer

Hi Earl,&nbsp;Thanks for your response. However, the point I was trying to make is that there is a problem in the application when you select "Reject the import data" it gives the sequence error. That error indicates a coding issue.&nbsp;&nbsp;I was able to use the Reject option with the Receive Money function also. It's only Spend Money that has this issue.&nbsp;Regards,Royce.

earl_hd · Answer

Hi RoyceLithgo,Thank you for confirming and my apologies for the late response. When importing Spend Money, there are 3 crucial fields that need to contain valid information:

Cheque Account
 Allocation Account No.
 Amount

It seems these fields might be causing the error. To guide you through this, I suggest reviewing our Help Article, which provides detailed information about the necessary fields for importing. You can find it under "Import and export fields."
&nbsp;
Please do let me know how you go on this.Regards,Earl

roycelithgo · Answer

Earl,&nbsp;Please read this carefully:&nbsp;The import works fine if I leave the duplicate checking set to "Add the import data".If I set that field to "Reject the import data", I get this error:Error 0: Unexpected import error - Sequence contains no matching elementYour responses aren't very helpful as you keep suggesting there is an issue in the import file when clearly that is not the case. There is an issue in the application which the dev team needs to resolve.&nbsp;&nbsp;"Reject the import data" works fine with Receive Money import. It does not work with Spend Money.Suggest you test it yourself so you can see the issue.&nbsp;&nbsp;

Forum Discussion

Spend Money Import Error - "sequence contains no matching element"

4 Replies

Related content

Does the leave transaction report contain 8% of holiday pay?

Individual invoice and quote number sequences

Unable to import order data containing more than 10 lines

Taxable payments annual reports contain contractors' bank account details

Quotes: Different number sequence than invoice number

Quote and Invoices to have different numbering sequence

Invoice and Quote number sequences

Import - Receive Payments - Error 0: Unexpected import error - Sequence contains no matching element