Using CSV and JSON files, how can I do item fulfillment for the same item with multiple lot numbers, meaning more than one Inventory Detail for the same item (by processing multiple lines for the same sales order)?
To answer your question regarding multiple lines with the same item, this is possible, but you have to provide a unique key field to identify matching lines to fulfill. Since item name is duplicated, the flow will error. It's common to use the NetSuite "Line ID" to match on fulfillment lines, which is guaranteed to be unique.
At a high level, the invalid sublist error is caused by an invalid operation occurring on either one of your item mappings, or one of your inventory detail mappings. To troubleshoot this, check the original Sales Order in NetSuite, and ensure each line and inventory detail matches the fulfillment data that you are using. This error will occur if a line is attempted to be fulfilled that cannot be fulfilled for whatever reason, or fulfillment of a wrong or mismatched item.
The connector (also known as an adaptor) should automatically convert the CSV data to JSON, and you should be able to preview it either from the transform mappings or the JS preSavePage preview. You shouldn't need extra code to convert CSV to JSON.
1) Upload sample CSV file so that Sample Data shows below:
2) Click into Transform mappings or PreSavePage hook to preview the converted JSON data:
Note that the format of the converted JSON will depend on your export configurations.
Let us know if this works for you and if we can improve this answer!
Please sign in to leave a comment.