Hello guys.
Trying to integrate with netsuite and ...
# suitetalkapis
Sahar Turgeman
10/05/2021, 12:02 PMHello guys.
Trying to integrate with netsuite and currently I cannot send a successful inventoryAdjustment request through postman.
This is the one of the error's I am getting: "Error while accessing a resource. You have entered an Invalid Field Value 1074 for the following field: item." (I made sure that this is the id).
Perhaps my request's body is wrong.
Any help will be much appreciated.
b
battk
10/05/2021, 12:08 PMthe usual answer is to make the same record in the ui and set the exact same fields you set in the ui
battk
10/05/2021, 12:09 PMuse the same user/role that your integration uses so you are under the same permission and classification restrictions
s
Sahar Turgeman
10/05/2021, 2:34 PMthank you for the reply, this is my body for the request (it doesn't work).
{
"inventory": {
"id": "3679539",
"AdjustmentAccount": {
"id": "1371"
},
"memo": "blah blah",
"items": [
{
"subsidiary": {
"id": "1",
"refName": "Trafilea Group Inc."
},
"item": {
"id": "1074"
},
"adjustQtyBy": 33.0,
"location": {
"id": "407"
}
}
]
}
}
Sahar Turgeman
10/05/2021, 2:34 PMthis is the error:
"detail": "Error while accessing a resource. You have entered an Invalid Field Value 1074 for the following field: item."
c
CD
10/05/2021, 3:14 PMDid the UI test succeed?
s
Sahar Turgeman
10/05/2021, 3:15 PMif you are asking if I can create a new inventory adjustment through the ui then the answer is yes.
b
battk
10/05/2021, 8:05 PMthat is a very weird looking body
battk
10/05/2021, 8:08 PMbattk
10/05/2021, 8:08 PMto see what your request should look like
battk
10/05/2021, 8:09 PMa quick glance at the body suggests that you are mixing up body fields and sublist fields
battk
10/05/2021, 8:09 PMand are guessing at what the field ids should be
s
Sahar Turgeman
10/06/2021, 10:23 AMI went with your directions (using swagger) I tried to post a new inventory adjustment and I'm still getting the same error:
"Error while accessing a resource. You have entered an Invalid Field Value 1074 for the following field: item."
Sahar Turgeman
10/06/2021, 10:25 AMthis is the body that I used:
{
"id": "3679539",
"inventory": {
"items": [
{
"quantityOnHand": 66,
"adjustQtyBy": 21,
"avgunitcost": 99,
"newQuantity": 357,
"memo": "History is written by the victor",
"item": {
"id": "1074"
},
"location": {
"id": "407"
}
}
]
}
}
b
battk
10/06/2021, 10:59 AMmake a list of the fields that you set in the ui and the internal ids for the select type fields
battk
10/06/2021, 11:00 AMset those same fields and the same values
battk
10/06/2021, 11:00 AMI heavily recommend not trying to set fields that you didnt set in the ui
battk
10/06/2021, 11:02 AMim basically saying the same thing again since i can tell that you are missing at least one field that is mandatory in the ui
battk
10/06/2021, 11:02 AMand you are probably missing another depending on which edition of netsuite you have running
s
Sahar Turgeman
10/07/2021, 11:40 AMthank you for your help, I managed to post a new inventory adjustment.
but I am having some problems with item fulfillment.
from my understanding when I use a transform request on a salesorder it gets picked(this is what happened). if this is true what requests do I need to send in order to change it to packed and then and then shipped.
b
battk
10/07/2021, 3:05 PMbattk
10/07/2021, 3:05 PMthe shipping status is another field that you set
s
Sahar Turgeman
10/10/2021, 12:05 PMHello again friend.
I am trying to understand the process for item fulfillment; correct me if I'm wrong but If the advanced shipping feature is enabled, fulfillment and invoicing are two independent processes and I first need to transform the salesOrder to a invoice and then itemFulfillment.
b
battk
10/10/2021, 7:45 PMbattk
10/10/2021, 8:01 PMdifferent features and preferences control the order in which you can bill and fulfill
3 Views