Mapping Items for Netsuite Item Receipt
Hello,
I need to make an update for Item Receipt in NetSuite where it updates the quantity of one of the line items and doesn't change the others but when I run the flow it updates all of the lines and closes the Purchase Order. Here are picture of how my import is setup, how I map the data and the data from NetSuite about the Purchase Order:
-
If you want to update a line on a record in NetSuite, you can use mapping like this:
So you'll need to source the Line ID from a saved search coming out of NetSuite first. I hope that helps.
0 -
Hi Cory,
I tried mapping the Line ID instead of the Items : Item (Field ID: itemkey) field but it still updated all of the lines.
Thanks
0 -
Hi Guys
I'm having a similar issue:
If I select a field that is the same on every row of the file in "Group records by fields" in the Data Loader then only the first row gets processed (i.e. if there are ten rows each representing an item that needs to be received only the first item will get received)
If I don't perform this grouping then the whole PO gets received
What I want is for only the items that are in the CSV file that I'm uploading to get received.
Here are my mappings at the import step:
Any help greatly appreciated!
0 -
This is a really common use case, and there is def a way to do it; but it is difficult to say why it is not working for your flow and/or CSV file. You might want to get some quick help from support.
The only idea I have from the pics above is to try setting "Items: Replace All Lines" to true.
You might also find something useful in this post.
Good luck!
0 -
Thanks Scott. That worked like a charm!
For anyone else reading this, you also need to group the import by a field that is the same on every row (I used internal ID) to get it to import correctly.
0
Please sign in to leave a comment.
Comments
5 comments