I have a saved search on item fulfillments, and I'...
# ask-stanley-ai
v
I have a saved search on item fulfillments, and I'm retrieving values from the "Applying To Transaction" field. However, I'm not getting results for other charge items.
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that the issue you're facing is related to the way NetSuite handles the "Applying To Transaction" field in saved searches. When you're dealing with Item Fulfillments, they are considered as Applying Transactions for Sales Orders. However, the link to the Sales Order doesn't work until the Item Fulfillment actually ships. If the Item Fulfillment is just in a picked or packed status, the link can't source data. One workaround suggested in the conversations is to create the search from the fulfillment side. In other words, set the Type to Item Fulfillment, then source fields from the Sales Order via Created From / Applied To. However, this approach might not be able to retrieve a lot of line level details from the Sales Order that are sourced from other joins on the Sales Order itself. Another point to note is that the "Applying To Transaction" field might not provide line level details from the Sales Order. It seems that the item information is a separate sublist on the record and the bill payment is only "applied" to the header information (AP account), so you might run into the multiple join limitation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.86114651
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846653759
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844662786
Please provide your feedback on this answer.