I have installed and set up the Shopify Payout Reconciliation add-on as part of the Shopify - NetSuite Integration App.
The custom records are getting created with the correct values as expected, however the second flow to create deposits is failing with the following error:
{
"code": "SSS_INVALID_SUBLIST_OPERATION",
"message": "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."
}
I've attempted hard-coding the mapping on the flow to select the proper subsidiary and deposit account (I assume I should not have to do either though), to no avail.
I've confirmed that all of the default accounts in the settings for the Payout section are available to the subsidiary in question.
I've completed the Celigo University topic on Payouts as part of this Integration App's certification course.
What am I missing or what else should I try? I'm guessing there is some setting causing the issue, but I have no idea what it might be, and the error message is not particularly helpful in this instance.
I resolved this - the issue was that the form was defaulting a cash account for a different subsidiary, thereby defaulting the form's initial view to that of the other subsidiary. As such, none of the cash sales that Celigo found in NetSuite to match the Shopify Payout data could be selected, resulting in the SSS_INVALID_SUBLIST_OPERATION error, because the script was attempting to add a line to the sublist that didn't exist.
To resolve, I logged in to the UI as the user who was also tied to the NetSuite connection within the integration. I created a new Bank Deposit in the NetSuite UI, switching the account field to the one that I wanted the integration to use (thusly changing the subsidiary to the correct value as well). This caused the account to default as a "sticky" setting in NetSuite for the user, so that subsequent Deposits would default to this account/subsidiary combo.
I then deleted the Deposit and re-tried my errored flows; sure enough, they created the Deposit records this time.
The question to Celigo on this is: is there some mapping change or other setting that one could use to help this correctly create the Deposit? Shouldn't the script be adjusting the account/subsidiary value prior to attempting the sublist operations, since the sublist value options are so dependent on which subsidiary is selected?
Hello @alexplacito790
We can even try to add the respective mappings for the flow "Shopify Payout Transactions to NetSuite Deposit" in the "Post deposits to NetSuite" adapter. The mappings will replicate the same operation as you did manually on NetSuite. And this mapping will also ensure the correct deposit record creation irrespective the default form on NetSuite. You can as well try this once and let us know for anything.
Thanks,
@khaisarahamad thanks, but please note that I did say I tried this in my original post, and it did not work:
"I've attempted hard-coding the mapping on the flow to select the proper subsidiary and deposit account (I assume I should not have to do either though), to no avail."
Hi Alex, did you manage to find a solution to the sticky feature happening in Deposit form? We are also experiencing the same error and can't think of any solution at the moment.
You can mark the field Account as "initialize netsuite record" which resolved the issue for me.
