nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Errors -4641 and 136 when importing receive payments files

D_Sydes

Hey,

I am trying to import lists of payments for invoices.

When I try to match customer by ID I get this error

Error -4641: ReceivePaymentEvent_LineSaleEventDoesNotBelongToCard

When I try to match customer by customer name I get

Error -136 The card attached to the invoice is not the same as the card attached to the payment

I have confirmed that I have the correct ID's and customer names, and indeed as part of the same import I had 38 apply correctly.

I've noticed that the only invoices that this issue happens with are ones where a different customer has been issued an invoice with the same invoice number.

It feels to me like MYOB is searching for the supplied invoice number, picking the first one, then checking that the customer of that invoice in MYOB matches the customer on the import file.

This is the log when I attempted to import a list of payments by customer ID

Has anyone else encountered this issue?

Find more posts tagged with

Accepted answers

D_Sydes

Update: I reached out via live chat and was helped out by Rhonna.

After she ran some diagnostics, we cleared the MYOB cache by deleting the companyFileCache file within -

Cache located in "C:\Users\<userName>\AppData\Local\MYOB\AccountRight\Current\Cache".

After this I tried importing again and happily was met with success!

Many thanks,

Dan

All comments

D_Sydes

I ran into this issue again, and after some testing I believe that the previous solutions aren't necessarily correct.

I think it was a coincidence that my problems were resolved, as just now I've encountered the same error and been unable to fix it using these methods.

However, I believe I have found the true solution.

The key to the fix is that column order matters on imports.

When I had the invoice number to the left of any of my customer identifier columns (I tried cardID, Co./Last Name, and Record), I would run into the error -4641.
But as I was testing different combinations, I happened to insert the Record column to the left of the existing columns, rather than appending it after the rightmost column.

I didn't expect this to work, as it was an edge case that I was trying to make sure I covered, and so I was surprised when I had the import succeed.

A couple more attempts and I had positive confirmation that whenever the invoice number column was first, the import would fail, and was attempting to match to another customer with the same invoice number (split billing).

But when a customer identifier was "scanned" first, it seems that MYOB "filters" the list of invoice numbers down to those relevant to the specific customer, before attempting to apply the payment.

My guess would be that this will hold true for all of the fields in the import used for identifying the open invoice, and that by having the date field ahead of the invoice number field one would be able to direct the import to apply payment to a specific invoice of a customer (assuming they had the same invoice name).

I have not tested this, however.

Good luck to anyone who reads this.

D_Sydes

Update: I reached out via live chat and was helped out by Rhonna.

After she ran some diagnostics, we cleared the MYOB cache by deleting the companyFileCache file within -

Cache located in "C:\Users\<userName>\AppData\Local\MYOB\AccountRight\Current\Cache".

After this I tried importing again and happily was met with success!

Many thanks,

Dan

D_Sydes

Hi Princess,

Thanks, I will reach out to the team directly.

This is the full error log with labelled fields. I don't know what the fields in columns B, E and I are, it looks like they're some kind of internal MYOB identifiers.

I was able to fix the error -250 by correcting the customer ID, but not the -4641s.

I have been using import templates with success, but I do not believe this to be a template issue.

Anyway, I will reach out to the team.

Princess_R

Hi @D_Sydes,

Thanks for checking out those imported details. The errors (Error -4641 and Error -136) you hit during the attempts to import payment lists, seem like they could be caused by the card details linked to the invoice and the payment info in the import file. As this needed a further look, your best bet would be to contact our team directly for more troubleshooting.

Yes, duplicate invoice numbers can mess up the matching process. The import log usually has all the details you need to figure out what’s going on with these errors or warnings. Check out this link for more info. And to make things easier, you could try using the import template, and it should help streamline the importing process.

Cheers,

Princess