When the Amazon Delivered Shipments to NetSuite Item Receipt flow runs against a Transfer Order that has multiple FBA shipments, the Post Item Receipt to NetSuite import may fail with an SSS_INVALID_SUBLIST_OPERATION error. This article explains the cause and how to resolve it by updating the Item Receipt import mapping.
This applies to users of the Amazon – NetSuite integration app with the Transfer Order Add-on.
Symptoms
The flow fails at the Post Item Receipt to NetSuite import with the following error:
Error 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.
- Failed to add Item Receipt record for FBA Shipment Id# [ID], Transfer Order# [number]. Failed to save record because The number of serial numbers entered (10) is not equal to the item quantity (5)
You may also notice:
- Item Receipts are created successfully for some FBA shipments on a Transfer Order but fail for others on the same Transfer Order.
- The entire Item Receipt record fails, and no partial receipt is created.
Cause
The flow initializes the Item Receipt transform directly from the Transfer Order record. When a single Transfer Order has multiple FBA shipments (and therefore multiple Item Fulfillments), NetSuite can't determine which specific Item Fulfillment's lines to mark as received. NetSuite rejects any attempt to modify the static sublist and throws SSS_INVALID_SUBLIST_OPERATION.
This is a NetSuite behavior requirement, not a Celigo product defect. In the NetSuite UI, when you select Receive on a Transfer Order that has multiple Item Fulfillments, NetSuite prompts you to select the specific Item Fulfillment to receive from. The flow must replicate this behavior by resolving the correct Item Fulfillment record and initializing the transform from it.
Resolution
Add a lookup mapping on the Item Fulfillment (InternalId) field in the Item Receipt import and enable Use this field for NetSuite record initialization. This resolves the specific Item Fulfillment linked to the current FBA shipment ID and uses it to initialize the NetSuite transform.
Configure the Item Receipt mapping
- Open the Amazon Delivered Shipments to NetSuite Item Receipt flow.
- Select the Post Item Receipt to NetSuite import.
- Go to the Mapping tab.
- Locate or add the Item Fulfillment (InternalId) destination field.
- Open the field settings and set Field mapping type to Lookup.
- Under Options, select Dynamic: NetSuite search.
- Set Search record type to Item Fulfillment.
- Add the following filters:
- Celigo Amazon Inbound Shipment Id is ShipmentId
- Main Line is T
- Select Use this field for NetSuite record initialization.
- Set Result field to Internal Id.
- Set Name (lookup name) to something identifiable, for example itemFulfillmentLookup.
- Select Save.
- Retry the failed records from the flow's error page.
Note: If some Item Receipts were already created before you apply this fix, delete all of them in NetSuite first. Once deleted, run the flow again and retry the failed records to ensure all Item Receipts are created correctly.
Prevention
This configuration is required whenever a Transfer Order is associated with more than one FBA shipment (and therefore more than one Item Fulfillment). If you routinely create Transfer Orders that split across multiple Amazon inbound shipments, apply this mapping during initial flow setup rather than waiting for errors to occur.