Celigo flow to create Netsuite Deposit with Multiple CashSales

[HK1999 (Hemanth Kumar)]

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

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

[ronniedeguzman32 (Ronnie De Guzman)]

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".

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.

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