Experiencing same error while trying to create Item Receipt from a Transfer Order in NetSuite
This is the error message I get
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.
I have followed some other posts and tried everything but netsuite seems to not like my mapping. Here is a screenshot of my current mapping and I even tried finding existing lines using my item sku name.
0
Comments
Can you post a picture of your lookup definition? Did you select the option to "Use as a key field to find existing lines" That has to be used. It appears that the import isn't finding existing lines. Can you also post the request details from the error log??
Hey David,
Yes below is my lookup definition.
importing record:
{"nlobjRecordType":"itemreceipt","nlobjFieldIds":{"internalid":"","celigo_nlobjTransformId":6223252,"custbody_celigo_amzio_accounts":1},"nlobjSublistIds":{"item":{"lines":[{"item":"WB-10LBS-Gray","quantity":4,"itemreceive":"true"},{"item":"WB-10LBS-White-Gray","quantity":0,"itemreceive":"true"}]}},"documentIndex":0,"INTEGRATOR_IO_MAPPER":true}
nlapi calls registered for $R:
r = nlapiTransformRecord("transferorder", 6223252, "itemreceipt", {});
r.setFieldValue("custbody_celigo_amzio_accounts", 1);
r.setLineItemValue("item", "itemreceive", 1, "F");
r.selectNewLineItem("item");
r.setCurrentLineItemValue("item", "item", "WB-10LBS-Gray");
I believe I have figured it out however, I am wondering how I would handle a scenario when a couple items would not want to be received at all?
What do you mean, like they were already received? If this is the case and you still want your export data to drive the flow you need to lookup the transfer order lines, compare that with your source data and filter the data to only include valid lines that should be received.
Hello Ian,
I'm experiencing the same error, can you shed insight into how you got this to work?
Thank you.
Jason
Jason Ruiz Please provide the details of the error with screenshots masking any Personally Identifiable Information so that we can check as to the reason you are receiving this error. Also let us know whether you faced this error while running a custom flow or a flow using any Integration App.
Apologies for not circling back. The error I got was like the original poster "Failed to create, update/transform record because You have attempted an invalid sublist..."
I have determined that the reason why is because we were trying to create an Item Receipt for items that were currently being held by an Inbound Shipment Record. So, the error was because those items were not coming up as being able to be "received" on a PO.
So, we have abandoned this effort as we are using Inbound Shipment records.
Jason Ruiz Thanks for letting us know. Out of curiosity, are you using the Transfer Order (TO) - Shipment add-on of the Amazon - NetSuite integration app for getting the Inbound Shipment records or is this achieved via a custom flow?
Balasubramanian Mahadevan, apologies, we actually don't use Amazon at all, I stumbled upon this thread as I was trying to write a custom flow for Item Receipts.
No worries Jason Ruiz. I do hope you were able to achieve the result you were looking for. If not, do provide us the details of the issue and we will look into it for you.
Please sign in to leave a comment.