Error 136 when importing payments

Question

Hi friends,&nbsp;So I'm trying to import some receiving payments records. However, when I tried to import the whole data set, I've got an error as follows:&nbsp;Error -136: The card attached to the invoice is not the same as the card attached to the payment.&nbsp;Being curious, I tried to import just one entry of the data and it worked (1 data imported with a warning, duplicate ID). The warning is there because I wanted to import the whole data under the same ID. Despite the warning, it was still imported. So I'm not sure why it didn't work when I tried to import the whole thing at once.&nbsp;Any help will be appreciated, I'm new to this.Thank you very much.

komal_s · Answer

Hi&nbsp;keziapm&nbsp;Are you matching the records by Co./Last Name or by Card Id, Record ID?
&nbsp;
This is because in the AccountRight validation information for importing information, the Co/Last name field is a validating field, so if you include it in an import then the information in that field has to correspond exactly to a matching card in AccountRight customer cards.
&nbsp;
When you are importing the invoices, you do not have to match up the Co/last Name field if you are matching through the Card ID field, and vice versa. It is possible to unselect the fields you're not using for matching before importing the file.
&nbsp;
Please feel free to post any other questions that you may have.

keziapm · Answer

Hi&nbsp;Komal_S&nbsp;&nbsp;Thank you for your reply.&nbsp;I'm matching only by Company Name, I'm not inputting any card ID.&nbsp;My import file only consists of the following entries:- Deposit account- ID number- Date- Company name- Payment method- Memo- Amount applied- Invoice number&nbsp;&nbsp;

gavin12345 · Answer

Hi&nbsp;keziapm&nbsp;&nbsp;If you have 2 cards with the same Company Name, this can cause this error as MYOB might be using the wrong card.&nbsp;RegardsGavin

keziapm · Answer

Hi&nbsp;gavin12345&nbsp;,&nbsp;Thank you for your reply.I have been inputting the entries manually since I couldn't figure out how to get the import to the receiving payments.&nbsp;When I input them manually, I have never been asked about the details for the cards, I only put it information regarding:- customer name- amt received- payment method- memo- ID #- date- invoice #&nbsp;But anyway, I also checked the customers' cards list and I didn't find any duplicates, all customers only have 1 card.&nbsp;Can you help me out with this?Thank you very much

gavin12345 · Answer

Hi&nbsp;keziapm&nbsp;&nbsp;When you Receive Payments manually you select the Customer from a list - MYOB will use that Customer.&nbsp;&nbsp;When you import, you would assume MYOB identifies the Customer Card based on the customer name you provide. What you will likely find is that MYOB finds the first Card with that name (and it might be a Supplier Card).&nbsp;&nbsp;Note my earlier question was if you have 2 cards with the same Company Name, not if you have 2 Customer Cards with the same Company Name.&nbsp;RegardsGavin

Forum Discussion

Error 136 when importing payments

9 Replies

Related content

Payment receipt import error

Importing Error 4077

Import timesheet error

Error 4077 - Import / Export

Import Item Error

AccountRight Import Error

Importing data error 4077

Import Error - 19 - Unbalanced Transaction