IMPORTING RECEIVE PAYMENT ERRORS

Question

Hi there,&nbsp;Until recently we have been able to bulk import customer payments.&nbsp;&nbsp;The import when selecting "if the data exists" add import data. But it does not bring in the whole invoice number with the a on the end.&nbsp;&nbsp;Now we are getting an error -132&nbsp; Invoice # not found. (due to the a not being present)&nbsp;When the invoice clearly is in myob, and matches the import.&nbsp;&nbsp;In the import log it is showing the invoice number without the a on the end as per the import. Why is this happening?&nbsp;Please help urgently as we import up to 200 payments per day and this is now taking us hours to do manually.&nbsp;Emma&nbsp;Attachments- invoice showing open in receive payments window- example of import sheet- import log&nbsp;

emma1201 · Answer

Also note, the above method was to choose

If the data already exists "add the import data"

___

When you choose to

If the data already exists "reject the import data"

It skips with this error

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

BUT NOTE the a on the end of the invoice number is shown in this scenario.

mike_james · Answer

Hi&nbsp;Emma1201&nbsp;, I note that the invoice number quoted in the log (OMI11357) is short by one character. The import process requires invoice numbers to be a maximum of 8 characters, which was the largest invoice number allowed for a long time.&nbsp;This help topic confirms it:https://help.myob.com/wiki/display/ar/Import+and+export+fields#expand-Receivepayments

emma1201 · Answer

Oh that makes alot of sense.&nbsp;&nbsp;Is there any function to allow a 9 character invoice import?&nbsp;Its just that we have a few hundred already in... and need to import their payments.&nbsp;&nbsp;OR- do you know of a way to edit bulk invoice numbers? eg maybe we can bulk take the a off the end of a group of them?&nbsp;Thanks for the speedy reply :)&nbsp;Emma

earl_hd · Answer

Hi Emma1201,Thanks for your post and my apologies for the late response. At the moment, updating invoice numbers in bulk via the import function isn't possible. Editing past invoices will need to be done manually. For future invoices starting with "0000," inputting at least one invoice with a number beginning with "0000" will establish the sequence for consecutive numbers.Feel free to post again, we're happy to help!Regards,Earl

Forum Discussion

IMPORTING RECEIVE PAYMENT ERRORS

Looking for something else?

Related content

Error 136 when attempting import in Receive Payments

BPAY PAYMENT NOT RECEIVED

Receive payments

Payment receipt import error

Receiving error when recording payment

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

Super payment not received by employee's fund

monthly statements not showing payments received