Hi Komal_S,
Definite progress!
Using the template you attached, I can now import a single transactions to that test account.
I have now tried creating a batch, using that template, but it now fails with a new error:
Error -136: The card attached to the invoice is not the same as the card attached to the payment.
I have attached the logfile and import file to this message.
To check whether the invoice and CardID match, in MYOB AccountRight, I went:
Sales - Sales Register
Enter '31031' (without the quotes) into the search box, and the invoice pops up.
I then opened the invoice, and clicked the blue arrow beside the customer name
The customer card opened, and I can confirm the CardID is '307521' (without the quotes)
I checked that there was nothing else in the CardID (leading or trailing spaces for example), but that field definitely only contains those six numerics.
To be absolutely certain, I did an export of all customer cards, and checked the CardID of that customer, and it is exactly those six numeric characters.
I also did a seach in case two customers have the same ID, but there is no other incidence of 307521 in the customer card export file.
This occurs on the very first import line. Now, that could be a spectacular coincidence, so I deleted that line from the import file, and tried again. This time it errored on the (new) first line item.
I have also run a sales report, to check that the invoice number 31031 is not duplicated, and can confirm that even if I export from 1 Jan 2011 to 30 Apr 2020, that invoice only appears once.
The error message appears to be at odds with the evidence :-)
Where do I go from here?
Thanks,
Alan.