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 ID | Credit Memo Internal ID | Customer Name | Amount Applied |
1234 | 5678 | John Smith | 300 |
1234 | 5678 | John Smith | |
1234 | 5678 | John Smith |
Please modify the CSV template to reflect the following and resolve the error:
Invoice Internal ID | Credit Memo Internal ID | Customer Name | Amount Applied |
1234 | 5678 | John Smith | 300 |
5678 | John Smith | ||
5678 | John 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