Celigo flow to create Netsuite Deposit with Multiple CashSales

Integrator.io
,
1

Hi All,

I'm trying to create a Netsuite Deposit with multiple cash sales, and getting an Error, Invalid Sublitst

here is my data.

I tried removing the payments : Create Line, adding the cashsale id, nothing worked

Mappings

Screenshot 2026-04-16 at 5.01.11 PM
Screenshot 2026-04-16 at 5.01.11 PM2370×922 143 KB

Screenshot 2026-04-16 at 5.02.17 PM
Screenshot 2026-04-16 at 5.02.17 PM1596×1346 148 KB

Input

{
"data": [
{
"id": "51697001",
"type": "charge",
"varianceType": "Amount Mismatch",
"netsuiteTransaction": "Cash Sale #CS1679582",
"varianceAmount": 1102.95,
"deposit": "Deposit #DEP28054",
"salesOrder": "Sales Order #SO1313576",
"soInternalId": "51580940",
"cashSale": "CS1679909",
"varianceCashSale": "Cash Sale #CS1679909",
"csInternalId": "51584165",
"amount": 1095.95,
"scriptId": "VAL_148645237_4622610_SB1_457"
},
{
"id": "51697001",
"type": "charge",
"varianceType": "Amount Mismatch",
"netsuiteTransaction": "Cash Sale #CS1679475",
"varianceAmount": 344.46,
"deposit": "Deposit #DEP28054",
"salesOrder": "Sales Order #SO1313263",
"soInternalId": "51580813",
"cashSale": "CS1680018",
"varianceCashSale": "Cash Sale #CS1680018",
"csInternalId": "51584480",
"amount": 344.46,
"scriptId": "VAL_148645239_4622610_SB1_245"
},
{
"id": "51697001",
"type": "charge",
"varianceType": "Amount Mismatch",
"netsuiteTransaction": "Cash Sale #CS1679469",
"varianceAmount": 43.88,
"deposit": "Deposit #DEP28054",
"salesOrder": "Sales Order #SO1313173",
"soInternalId": "51580809",
"cashSale": "CS1679780",
"varianceCashSale": "Cash Sale #CS1679780",
"csInternalId": "51584030",
"amount": 44.51,
"scriptId": "VAL_148645240_4622610_SB1_393"
},
{
"id": "51697001",
"type": "charge",
"varianceType": "Amount Mismatch",
"netsuiteTransaction": "Cash Sale #CS1679408",
"varianceAmount": 297.27,
"deposit": "Deposit #DEP28054",
"salesOrder": "Sales Order #SO1313167",
"soInternalId": "51580746",
"cashSale": "CS1679938",
"varianceCashSale": "Cash Sale #CS1679938",
"csInternalId": "51584194",
"amount": 297.27,
"scriptId": "VAL_148645241_4622610_SB1_134"
}
]
}

Thanks

2

Hello Hemanth,

You can remove the "Payments : Create Line", at the minimum only "Payments : Number" and "Payments : Deposit" is needed to create a deposit. However, for the "Payments : Number" field, you need to enable the "Use as a key field to find existing lines".

image
image336×302 10.8 KB

When applying line items from a sublist, you just need to make sure that the key field is visible in the columns of the sublist record. Kindly edit the mapping settings for the Numbers field and enable it as key field.

image

Retry the error after making the adjustments and let me know.

3

Hey Ronnie

It worked.

Thanks

4

Hey Ronnie

I have another issue when creating the Deposit, there are more than 10,000 records for lookup, I know netsuite has a hard limitation when looking-up sublist more than 10,000 records, Is there any other way to insert a line instead of looking up ?

Error Details: 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.

Thanks

Hemanth