# Customer Payments import, **URL:** \ **Category:** Integrator.io\ **Tags:** error-handling, import, netsuite\ **Created:** [January 26, 2021, 6:53am UTC](https://connective.celigo.com/t/customer-payments-import/1217 "2021-01-26T06:53:47Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![tjtyrrell](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tjtyrrell/32/4441_2.png) [@tjtyrrell](https://connective.celigo.com/u/tjtyrrell)\ **Post date:** [January 26, 2021, 6:53am UTC](https://connective.celigo.com/t/customer-payments-import/1217/1 "2021-01-26T06:53:47Z")
Hello, I am trying to import Customer Deposits but keep getting the wonderful new error: > Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record. What are the tricks when bringing in Customer Payments against existing invoices? We are trying to reconcile from a payment gateway. Scenario: - Invoices exist under the correct customer (when manually trying to enter the payment, we see the list of all open invoices) - Invoice IDs (Ref #) are properly identified in the source system - No Subsidiary / currency errors I guess the main question is: How do I map the transaction against the correct invoice to apply against? Thank you, TJ ---
**Author:** ![courtneyjordan](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@courtneyjordan](https://connective.celigo.com/u/courtneyjordan)\ **Post date:** [January 26, 2021, 1:38pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/2 "2021-01-26T13:38:50Z")
Hi @tjtyrrell, Could you provide more information on your integration - what applications are you using? Thanks! ---
**Author:** ![tjtyrrell](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tjtyrrell/32/4441_2.png) [@tjtyrrell](https://connective.celigo.com/u/tjtyrrell)\ **Post date:** [January 26, 2021, 6:03pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/3 "2021-01-26T18:03:35Z")
Hello again, Courtney! Thank you for reaching out. Source Application is MS SQL, it has a payment record stored in the DB and we want to take that data and create a Customer Payment record against existing Invoices in NetSuite. ---
**Author:** ![courtneyjordan](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@courtneyjordan](https://connective.celigo.com/u/courtneyjordan)\ **Post date:** [January 26, 2021, 6:32pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/4 "2021-01-26T18:32:59Z")
Hello again to you @tjtyrrell :), I'm checking on this and will get back to you as soon as possible. ---
**Author:** ![tjtyrrell](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tjtyrrell/32/4441_2.png) [@tjtyrrell](https://connective.celigo.com/u/tjtyrrell)\ **Post date:** [January 27, 2021, 6:43am UTC](https://connective.celigo.com/t/customer-payments-import/1217/5 "2021-01-27T06:43:47Z")
I had made some progress (I thought) after joining an office hours, but then the old error started coming back up and I can't figure out where my progress went :( ---
**Author:** ![courtneyjordan](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@courtneyjordan](https://connective.celigo.com/u/courtneyjordan)\ **Post date:** [February 19, 2021, 6:04pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/6 "2021-02-19T18:04:40Z")
Hi @tjtyrrell, I'm sorry to hear that. Have you gained back your progress yet with working with office hours experts? If you've found something that works, we'd love it if you'd share it with us! ---
**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\ **Post date:** [February 19, 2021, 9:53pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/7 "2021-02-19T21:53:14Z")
Hi @tjtyrrell, One of our internal experts suggests: 1. Go into the options for the mapping and check "Use as a key field to find existing lines" for the Document Number field. The document number you populate here will identify the line. 2. Add a mapping to the Apply field to set it to a hardcoded true. Let us know how that goes for you! ---
**Author:** ![jonureta](https://avatars.discourse-cdn.com/v4/letter/j/edb3f5/32.png) [@jonureta](https://connective.celigo.com/u/jonureta)\ **Post date:** [October 23, 2021, 9:03pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/8 "2021-10-23T21:03:12Z")
Hi All, Can you share how this is done? ---
**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\ **Post date:** [October 25, 2021, 4:54pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/9 "2021-10-25T16:54:31Z")
Hi @jonureta - I wanted to make sure you saw this recommendation in case you haven't tried it: 1. Go into the options for the mapping and check "Use as a key field to find existing lines" for the Document Number field. The document number you populate here will identify the line. 2. Add a mapping to the Apply field to set it to a hardcoded true. Also, signing up for an [Office Hours](https://docs.celigo.com/hc/en-us/articles/360045798291-Which-Office-Hours-session-should-I-attend-) session with one of our solutions consultants may be an option for you. Thanks, Kate ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [December 27, 2022, 6:16pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/10 "2022-12-27T18:16:27Z")
Here is an example mapping setup for future reference: ![5301043caa20740200000001-ab6c0e4eb4b44b709def90adafd0b485.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/2674eb02fc1f07706546083886d32023e7266a2d.png) ![5301043caa20740200000001-80b71544828d45eabf60f1fcec88fb45.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0c787cb4a7605bafd6e6d5efe2bb6f57e5b01832.png) ---
**Author:** ![arthurdeoliveira](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@arthurdeoliveira](https://connective.celigo.com/u/arthurdeoliveira)\ **Post date:** [September 18, 2023, 3:24am UTC](https://connective.celigo.com/t/customer-payments-import/1217/11 "2023-09-18T03:24:40Z")
Hello I am trying a similar import using the Deposit Application record type but following the prompts above to find the sublist records to be applied. The customer deposit application works similar to the customer payment in the UI. I have mapped the fields as follows: ![5301043caa20740200000001-abe0c185933944df99c8f7221ab39a6d.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/9f1d4767debc8bf6dab4aa08282a1c17032bb1ff.png) And my import csv file looks like this: ![5301043caa20740200000001-372e7ff95bc14a26a9c3caf51dabd729.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0b1c4689ef0754196777b7b82841d8078cc415c2.png) The customer deposit that I am trying to apply and the invoices all exists in NetSuite. I have also tried by using the Ref# as above instead of the "Invoices : Hidden (Field ID: internalid)" but still getting the same error, and also using the option "Use as a key field to find existing lines" My error is: _Failed to create, update/transform record because You have attempted an invalid sublist or line-item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record._ _P.S - the function type is ADD and I have the setting to group records by deposit ID._ Any pointers would be greatly appreciated! A.O. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [September 22, 2023, 2:41pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/12 "2023-09-22T14:41:33Z")
@arthurdeoliveira can you try to map "use dynamic mode" as shown in example? ---
**Author:** ![steveboot](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@steveboot](https://connective.celigo.com/u/steveboot)\ **Post date:** [October 18, 2023, 11:03am UTC](https://connective.celigo.com/t/customer-payments-import/1217/13 "2023-10-18T11:03:12Z")
If you have more than 10,000 Invoices in the "Apply" sublist, any Invoices outside of this range may fail to be applied on Customer Payments you're trying to create. This seems to be a current limitation of NetSuite. As a workaround, please ensure that there are less than 10,000 Invoices in the sublist to be sure that the import step successfully finds the Invoice line you want to apply. Otherwise, you may have to create the Customer Payments for these manually. ---
**Author:** ![balasubramanianmahad](https://avatars.discourse-cdn.com/v4/letter/b/76d3ee/32.png) [@balasubramanianmahad](https://connective.celigo.com/u/balasubramanianmahad)\ **Post date:** [October 18, 2023, 9:22pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/14 "2023-10-18T21:22:15Z")
@steveboot Thanks for providing the workaround. This will prove useful for other users. ---
**Author:** ![sahithyarupa](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahithyarupa](https://connective.celigo.com/u/sahithyarupa)\ **Post date:** [March 17, 2024, 2:34am UTC](https://connective.celigo.com/t/customer-payments-import/1217/15 "2024-03-17T02:34:17Z")
@arthurdeoliveira I am facing the same issue while creating Deposit Application. Did you find a solution? ---
**Author:** ![sheerazshaik](https://avatars.discourse-cdn.com/v4/letter/s/a183cd/32.png) [@sheerazshaik](https://connective.celigo.com/u/sheerazshaik)\ **Post date:** [August 13, 2024, 10:36pm UTC](https://connective.celigo.com/t/customer-payments-import/1217/16 "2024-08-13T22:36:25Z")
@arthurdeoliveira Hello , we are trying to upload deposits via csv. can you please provide some inputs on that . Thanks