We're getting the following error every time Celig...
# ask-stanley-ai
a
We're getting the following error every time Celigo tries to have the "Celigo Realtime Import Restlet Runner" restlet create an Item Fulfillment: SSS_INVALID_SUBLIST_OPERATION: 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. This doesn't tell us much about what's going on or how to fix it. I can't think of why Celigo would try to alter a static sublist rather than altering the line items on the Items sublist of the Item Fulfillment record (which does not get created at all due to this error). That leaves an non-existent field being the culprit, but I can't figure out what it would be doing there either.
c
AI generated answer (using internal Slack threads):
Based on the conversations, the error
SSS_INVALID_SUBLIST_OPERATION
is thrown when you are trying to perform an operation on a non-existent line or trying to add or remove lines from a static sublist. Here are some possible solutions: 1. In the context of Celigo, make sure that you have correctly mapped the fields. In the settings of the item name mapping, check the box that says “use this field to find existing lines”. Also, set dynamic mode = T. You might also want to use LineID as the key and remove the Item Name (unless you're trying to update that as well). If it's an Import set as Update or Add/Update, you might not need the Internal ID mapping at the top as the 'How Can We Find Existing Records' will do that for you. 2. When transforming a Sales Order into Item Fulfillment and trying to remove some item lines, you cannot remove lines from a list type sublist like an item fulfillment. Instead of removing the lines, you can mark the ones you don't want as
itemreceive = false
. 3. If you are trying to un-assign items from a Merchandise Hierarchy in Celigo, you need to map a line reference as well. Otherwise, it will not identify which line to update. For example, you can use the Items : ID column to identify which line to update. Also, make sure you are using the correct record type in Celigo. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.881379426
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.873773932
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.868605852
Please provide your feedback on this answer.