Anyone able to help with an Item Fulfillment quest...
# general
d
Anyone able to help with an Item Fulfillment question. Trying to integrate with NetSuite but it keeps giving me and error. was working until client decided to change a setting now I have no clue what is wrong been at this for 4 days now
ablobthinking 1
b
Use Pick Pack Ship?
d
yes. but not in Netsuite. we import and sync sales orders created in netsuite with our system. then user picks items in our system that are shipping. We send an Item Fulfillment to NetSuite. using the call salesorder/1942666/!transform/itemfulfillment?init=inventorylocation:120. This worked fine until user changed a setting. "Default Items to Zero Received/Fulfilled" preference in NetSuite from enabled to disabled. So.... I read that with this you have to send all the lines on the sales order in the item fulfillment but set the lines I'm not shipping to itemReceive : false. did that. doesn't work. been at this for 3 days now trying to figure out how to get the integration to work again. here is my latest JSON
Copy code
{
  "memo": "",
  "item": {
    "items": [
      {
        "orderLine": 1,
        "itemReceive": false
      },
      {
        "orderLine": 2,
        "item": {
          "id": "2464"
        },
        "location": {
          "id": "120"
        },
        "inventorylocation": {
          "id": "120"
        },
        "itemReceive": true,
        "quantity": 5,
        "inventoryDetail": {
          "inventoryAssignment": {
            "items": [
              {
                "quantity": 5,
                "issueInventoryNumber": {
                  "id": "98744"
                },
                "inventoryStatus": {
                  "id": "1"
                }
              }
            ]
          }
        }
      },
      {
        "orderLine": 3,
        "itemReceive": false
      }
    ]
  }
}
"Error while accessing a resource. 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."
Sales order line 1 is already fulfilled (before change) lines 2 and 3 still open, but only want to ship from line 2
b
is this through SOAP?
d
Rest API
SuiteTalk api
b
Should it be line, not orderLine?
I also don't see inventorylocation as a choice in that sublist
d
so line gives me the same error. If you take out item 1 and 3 that would have been my original message that used to work before the setting changed
1
b
I don't have direct experience with this just noodling with you
have you tried excluding line 1 and 3?
d
yeah different error
oh nvm same error
d
Do they have a Sandbox copy that has NOT been monkeyed with? If so, maybe you could reference that to find the possible changes?
d
the change was in sandbox
me and postman getting to be real good friends. just started when they set that option in NetSuite so I was able to recreate it. Lucky product is still up, its just they want it working with that option and there is no documentation on that. scrubbed the NetSuite docs. Even copied my S/O json to AI and all the docs for itemfulfillment to AI and even it gets the same error
@Dan Curtis The change was unchecking the Default Items to Zero Received/Fulfilled option. What I found searching was you then have to send all line items with itemReceive : false for lines you don't want to fulfill. That field supposed to simulate the check box you get in the UI. but just fails with the most descriptive error message. Everything works fine if I turn that setting back on.