Thursday, June 20, 2019

Apply Credit Memo via CSV Import Results In Error: Unable to find a matching line for sublist apply with key: [doc,line]

This error results when there are multiple invoice numbers being matched to a single credit memo. If the Invoice internal ID is listed multiple times, the CSV import would look for corresponding amounts for the other lines, which do not exist.

For example, let us assume that there are three items on the credit memo and it is being applied to a single invoice, a user may set up their CSV template with the following information:

Invoice Internal IDCredit Memo Internal IDCustomer NameAmount Applied
12345678John Smith300
                            12345678John Smith 
                            12345678John Smith 

However, this will generate the "Unable to find a matching line for sublist apply with key: [doc,line]" error.

Please modify the CSV template to reflect the following and resolve the error:

 

Invoice Internal ID

Credit Memo Internal IDCustomer NameAmount Applied
12345678John Smith300
 5678John Smith 
 5678John Smith 

Essentially, if the credit memo had 3 items on it, the internal ID and customer name should be listed 3 times. If 4 items on the credit memo, then the credit memo internal ID and customer name should be listed 4 times and so on. Since the invoice only has one line item, the invoice should only be listed once and the corresponding total amount being applied should be listed once as well.

No comments:

Post a Comment