How on a Sales Order can we display in an item lis...
# ask-stanley-ai
a
How on a Sales Order can we display in an item list row, values from the fields on the Purchase Order that was dropshipped from that Sales Order row?
c
AI generated answer (using internal Slack threads):
To display values from the fields on the Purchase Order that was dropshipped from a Sales Order row, you would need to create a custom field on the Sales Order line level and then use a User Event or Scheduled script to populate this field. Here's a high-level overview of how you could achieve this: 1. Create a custom field on the Sales Order line level where you want to display the Purchase Order information. This field should be of the type that matches the data you want to display (e.g., text, number, date, etc.). 2. Write a User Event script that triggers on the creation or editing of a Purchase Order. This script should check if the Purchase Order is a dropship (you can do this by checking the related records subtab for a linked Sales Order with a Link Type of 'drop ship'). 3. If the Purchase Order is a dropship, the script should then find the corresponding Sales Order and line item (you can do this by using the
record.load
method to load the Sales Order record and then iterating over the line items until you find the one that matches the Purchase Order). 4. Once the script has found the corresponding Sales Order line item, it should then set the value of the custom field you created in step 1 to the desired value from the Purchase Order. 5. Save the Sales Order record to persist the changes. Please note that this is a high-level overview and the actual implementation may vary depending on your specific requirements and NetSuite setup. Also, this approach requires knowledge of SuiteScript, NetSuite's JavaScript-based scripting language. ****** 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.846609712
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837357044
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834722221
Please provide your feedback on this answer.