the itemfulfillment field on the item receipt (created from TO) transaction in the UI has a value but cannot be pulled from suiteql. are there other ways to fetch the itemfulfillment from the itemreceipt via SuiteQL?

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the

itemfulfillment

field on the

itemreceipt

(created from TO) transaction in the UI cannot be directly fetched using SuiteQL. However, there are a few potential workarounds that you can try: 1. Initialize an Item Receipt from the Transfer Order: Instead of trying to pull the

itemfulfillment

field directly, you can initialize an item receipt from the transfer order. This might allow you to indirectly access the

itemfulfillment

field. 2. Use the auxReference Element: Another approach is to use the

auxReference

element to specify which

itemFulfillment

you are receiving. This might allow you to fetch the

itemfulfillment

from the

itemreceipt

. 3. Check Fulfillment Settings: The automatic checking of the

receive

box is driven by your fulfillment settings. If the

receive

box is not being automatically checked for non-inventory items, you might need to manually set it to true. 4. Use SuiteScript: If you're comfortable with SuiteScript, you can try to fulfill the order using the debugger. Here's a sample code snippet provided in the conversation:

javascript
require(["N/record"], function(record) {
  var ifRec = record.transform({
    fromType: "salesorder",
    fromId: "624",
    toType: "itemfulfillment"
  });
  ifRec.setSublistValue({
    fieldId: "itemreceive",
    sublistId: "item",
    value: true,
    line: 0
  });
  ifRec.save();
});

Remember to replace

"624"

with your actual sales order ID. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******