Error code: sss_invalid_sublist_operation
Error message: "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. Settlement details: Settlement Id# 0123456789, Amazon AFN Order# 123-9999999-000000."
Reason: Settlement Payment flow creates Customer Payments in NetSuite via Transactions > Customer > Accept Customer payment. This page has a limit of 10,000 transactions. If the Invoice the Settlement is trying to pay does not show on this page, that is when you will see this error. Due to NetSuite limitation, customer payments can’t be applied against an invoice when the customer has more than 10000 open invoices.
Resolution:
-
Retry Data:
-
Click Retry Data in the settlement flow. This often resolves the error:
-
If the error persists, further checks are required:
-
Verify if the invoice is visible on the Customer Payment page or included in the 10,000 invoice limit.
-
If the invoice is not visible, identify why it is excluded or process visible invoices to free up space, allowing additional invoices to fall within the 10,000 limit.
-
-
You can also try the following steps to resolve the error:
-
Apply date range filters:
-
If the required invoice is not in the oldest or latest 10,000 invoices, apply a date range filter using the "From" and "To" date fields in the sublist to narrow down and locate the invoice.
-
-
Customize filter criteria:
-
Refine the sublist further by customizing filter criteria for better flexibility in locating invoices.
-
-
Ensure user/role consistency:
-
Confirm that the user/role modifying the sublist matches the user/role authorized for the flow connection to avoid permission-related issues.
-