Skip to main content

Shopify Payout Reconciliation Addon - SSS_INVALID_SUBLIST_OPERATION

Comments

4 comments

  • Alex Placito NetSuite Integration Whiz
    Engaged
    Celigo University Level 4: Legendary

    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?

    0
  • KHAISAR AHMAD QA Lead

    Hello Alex Placito

    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,  

     
    
    
    0
  • Alex Placito NetSuite Integration Whiz
    Engaged
    Celigo University Level 4: Legendary

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

    0
  • Karen Finnsson

    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. 

    0

Please sign in to leave a comment.